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 4808

You created an ORDERS table with the following description:
Exhibit:
 
You inserted some rows in the table. After some time, you want to alter the table by creating the PRIMARY KEY constraint on the ORD_ID column.
Which statement is true in this scenario?

Option A

A.    The primary key constraint can be created only a the time of table creation
 

Option B

B.    You cannot add a primary key constraint if data exists in the column
 

Option C

C.    You cannot have two constraints on one column
 

Option D

D.    You can add the primary key constraint even if data exists, provided that there are no duplicate values
 

Correct Answer D
Explanation


Question ID 4809

Examine the structure of the INVOICE table:
Exhibit:
 
Which two SQL statements would execute successfully? (Choose two.)

Option A

A.    SELECT inv_no,NVL2(inv_amt,inv_date,'Not Available') FROM invoice;
 

Option B

B.    SELECT inv_ no,NVL2(inv_date,'Pending','Incomplete')
 
FROM invoice;
 

Option C

C.    SELECT inv_ no,NVL2(inv_date,inv_amt*.25,'Not Available') FROM invoice;
 

Option D

D.    SELECT inv_ no,NVL2(inv_date,sysdate-inv,sysdate) FROM invoice;
 

Correct Answer B,D
Explanation

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