（多选题）
You execute this command to drop the ITEM table， which has the primary key referred in the ORDERS table：SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE； Which two statements are true about theeffect of the command（）
ANo flashback is possible to bring back the ITEM table.
BThe ORDERS table is dropped along with the ITEM table.
CThe dependent referential integrity constraints in the ORDERS table are disabled.
DThe dependent referential integrity constraints in the ORDERS table are removed.
EThe table definition of the ITEM table and associated indexes are placed in the recycle bin
正确答案
答案解析
略
相似试题
（单选题）
You executed the following command in Recovery Manager （RMAN）： RMAN> RESTORE CONTROLFILE； Which operation must you perform before this command is executed？（）
（多选题）
You executed the following commands to find the location of the alert log file： Where is the alert log file stored（）
（单选题）
You executed the following command in Recovery Manager （RMAN）： RMAN> RESTORE CONTROLFILE； Which operation must you perform before this command is executed？（）
（单选题）
You execute this command in MOUNT mode： ALTER DATABASE ARCHIVELOG； Where is the information that the database is now in ARCHIVELOG mode stored？（）
（多选题）
When executing a SQL workload，you choose to generate execution plans only， without collecting execution statistics. Which two statements describe the implications of this？（）
（单选题）
Before a Flashback Table operation，you execute the following command： ALTER TABLE employees ENABLE ROW MOVEMENT； Why would you need this to be executed？（）
（单选题）
You execute the following command to start an Automatic Storage Management （ASM） instance： SQL>STARTUP； In which of the following modes will the ASM instance start？（）
（单选题）
You executed the following code： BACKUP VALIDATE DATABASE； BLOCKRECOVER CORRUPTION LIST； What will be the result of executing the above code？（）
（单选题）
You executed the following query in your database： FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output？（）
（单选题）
You discover that your Recycle Bin contains two tables with the same name， MY_TABLE. You also have a table named MY_TABLE in your schema. You execute the following statement： FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2； What will be the result of executing this statement？（）
