Oracle Database: Advanced PL/SQL - 1z0-148 Exam Practice Test

A. 2 and 3

B. 1 and 4

C. 1 and 3

D. 2 and 4

E. 2, 3 and 4

A. It stores hash values in hierarchical profiler tables in the database.

B. It executes a script to create hierarchical profiler tables in the database.

C. It produces HTML output from raw profiler output.

D. It produces HTML output from hierarchical profiler tables in the database.

E. It produces raw profiler output for the most recently executed PL/SQL block.

A. A NOEXIST_DIRECTORY exception can be raised when using internal and external LOBs.

B. An external LOB can be loaded into an internal LOB variable using the DBMS_LOB package.

C. Internal and external LOBs can be written using DBMS_LOB.

D. After an exception transfers program control outside a PL/SQL block, all references to open external LOBs are lost.

E. When using DBMS_LOB.INSTR for internal and external LOBs, DBMS_LOB.OPEN should be called for each LOB.

A. EXEC get_tab_row_count ('SCOTT.EMP');

B. EXEC get_tab_row_count ('DEPT');

C. EXEC get_tab_row_count ('emp');

D. EXEC get_tab_row_count ('DEPT, EMP')

E. EXEC get_tab_row_count (' "EMP" ');

A. When a session executes an insert, update, or delete statement on a table or view that is queried by the result-cached function

B. When a session on this database instance invokes the function with the same parameter values

C. When a new session is opened to invoke the function which is already cached

D. When the RESULT_CACHE_MODE parameter is set to FORCE.

E. When the memory allocated to the server result cache is increased using the RESULT_CACHE_MAX_SIZE initialization parameter

A. A performance compilation warning is generated.

B. A severe compilation warning is generated.

C. It fails compilation.

D. An information compilation warning is generated.

E. There are no compilation warnings or errors.

A. Using bind variables instead of directly concatenating parameters into dynamic SQL statements

B. Not validating parameters which are concatenated into dynamic SQL statements

C. Validating parameters before concatenating them into dynamic SQL statements

D. Having excess database privileges

E. Using automated tools to generate code

A. SELECT SYS_CONTEXT ('USERENV', 'ACCOUNT_MGR') FROM dual;

B. SELECT USERENV ('ACCOUNT_MGR') FROM dual;

C. SELECT USERENV ('ORDER_CTX') FROM dual;

D. SELECT SYS_CONTEXT ('ACCOUNT_MGR', 'ORDER_CTX') FROM dual;

E. SELECT SYS_CONTEXT ('ORDER_CTX', 'ACCOUNT_MGR') FROM dual;