Oracle Database: Advanced PL/SQL: 1Z0-148

Which two statements are true about associative arrays and varrays? (Choose two.)

A. Only varrays must use sequential numbers as subscripts.

B. Only varrays can be used as column types in database tables.

C. Both associative arrays and varrays must use sequential numbers as subscripts.

D. Both associative arrays and varrays can be used as column types in database tables.

You are designing and developing a complex database application built using many dynamic SQL statements. Which option could expose your code to SQL injection attacks?

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

B. Using automated tools to generate code

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

D. Validating parameters before concatenating them into dynamic SQL statements

E. Having excess database privileges

Examine this code:

The anonymous block fails with:

ERROR at line 1:

ORA-01403: no data found

ORA-06512: at line 5

Which two are valid options to prevent this error from occurring?

A. Line 5 should be replaced with: DBMS_LOB.CREATETEMPORARY (pdatabuf (1), TRUE, DBMS_LOB.CALL);

B. Line 5 should be replaced with: DBMS_LOB.CREATETEMPORARY (pdatabuf (1), FALSE, DBMS_LOB.SESSION);

C. Rewrite the block as: DECLARE TYPE databuf_arr IS TABLE OF CLOB INDEX BY BINATY_INTEGER; pdatabuf databuf_arr; PROCEDURE mytemplob (x OUT CLOB) IS BEGIN DBMS_LOB.CREATETEMPORARY (x, TRUE, DBMS_LOB.SESSION); END; BEGIN mytemplob (pdatabuf (1)); END; /

D. pdatabuf (1) := NULL; should be added after line 4.

E. Line 5 should be replaced with: DBMS_LOB.CREATETEMPORARY (pdatabuf, TRUE, DBMS_LOB.SESSION);