AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


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
WHERE empno = 101;
 

Option C

C.    PROCEDURE calc_ max (n1 NUMBER,n2 NUMBER,p_max OUT NUMBER) IS BEGIN
IF n1 > n2 THEN
 
p_max := n1; ELSE
p_max := n2; END;
 

Option D

D. BEGIN
emp_rec emp%ROWTYPE; END;
 

Correct Answer B
Explanation


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
Explanation

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