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 2729

View the Exhibit and examine the structure of the AUDIR_CUST table.
Exhibit Missing
CUST_ID and CUST_LIMIT are existing columns in the CUSTOMER table. Examine the following trigger code:
 
Which statement is true about the above trigger?

Option A

A.    It gives an error on compilation because it should be a statement-level trigger.
 

Option B

B.    It compiles and fires successfully when the credit limit is updated in the customer table.
 

Option C

C.    It gives an error on compilation because of the commit command in the trigger code
 

Option D

D.    It compiles successfully, but gives an error when the credit limit is updated in the CUSTOMER table because the PRAGMA AUTONOMOUS_TRANSACTION statement should be introduced in the trigger.
 

Correct Answer D
Explanation


Question ID 2730

Which three statements are true about anonymous blocks and subprograms? (Choose three.)
 

Option A

A.    Only subprograms can be parameterized.
 

Option B

B.    Only subprograms are persistent database objects.
 

Option C

C.    Both anonymous blocks and subprograms can be parameterized.
 

Option D

D.    Both anonymous blocks and subprograms are persistent database objects
 

Option E

E.    Only subprograms can return values that persist after the execution of the subprogram.
 

Option F

F.    Both anonymous blocks and subprograms can return values that persist In SQL*Plus variables after their execution.
 

Correct Answer B,E,F
Explanation

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