易搜题 > 资格证大类 > 计算机编程 > 问题详情
问题详情

You issued the following command:        SQL> DROP TABLE MYTABLE;        SQL> SHOW RECYCLEBIN  The following output is returned:        ORIGINAL NAME RECYCLEBIN NAME               OBJECT TYPE      DROP TIME        ------------- ------------------------------ --------------- --------------------        MYTABLE BIN$04LhcpndanfgMAAAAAANPw==$0     TABLE           2005-01-13:20:11:31  You want to drop the table, MYTABLE, from the Recycle Bin. Which two commands can you issue to accomplish the desired task?()

A

 DROP TABLE MYTABLE PURGE;

B

 PURGE RECYCLEBIN;

C

 PURGE TABLE MYTABLE;

D

 PURGE TABLE BIN$04LhcpndanfgMAAAAAANPw==$0;

未找到的试题在搜索页框底部可快速提交,在会员中心"提交的题"查看可解决状态。 收藏该题
查看答案

相关问题推荐

  • Which view will you use to view information regarding the jobs that are currently running in a database?()

    A、DBA_SCHEDULER_RUNNING_JOBS

    B、DBA_SCHEDULER_JOB_RUN_DETAILS

    C、DBA_SCHEDULER_JOBS

    D、DBA_SCHEDULER_JOB_LOG

  • 与语句cout<<endl;不等价的是()。

    A.cout<<‘’;

    B.cout<<‘12’;

    C.cout<<‘xA’;

    D.cout<<‘’;

  • In which scenario will you create a sorted hash cluster? ()

    A、 if the application uses queries joining tables only occasionally

    B、 if the full table scan is executed often on only one table of the clustered tables

    C、 if the data for all the rows of a cluster key value exceeds one or two Oracle blocks

    D、 when you want the data to be returned automatically in the chronological order

  • Your production database uses an Automatic Storage Management (ASM) instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users?()

    A、mount the new disk group in the ASM instance

    B、restart the ASM instance and the production database instance

    C、register the new disk groups in the production database instance

    D、restart the ASM instance without restarting the production database instance

    E、include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance

  • Which statement correctly describes the change tracking writer (CTWR) background process?()

    A、 It keeps track of changes in the background processes.

    B、 It records the system change number (SCN) in the control file.

    C、 It writes audit records for user changes to the change tracking file.

    D、 It records any changes to the listened configuration in the listener.ora file.

    E、 It records any changes to the database parameters in the change tracking file.

    F、 It records the physical location of all the changes that are made to the database in the change tracking file.

联系客服 会员中心
TOP