首页计算机考试Oracle认证
(单选题)

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()

    答案解析

快考试在线搜题