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- 1z1-051





Question ID 4777

Which statements are correct regarding indexes? (Choose all that apply.)
 

Option A

A.    For each data manipulation language operation performed, the corresponding indexes are automatically updated
 

Option B

B.    A no deferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a unique index
 

Option C

C.    A FOREIGN KEY constraint on a column in a table automatically creates a non unique key
 

Option D

D.    When a table is dropped, the corresponding indexes are automatically dropped
 

Correct Answer A,B,D
Explanation


Question ID 4778

You work as a database administrator at ABC.com. You study the exhibit carefully.
Exhibit:
 
Which two SQL statements would execute successfully? (Choose two.)

Option A

A.    UPDATE promotions
SET promo_cost = promo_cost+100
WHERE TO_CHAR(promo_end_date,'yyyy'>'2000';
 

Option B

B.    SELECT promo_begin_date FROM promotions
 
WHERE TO_CHAR(promo_begin_date,'mon dd yy')='jul 01 98';
 

Option C

C.    UPDATE promotions
SET promo_cost = promo_cost+100
WHERE promo_end_date > TO_DATE(SUBSTR('01-JAN-200',8));
 

Option D

D.    SELECT TO_CHAR(promo_begin_date,'dd/month')
FROM promotions
WHERE promo_begin_date IN (TO_DATE('JUN 01 98',TO_DATE('JUL 01 98'));
 

Correct Answer A,B
Explanation

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