1Z0-053單項選擇題每日一練(2019.01.19)

You are managing Oracle Database 11g with an ASM storage with high redundancy. The following command was issued to drop the disks from the dga disk group after five hours：  
ALTER DISKGROUP dga OFFLINE DISKS IN FAILGROUP f2 DROP AFTER 5H；  
Which statement is true in this scenario？（）

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

Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of data is added to the table daily. To save disk space，you issued the following command：  
ALTER TABLE sales_2007 COMPRESS FOR ALL OPERATIONS；  
What would be the outcome of this command？（）