多选题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 ------------- ------------------------

题目

多选题

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？（）

DROP TABLE MYTABLE PURGE；

PURGE RECYCLEBIN；

PURGE TABLE MYTABLE；

PURGE TABLE BIN$04LhcpndanfgMAAAAAANPw==$0；

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

You opened the encryption wallet and then issued the following command:Then you closed the wallet. Later, you issued the following command to create the EMPLOYEES table in the SECURESPACE tablespace and you use the NO SALT option for the EMPID column.What is the outcome?（）

A. It creates the table and encrypts the data in it.

B. It generates an error because the wallet is closed.

C. It creates the table but does not encrypt the data in it.

D. It generates an error because the NO SALT option cannot be used with the ENCRYPT option.

参考答案：B

第2题：

You just issued the following statement: ALTER TABLE SALES DROP COLUMN PROFIT. Which of the following choices identifies when the column will actually be removed from Oracle?（）

A、Immediately following statement execution
B、After the ALTER TABLE DROP UNUSED COLUMNS command is issued
C、After the ALTER TABLE SET UNUSED COLUMN command is issued
D、After the ALTER TABLE MODIFY command is issued

正确答案:B

第3题：

Examine the output of the query that you executed to list the objects in the recycle bin:You verified that no table named SALES_TAB exists in the schema. Then you executed the following command to purge the objects in the recycle bin:SQL> PURGE TABLE sales_tab;What would be the outcome of this command?（）

A. All three tables in the recycle bin are purged

B. Only the table with the oldest DROPSCN is purged

C. The command returns an error because multiple entries with the same name exist in the recycle bin

D. Only the table with the latest DROPSCN is purged

参考答案：B

第4题：

You issued the following command to drop the PRODUCTS table: SQL> DROP TABLE products; What is the implication of this command?（）

A、All data along with the table structure is deleted
B、The pending transaction in the session is committed
C、All indexes on the table will remain but they are invalidated
D、All views and synonyms will remain but they are invalidated
E、All data in the table are deleted but the table structure will remain

正确答案:A,B,D

第5题：

For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state？（）

A、UPDATE TABLE
B、CREATE CLUSTER
C、TRUNCATE TABLE
D、ALTER TABLE MOVE
E、INSERT INTO···VALUES
F、ALTER TABLE···DROP COLUMN
G、ALTER TABLE···DROP PARTITION

正确答案:A,E

第6题：

You moved the index EMP_NO_INDX from one tablespace to another and then issued the following command to rebuild the index EMP_NO_INDX： SQL> ALTER INDEX EMP_NO_INDX REBUILD ONLINE； Which table allows the users to access the EMP_NO_INDX index while performing the rebuild operation？（）

A、 Index-organized table
B、 Mapping Table
C、 Clustered Table
D、 Journal Table

正确答案:D

第7题：

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

正确答案:C,D

第8题：

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

参考答案：A

第9题：

You execute this command to drop the ITEM table， which has the primary key referred in the ORDERtable： SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE； Which two statements are true about the effect of the command（）

A、No flashback is possible to bring back the ITEM table.
B、The ORDER table is dropped along with the ITEM table.
C、The dependent referential integrity constraints in the ORDER table are disabled.
D、The dependent referential integrity constraints in the ORDER table are removed.
E、The table definition of the ITEM table and associated indexes are placed in the recycle bin.

正确答案:A,D

第10题：

You issued the following command to analyze the SCOTT.EMP table for block corruption： ANALYZE TABLE SCOTT.EMP VALIDATE STRUCTURE； You received the following error： ORA-01578： ORACLE data block corrupted （file # %s， block # %s） How will you resolve the block corruption problem？（）

A、 by using the DBMS_REPAIR package
B、 by using the DB_BLOCK_CHECKING parameter
C、 by using the DBVERIFY utility
D、 will not be completely resolved until the hardware fault is corrected

正确答案:D

You issued the following command： SQL> DROP TABLE MYT

题目

相似问题和答案

更多相关问题

相关内容