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 4783

You work as a database administrator at ABC.com. You study the exhibit carefully.
Exhibit:
 
The CUSTOMERS table contains the current location of all currently active customers. The CUST_HISTORY table stores historical details relating to any changes in the location of all current as well as previous customers who are no longer active with the company.
You need to find those customers who have never changed their address. Which SET operator would you use to get the required output?

Option A

A.    INTERSECT
 

Option B

B.    UNION ALL
 

Option C

C.    MINUS
 

Option D

D.    UNION
 

Correct Answer C
Explanation


Question ID 4784

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.    You cannot add a primary key constraint if data exists in the column
 

Option B

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

Option C

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

Option D

D.    You cannot have two constraints on one column
 

Correct Answer B
Explanation

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