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- 1z0-061





Question ID 2319

You issue the following command to drop the products table:
SQL> DROP TABLE products;
Which three statements are true about the implication of this command?
 

Option A

A.    All data along with the table structure is deleted.
 

Option B

B.    A pending transaction in the session is committed.
 

Option C

C.    All indexes on the table remain but they are invalidated.
 

Option D

D.    All views and synonyms remain but they are invalidated.

 

Option E

E.    All data in the table is deleted but the table structure remains.

Correct Answer A,B,D
Explanation


Question ID 2320

Evaluate the following SQL statement:
 
Which statement is true regarding the above query if one of the values generated by the subquery is null?

Option A

A.    It produces an error.
 

Option B

B.    It executes but returns no rows.
 

Option C

C.    It generates output for null as well as the other values produced by the subquery.

 

Option D

D.    It ignores the null value and generates output for the other values produced by the subquery.

Correct Answer C
Explanation

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