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 2731

View the exhibit and examine the structure of the EMPLOYEE table.
EMPLOYEE_SEQ is an existing sequence. Examine the following block of code:
 
Which statement is true about the above block of code?

Option A

A.    It consists of two transactions
 

Option B

B.    It consists of a single transaction,
 

Option C

C.    The data is automatically committed after the block execution ends,
 

Option D

D.    It gives an error on execution because sequences cannot be used in anonymous blocks.
 

Correct Answer A
Explanation


Question ID 2732

View the Exhibit and examine the structure of the customer table.
 
 
You create the following trigger to ensure that customers belonging to category "A" or "B" in the customer table can have a credit limit of more than 8000.

What is the outcome?

Option A

A.    The trigger is fired, a message is displayed, and the update is successful
 

Option B

B.    The trigger is fired and a message is displayed, but the update is rolled back.
 

Option C

C.    The trigger is not fired because the when clause should be used to specify the condition, however, the update is successful.
 

Option D

D.    The trigger is not fired because column names must be specified with the update event to identify which columns must be changed to cause the trigger to fire, however, the update is successful.
 

Correct Answer D
Explanation

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