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 2652

You want to create a trigger that fires whenever rows are deleted from the customer table and that displays the number of rows remaining in the table.
Which two statements are correct about the trigger to be created for the above requirement? (Choose two.)
 

Option A

A.    It should be an after trigger.
 

Option B

B.    It should be a before trigger.
 

Option C

C.    It should be a row-level trigger.
 

Option D

D.    It should be a statement-level trigger.
 

Option E

E.    It can be a before or an after trigger.
 

Correct Answer A,C
Explanation


Question ID 2653

Examine the following code that you plan to execute:
 
What correction should be performed in the above code?

Option A

A.    The PROC2 procedure code should be defined in the package body.
 

Option B

B.    The PROC3 procedure should be declared in the package specification.
 

Option C

C.    The PROC3 procedure header should be declared at the beginning of the package body.

 

Option D

D.    The variable x must be declared in the package body and removed from the specification,

Correct Answer A,B
Explanation

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