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 2724

Option A

A.    King 17-JUN-87 1500
 

Option B

B.    King17-JUN-87 24000
 

Option C

C.    King current sysdate 1500

 

Option D

D.    King current sysdate 24000

Correct Answer b
Explanation


Question ID 2726

View the Exhibit and examine the structure of the customer table.
You need to create a trigger to ensure that customers in category “A” and “B” have a credit limit of more than 8000.
Examine the following trigger.
 
Which statement is correct about the outcome of this trigger?

Option A

A.    It compiles successfully and fires whenever the specified condition is met.
 

Option B

B.    It compiles successfully but does not fireeven when the condition is met
 

Option C

C.    It gives an error on compilation because the new qualifier is prefixed with a colon.

 

Option D

D.    It gives an error on compilation because the new qualifier can be used only in row-level triggers.

Correct Answer A
Explanation

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