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 4765

You issue the following command to drop the PRODUCTS table:
SQL>DROP TABLE products;
What is the implication of this command? (Choose all that apply.)
 

Option A

A.    All data in the table are deleted but the table structure will remain
 

Option B

B.    All data along with the table structure is deleted
 

Option C

C.    All view and synonyms will remain but they are invalidated
 

Option D

D.    The pending transaction in the session is committed
 

Option E

E.    All indexes on the table will remain but they are invalidated
 

Correct Answer B,C,D
Explanation


Question ID 4766

Exhibit contains the structure of PRODUCTS table:
Exhibit:
 
Evaluate the following query:
 
 
What would be the outcome of executing the above SQL statement?

Option A

A.    It produces an error
 

Option B

B.    It shown the names of products whose list price is the second highest in the table
 

Option C

C.    It shown the names of all products whose list price is less than the maximum list price
 

Option D

D.    It shows the names of all products in the table
 

Correct Answer B
Explanation

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