READ Free Dumps For Oracle- 1z0-001
Question ID 1559 | Which statement is valid within the executable section of a PL/SQL block? |
Option A | A. WHEN NO_DATA_FOUND THEN DBMS_OUTPUT.PUT_LINE ('No records found'); |
Option B | B. SELECT ename, sal INTO v_ename, v_sal FROM emp |
Option C | C. PROCEDURE calc_ max (n1 NUMBER,n2 NUMBER,p_max OUT NUMBER) IS BEGIN |
Option D | D. BEGIN |
Correct Answer | B |
Question ID 1560 | A DBA has updated Smith's account by adding the privileges CREATE ANY TABLE and CREATE PROCEDURE. Which tasks can Smith successfully perform? |
Option A | A. Smith can create a table in any schema of the database but can drop tables from and create procedures only in his schema. |
Option B | B. Smith can create any table or procedure only in his schema. Also, he can drop any table only from his schema. |
Option C | C. Smith can create tables, drop tables and create procedures in any schema of the database. |
Option D | D. Smith can create a table or a procedure in any schema of the database. Also, he can drop a table in any schema of the database. |
Correct Answer | A |