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-144





Question ID 2644

User SCOTT has been granted CREATE ANY TRIGGER AND ALTER ANY TABLE by the DBA. HR is an existing schema in the database.
SCOTT creates the following trigger:
CREATE OR REPLACE TRIGGER drop_trigger
BEFORE DROP ON hr.SCHEMA
BEGIN
RAISE_APPLICATION_ERROR (-20000, ‘Cannot drop object');
END:
 
SCOTT does not grant the execute privilege on this trigger to any other users.
For which user(s) would this trigger fire by default when they drop an object in the hr schema?
 

Option A

A.    Only HR
 

Option B

B.    SCOTT and HR
 

Option C

C.    Only SCOTT
 

Option D

D.    SCOTT, HR, and SYS
 

Correct Answer A
Explanation


Question ID 2645

Which two statements are true about the continue statement? (Choose two.)
 

Option A

A.    The PL/SQL block execution terminates immediately.
 

Option B

B.    The CONTINUE statement cannot appearoutside a loop.
 

Option C

C.    The loop completes immediately and control passes to the statement after end loop.
 

Option D

D.    The statements after the continue statement in the iteration are executed before terminating the LOOP.
 

Option E

E.    The current iteration of the loop completes immediately and control passes to the next iteration of the loop
 

Correct Answer B,E
Explanation

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