READ Free Dumps For Oracle- 1z0-146

Question ID 2767	You created a procedure as follows: CREATE OR REPLACE PROCEDURE query_prod(twhr VARCHAR2) IS stmt VARCHAR2(100); pname VARCHAR2(20); BEGIN stmt:='SELECT product_name FROM products WHERE product_id=:2'; EXECUTE IMMEDIATE stmt INTO pname USING twhr; DBMS_OUTPUT.PUT_LINE(pname); END; / View the Exhibit to examine the structure of PRODUCTS table.   Which statement is true about the procedure?
Option A	A.    It produces an error when invoked.
Option B	B.    It can be invoked only from a PL/SQL block.
Option C	C.    It reduces the chances of SQL injection by using bind arguments.
Option D	D.    The values for bind arguments remain persistent in the session after the execution of the procedure.
Correct Answer	C

Explanation

Question ID 2768	View Exhibit1 and examine the structure of the EMPLOYEES table.   View Exhibit2 and examine the code in the PL/SQL block. The PL/SQL block fails to execute. What could be the reason?
Option A	A.    Nested tables cannot be returned by a function.
Option B	B.    The NEWNAMES nested table has not been initialized.
Option C	C.    The assignment operator cannot be used to transfer all the element values from GROUP1 to GROUP2.
Option D	D.    The third element of OLDNAMES cannot be assigned to the third element of GROUP1 because they are of inconsistent data types.
Option E	E.    LAST_NAME values cannot be assigned to the V_LAST_NAMES nested table because local collection types are not allowed in SQL statements.
Correct Answer	E

Explanation

Previous-Page 1 2. . . 15 16 17 18 19 20 21. . . 93 94 Next-Page

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