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 1544

Evaluate this SQL script:
CREATE ROLE manager;
CREATE ROLE clerk;
CREATE ROLE inventory;
CREATE USER scott IDENTIFIED BY tiger;
GRANT inventory TO clerk;
GRANT clerk TO manager;
GRANT inventory TO scott
/
How many roles will user SCOTT have access to?
 

Option A

A.    2
 

Option B

B.    3
 

Option C

C.    0
 

Option D

D.    1
 

Correct Answer D
Explanation


Question ID 1545

Evaluate this PL/SQL block:
BEGIN
FOR i IN 1..5 LOOP
IF i = 1 THEN null;
ELSIF i = 3 THEN COMMIT;
ELSIF i = 5 THEN ROLLBACK;
ELSE INSERT INTO test(results)
VALUES(i);
END IF;
END LOOP;
COMMIT;
END;
How many values will be permanently inserted into the TEST table?

 

Option A

A.    2
 

Option B

B.    1
 

Option C

C.    5
 

Option D

D.    0
 

Correct Answer B
Explanation

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