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 4791

You work as a database administrator at ABC.com. You study the exhibit carefully.
 
Exhibit:
 
and examine the structure of CUSTOMRS AND SALES tables: Evaluate the following SQL statement:
Exhibit:
 
Which statement is true regarding the execution of the above UPDATE statement?

Option A

A.    It would not execute because the SELECT statement cannot be used in place of the table name
 

Option B

B.    It would execute and restrict modifications to only the column specified in the SELECT statement
 

Option C

C.    It would not execute because a sub query cannot be used in the WHERE clause of an UPDATE statement
 

Option D

D.    It would not execute because two tables cannot be used in a single UPDATE statement
 
 

Correct Answer B
Explanation


Question ID 4792

See the Exhibit and examine the structure of the PROMOTIONS table:
Exhibit:
 
Using the PROMOTIONS table, you need to find out the average cost for all promos in the range $0-2000 and $2000-5000 in category A.
You issue the following SQL statements: Exhibit:
 
What would be the outcome?

Option A

A.    It generates an error because multiple conditions cannot be specified for the WHEN clause
 

Option B

B.    It executes successfully and gives the required result
 

Option C

 
C.    It generates an error because CASE cannot be used with group functions
 

Option D

D.    It generates an error because NULL cannot be specified as a return value
 

Correct Answer B
Explanation

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