单选题

Examine the following commands executed in your database: SQL> ALTER SESSION RECYCLEBIN=ON; Session altered  SQL > CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees;  Table created.  Further, you executed the following command to drop the table:  SQL> DROP TABLE emp;Table dropped.  What happens in this scenario?()

AThe table is moved to the SYSAUX tablespace.

BThe table is moved to the SYSTEM tablespace.

CThe table is removed from the database permanently.

DThe table is renamed and remains in the TBSFD tablespace.

正确答案

来源:www.examk.com

答案解析

相似试题
  • View the Exhibit and examine the data in ORDERS_MASTER and MONTHLYjDRDERS tables. What would be the outcome of the above statement?()

    单选题查看答案

  • View the Exhibit and examine the recommendation graph provided for a test database by the Undo Advisor.The graph recommends that the size of undo tablespace should be set to().

    单选题查看答案

  • View the Exhibit and examine the output of the query.  What do you infer from this()

    单选题查看答案

  • View the Exhibit and examine the output of the query.  What do you infer from this()

    单选题查看答案

  • View the Exhibit and examine the output.  Which two statements are true regarding the LISTENER2 listener()

    多选题查看答案

  • Exhibit: View the Exhibit and examine the properties of the USERS tablespace. You execute the following statement to shrink the TRANS table existing on the USERS tablespace: SQL> ALTER TABLE trans SHRINK SPACE CASCADE;  Which objects would be affected by this command?()

    多选题查看答案

  • View the Exhibit and examine the structure of the ORDERS table. Which task would require subqueries?  ()

    单选题查看答案

  • View the Exhibit and examine the output.  Which two statements are true regarding the LISTENER2 listener()

    多选题查看答案

  • View the Exhibit to examine the output for the CROSSCHECK BACKUP command.  Which statement is trueabout the output of the command()

    单选题查看答案

  • View the Exhibit to examine the details for an incident. Which statement is true regarding the status of the incident()

    单选题查看答案