Free Oracle 1z1-148 Exam Dumps Questions & Answers

Which statement describes the plshprof command-line utility?

• A.It executes a script to create hierarchical profiler tables in the database.
• B.It stores hash values in hierarchical profiler tables in the database.
• C.It produces HTML output from hierarchical profiler tables in the database.
• D.It produces raw profiler output for the most recently executed PL/SQL block.
• E.It produces HTML output from raw profiler output.

Which two PL/SQL blocks give the output "this is a test message"?

• A.BEGINDBMS_OUTPUT.PUT_LINE (DBMS_ASSERT.ENQUOTE_NAME (' "this is a "test" message" ', TRUE));END;
• B.BEGINDBMS_OUTPUT.PUT_LINE (DBMS_ASSERT.ENQUOTE_NAME ('this is a " "test" " message', TRUE));END;
• C.BEGINDBMS_OUTPUT.PUT_LINE (DBMS_ASSERT.ENQUOTE_NAME ('this is a test message ', FALSE));END;
• D.BEGINDBMS_OUTPUT.PUT_LINE (DBMS_ASSERT.ENQUOTE_NAME ('this is a test message', TRUE));END;
• E.BEGINDBMS_OUTPUT.PUT_LINE (DBMS_ASSERT.ENQUOTE_NAME (' "this is a test message"
  ', TRUE));END;

Identify the three options which make a PL/SQL function highly suitable for using the RESULT_CACHE clause in its definition. (Choose three.)

• A.The function involves highly computational logic with minimal or no database access.
• B.The tables which are read in the function are very frequently updated.
• C.The code in the function performs more write operations on the database when compared to the read operations.
• D.The value returned by the function is deterministic for a given set of input parameters.
• E.The logic in the function accesses tables or uses package variables which are modified very rarely.
• F.The function has complex business logic depending on more than five tables to compute its return values.

Examine these statements regarding the DBMS_RESULT_CACHE package:
1.DBMS_RESULT_CACHE provides subprograms to administer the part of the shared pool used by the PL/ SQL function result cache only.
2.DBMS_RESULT_CACHE provides subprograms to administer the part of the shared pool used by both the PL/SQL function result cache and the SQL result cache.
3.DBMS_RESULT_CACHE package is owned by the SYS user.
4.RESULT_CACHE_MODE can be set using a subprogram defined in the DBMS_RESULT_CACHE package.
Which set of statements is correct?

• A.1 and 4
• B.2, 3 and 4
• C.2 and 4
• D.2 and 3
• E.1 and 3

Which two statements are true about the DBMS_ LOB package?

• A.DBMS_LOB.COMPARE can compare parts of two LOBs.
• B.If the destination LOB is a temporary LOB, the row must be locked before calling DBMS_LOB.CONVERTTOBLOB.
• C.DBMS_LOB.COMPARE is overloaded and can compare CLOBs with BLOBs.
• D.DBMS_LOB.COMPARE returns the size difference of the compared LOBs.
• E.Before calling DBMS_LOB.CONVERTTOBLOB, both the source and destination LOB instances must exist.