多項(xiàng)選擇題

On Jan 11， 2005 at 2：30 P.M.， an erroneous update operation modified all the values of column LASTNAME in the EMPLOYEE table in the Scott schema to an empty string. You are the system administrator， and you want to return the original values in the table. To do so， you decided to flash back the table. Which two options can you use to flash back a table？（）

A. by using Oracle Enterprise Manager
B. by issuing the FLASHBACK TABLE statement at the RMAN prompt
C. by issuing the FLASHBACK TABLE statement at the SQL prompt
D. by issuing the FLASHBACK TABLE statement at the LSNRCTL prompt

你可能感興趣的試題

單項(xiàng)選擇題

You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature？（）

A. You must use automatic undo management in the database.
B. You must configure OMF in your database.
C. You must configure ASM for storing the datafiles.
D. You must multiplex the online redo log file.

單項(xiàng)選擇題

At 5：30 PM， a database administrator， William， is informed that an important record of employee no E0025 is missing from the SCOTT.EMPLOYEE table. At 4：30 P.M， the table contained the record of employee no E0025. William issues the following command to find the SQL statements that are used to undo the deletion：
SELECT operation， undo_sql， logon_user
FROM FLASHBACK_TRANSACTION_QUERY WHERE xid=
HEXTORAW（’0100043E23456’）；
where ’0100043E23456’ is the transaction ID of the transaction that deleted the row. Before issuing the above statement， which task did William perform to identify the transaction ID of the transaction that deleted the row？（）

A. William used the Flashback Version Query feature.
B. William issued the CROSSCHECK command at the RMAN prompt.
C. William viewed the alert log file.
D. William used the Flashback Table feature.

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区 狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久

你可能感興趣的試題

You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature？（）

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久

You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature？（）