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 21044

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

All data along with the table structure is deleted.

Option B

A pending transaction in the session is committed.

Option C

All indexes on the table remain but they are invalidated.

Option D

All views and synonyms remain but they are invalidated.

Option E

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

Correct Answer A,B,D
Explanation


Question ID 21045

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

It produces an error.

Option B

It executes but returns no rows.

Option C

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

Option 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!!!