The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema.<br /> Which two statements are true regarding the outcome of this action? （）(Choose two)..

第1题

[多选题] The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema.Which two statements are true regarding the outcome of this action?（）

A、All the related indexes and views are automatically dropped B、The flashback drop feature can recover only the table structure C、Only the related indexes are dropped whereas views are invalidated D、The flashback drop feature can recover both the table structure and its data

点击查看答案

第2题

[多选题] 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 Recy

A、 DROP TABLE MYTABLE PURGE； B、 PURGE RECYCLEBIN； C、 PURGE TABLE MYTABLE； D、 PURGE TABLE BIN$04LhcpndanfgMAAAAAANPw==$0；

点击查看答案

第3题

[] 元音e[&para;]与i[i]的区别主要在于舌位的前后与高低均不同。

点击查看答案

第4题

[] The RECYCLEBIN parameter is set to ON for your database. You drop a table，PRODUCTS，from the SCOTT schema. Which two statements are true regarding the outcome of this action？（） The RECYCLEBIN parameter is set to ON for your database. You drop a table，PRODUCTS，from the SCOTT schema. Which two statements are true regarding the outcome of this action？（）

A、A. All the related indexes and views are automatically dropped B、B. The flashback drop feature can recover only the table structure C、C. Only the related indexes are dropped whereas views are invalidated D、D. The flashback drop feature can recover both the table structure and its data

点击查看答案

第5题

[单选题] You plan to use Flashback Drop feature to recover a dropped table SALES_EMP. No other table with the same name exists in the schema. You query RECYCLEBIN and find multiple entries for the SALES_EMP table as follows: You then issue the following statement to recover the table: SQL> FLASHBACK TABLE sales_emp TO BEFORE DROP; What would be the outcome of the precedent statement?（）

A、It retrieves the latest version of the table from the recycle bin B、It retrieves the oldest version of the table from the recycle bin C、It retrieves the version of the table for which undo information is available D、It returns an error because the table name is not specified as per the names in the OBJECT_NAME column

点击查看答案

第6题

[单选题] You plan to use Flashback Drop feature to recover a dropped table SALES_EMP. No other table with the same name exists in the schema.You query RECYCLEBIN and find multiple entries for the SALES_EMP table as follows, You then issue the following statement to recover the table: SQL> FLASHBACK TABLE sales_emp TO BEFORE DROP; What would be the outcome of the precedent statement?（）

A、It retrieves the latest version of the table from the recycle bin B、It retrieves the oldest version of the table from the recycle bin C、It retrieves the version of the table for which undo information is available D、It returns an error because the table name is not specified as per the names in the OBJECT_NAME column

点击查看答案

第7题

[单选题] 下面几个元音中，属于前元音的是（）。

A、[a] B、[u] C、[o] D、[&para;]

点击查看答案

第8题

[单选题] 下面几个元音中，属于低元音的是（）。

A、[a] B、[u] C、[i] D、[&para;]

点击查看答案

第9题

[单选题] You are maintaining your production database in Oracle10g. You want the circular reuse records in the control file of the target database to be reused as required. Which value will you set for the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter？（）

A、 0 B、 1 C、 NONE D、 DEFAULT

点击查看答案

The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema.<br /> Which two statements are true regarding the outcome of this action? （）(Choose two)

请使用微信扫码支付