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 4773

You work as a database administrator at ABC.com. You study the exhibit carefully.
PROMOTIONS table Exhibit:
 
 
SALES table Exhibit:
 
Evaluate the following SQL statements: Exhibit:
 
Which statement is true regarding the output of the above query?

Option A

A.    It gives details of product IDs that have been sold irrespective of whether they had a promo or not
 

Option B

B.    It gives the details of promos for which there have been no sales
 

Option C

C.    It gives the details of promos for which there have been sales
 

Option D

D.    It gives details of all promos irrespective of whether they have resulted in a sale or not
 

Correct Answer D
Explanation


Question ID 4774

Evaluate the following SQL statements:
Exhibit:                                                                                                  
You issue the following command to create a view that displays the IDs and last names of the sales staff in the organization.
Exhibit:
 
Which two statements are true regarding the above view? (Choose two.)

Option A

A.    It allows you to insert IDs, last names, and job IDs of the sales staff from the view if it is used in multitable INSERT statements
 

Option B

B.    It allows you to update job IDs of the existing sales staff to any other job ID in the EMPLOYEES table
 

Option C

C.    It allows you to delete details of the existing sales staff from the EMPLOYEES table
 

Option D

D.    It allows you to insert rows into the EMPLOYEES table
 

Correct Answer A,C
Explanation

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