Qtr No. 213, New Town Yehlanka Indore 454775
The DBA received a request to create a new tablespace TBS_EMP in PDBEMPLOYEE pluggable database for storing the employee details. By mistake, the DBA creates the tablespace in root container CDB$ROOT. He/she executes the below given DROP TABLESPACE command to drop the newly created TBS_EMP from CDB$ROOT immediately so that no objects are created.
SQL> DROP TABLESPACE tbs_emp;
Which of the following statement is TRUE with respect to the above scenario?
The DROP command execution will fail with an error message to use INCLUDING CONTENTS option
The DROP command execution will fail as the tablespace name is case sensitive
The tablespace TBS_EMP will get dropped but the datafile will still exists in physical location
The DROP command execution will fail with an error message to use INCLUDING CONTENTS AND DATAFILES option
To get all Infosys Certified L1 Junior Database Admin Professional Exam questions Join Group https://bit.ly/infy_premium_group
We're passionate about offering best placement materials and courses!! A one stop place for Placement Materials. We daily post Offcampus updates and Placement Materials.
Qtr No. 213, New Town Yehlanka Indore 454775
admin@prepflix.in
