READ Free Dumps For Oracle- 1z0-146

Question ID 2737	View the Exhibit and examine the structure of the EMPLOYEES table.     Examine the following PL/SQL block: DECLARE TYPE EmpList IS VARRAY(2) OF employees.employee_id%TYPE NOT NULL; v_employees EmpList := EmpList(); BEGIN DBMS_OUTPUT.PUT_LINE(v_employees.COUNT); v_employees.EXTEND; v_employees(1) := 30; END; / Which statement is true about the outcome on executing the above PL/SQL block?
Option A	A.    It executes successfully and displays the value 2.
Option B	B.    It executes successfully and displays the value 0.
Option C	C.    It generates an error because EXTEND cannot be used for varrays.
Option D	D.    It generates an error because the declaration of the varray is not valid.
Correct Answer	B

Explanation

Question ID 2738	View the Exhibit and examine the procedure to create a trigger name based on the table name supplied to the procedure.     Which three statements are appropriate for protecting the code in the procedure from SQL injection? (Choose three.)
Option A	A.    Explicitly validate the identifier length limit.
Option B	B.    Add AUTHID DEFINER to the definition of the procedure.
Option C	C.    Use PRAGMA RESTRICT_REFERENCES in the procedure.
Option D	D.    Filter out control characters in user-supplied identifier names.
Option E	E.    Use the object ID of the table from the data dictionary to build the trigger name.
Correct Answer	A,D,E

Explanation

Previous-Page 1 2 3 4 5 6 7 8 9. . . 93 94 Next-Page

Send email to admin@getfreedumps for new dumps request!!!