Examine this declaration section:

Which two executable sections will display the message 'Summary is null'?

• A. BEGIN1_rec.emp_id :=1;1_rec.expr_summary := NULL;1_emp :=emp_typ (1_rec);IF
  1_emp(1).expr_summary IS NULL THENDBMS_OUTPUT.PUT_LINE ('Summary is null');END IF;END;
• B. BEGIN1_rec := NULL;1_emp := emp_typ (1_rec);IF 1_emp (1).expr_summary IS EMPTY THENDBMS_OUTPUT.PUT_LINE ('Summary is null');END IF;END;
• C. BEGIN1_rec.emp_id :=1;1_rec.expr_summary := EMPTY_CLOB ();1_emp := emp_typ (1_rec);IF
  1_emp(1).expr_summary IS NULL THENDBMS_OUTPUT.PUT_LINE ('Summary is null');END IFEND;
• D. BEGIN1_emp := emp_typ ();IF NOT 1_emp. EXISTS (1) THENDBMS_OUTPUT.PUT_LINE ('Summary is null');END IFEND;
• E. BEGIN1_emp. EXTEND;IF NOT 1_emp. EXISTS (1) THENDBMS_OUTPUT.PUT_LINE ('Summary is null');END IFEND;

Which data dictionary view contains the list of procedures and functions defined within package specification that you can execute?

• A. ALL_PROCEDURES
• B. ALL_DEPENDENCIES
• C. ALL_PLSQL_OBJECT_SETTINGS
• D. ALL_OBJECTS
• E. ALL_SOURCE

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. Not validating parameters which are concatenated into dynamic SQL statements
• C. Using automated tools to generate code
• D. Validating parameters before concatenating them into dynamic SQL statements
• E. Having excess database privileges

Which three statements are true about varrays in a database table column? (Choose three.)

• A. A varray used as a column in a database table must be initialized to null.
• B. A varray is always stored in the same segment as the table in which it is defined.
• C. A varray's size can be increased beyond the maximum number of elements specified in the definition.
• D. The data in a single element of a varray can be changed through either PL/SQL or SQL.
• E. A varray may be stored outside the table segment in which it is defined but still in the same tablespace.
• F. A varray used as a column in a database table must be initialized to empty.
• G. The data in a single element of a varray can only be changed through PL/SQL.
• H. A varray's size can be both increased and decreased from the maximum number of elements specified in the definition.