1Z0-146 試験問題を無料オンラインアクセス

View the Exhibit and examine the output.

Which statement is an inference from the output?

• A.The loadjava command has been executed to load the Java source and class files.
• B.Java class methods in the Java class file have been published.
• C.The class file has been loaded into the shared library.
• D.The class file is pinned into the Java pool.

You issue the following command to create the PRINT_MEDIA table.
CREATE TABLE print_media
(product_id NUMBER(3),
ad_sourcetext CLOB,
ad_photo BLOB);
Evaluate the following INSERT statements:
INSERT INTO print_media VALUES (1, empty_clob(),empty_blob());
INSERT INTO print_media VALUES (2,'This is a One Line Story',null);
INSERT INTO print_media VALUES (3,'This is another One Line Story',empty_blob());
INSERT INTO print_media VALUES (4,empty_clob(),to_blob('This is new Story'));
Which of the above INSERT statements are valid?

• A.All the statements are valid.
• B.Only the first and second statements are valid.
• C.Only the first, second and third statements are valid.
• D.Only the first statement is valid.
• E.Only the first and fourth statements are valid.

View the Exhibit and examine the PL/SQL code.

Identify the sections of the code that need to be modified for better performance gains. (Choose all that apply.)

• A.Define and compile procedures independently, and not as part of a package.
• B.Avoid the NOT NULL constraint when declaring the variable.
• C.Use cursors to fetch values.
• D.Remove redundant SQL statements in the procedures.

You executed this command to gather information about the memory allocation for storing query
results:
SQL> execute dbms_result_cache.memory_report
View the Exhibit and examine the output for the execution of the
DBMS_RESULT_CACHE.MEMORY_REPORT procedure.
Which two statements are true about the output in the Exhibit? (Choose two.)

• A.In total, four blocks are used by the result cache.
• B.Currently 32 KB is allocated to the result cache.
• C.Currently 52 KB is allocated to the result cache.
• D.The result cache can be increased by 65628 bytes.

The PLSQL_OPTIMIZE_LEVEL parameter is set to 2 for the session.
Examine the section of code given:
FUNCTION p2 (p boolean) return PLS_INTEGER IS ...
FUNCTION p2 (x PLS_INTEGER) return PLS_INTEGER IS
... ...
PRAGMA INLINE(p2, 'YES');
x := p2(true) + p2(3);
...
Which statement is true about the INLINE pragma procedure calls?

• A.Only the call to the P2 function with BOOLEAN as the argument is inlined.
• B.INLINE pragma affects both the functions named P2 and is called inline.
• C.Only the call to the P2 function with PLS_INTEGER as the argument is inlined.
• D.None of the functions are inlined because inlining is not supported for overloaded functions.