Millionaire Mode

Oracle Database Administration and Networking

Question 1 of 20

Examine the statement : DROP TABLESPACE IND2 INCLUDING CONTENTS AND DATAFILES; What is the result of the statement?

  1. The contents and data files belonging to the IND2 tablespace are dropped.
  2. The statement will only succeed if the IND2 tablespace was built using Oracle-Managed Files (OMF) data files.
  3. The statement will only succeed if the data files belonging to the IND2 tablespace are Oracle Managed Files (OMF) or of the database was created using OMF.
  4. The contents of the tablespace are dropped along with all its data files except those identical with Oracle-Managed Files (OMF) naming convention.

Prize Money

15₹7 Crores
14₹1 Crore
13₹50,00,000
12₹25,00,000
11₹12,50,000
10₹6,40,000
9₹3,20,000
8₹1,60,000
7₹80,000
6₹40,000
5₹20,000
4₹10,000
3₹5,000
2₹2,000
1₹1,000