Correct Answer: TRUNCATE CLUSTER emp_desg DROP ALL STORAGE;
Explanation:
Note: This Question is unanswered, help us to find answer for this one
Oracle 12c Admin Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More Oracle 12c Admin MCQ Questions
In a multitenant environment, which of the following techniques can be used to create a pluggable database (PDB)? 1.Using the files of a seed 2.C|oning an existing PDB or non—CDB 3.Using an XML metadata file that describes the PDB and the files associated with the PDB 4.Moving a non—CDB into a PDB
What is the relative file number of a data file to identify a bigfile tablespace on the 0s/390 platform?
Which of the given SQL statements is equivalent to the following SQL statement?
We can create database objects in an undo tablespace.
While allocating memory for dynamic components in the System Global Area (SGA), what will be the granule size, if the requested SGA memory is greater than 16 GB and less than or equal to 32 GB?
Which of the following statements can be used tenable or disable triggers in Oracle Database 12C?
In Oracle Database 12c, which of the following resource consumer groups are the special groups that cannot be modified or deleted and are always present in the data dictionary?
Which of the following statements are correct about DBMS_REPAIR procedures?
Which of the following are included in the control file of Oracle Database 12c?
In Oracle Database 12c. which of the following table types CANNOT have invisible columns?