A user performs an update on a table. Shortly after committing the transaction， they realize that they had an error in their WHERE clause causing the wrong rows to be updated. Which Flashback option would allow you to undo this transaction and restore the table to its previous state？（）

单项选择题WhatRMANcommandisusedtoexecuteatablespacepoint-in-timerecovery？（）

A. recover
B. duplicate
C. restore
D. copy
E. None of the above

单项选择题You have configured flash recovery area in your database and you set the following Initialization parameters for your database instance：   LOG_ARCHIVE_DEST 1 = ，，LOCATION= disk1 arch MANDATORY’  LOG _ARCHIEVE_DEST 2 = ，，LOCATION= disk2 arch’ LOG_ARCHIVK_DEST_3 = ，，LOCATION= diSk3 arch  LOG_ARCH1VK_DEST_4 = ’ LOCATION= disk4 arch’  LOG_ARCHIVE_MIN-SUCCEED_DEST = 2   While the database instance is functional，you realized that the destination set by the  LOG_ARCHIVE_DEST_I parameter Is not available for the archived redo log file to be created in. All redo log groups have been used.  What happens in an event of log switch？（）

A. The online redo log file Is not allowed to be overwritten.
B. The archived redo log files are written to the flash recovery area until the MANDATORY destination is made available.
C. The database instance will crash because the archived redo log file cannot be created in a destination set as MANDATORY.
D. The destination set by the LOG_ARCHIVE_DEST_1 parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.

单项选择题You executed the following command in Recovery Manager （RMAN）：   RMAN> REPORT NEED BACKUP days 3；   What is the output of this command？（）

A. a list of files that require a backup within three days
B. a list of files requiring more than 3 days of archive logs to apply
C. a list of files that RMAN recommends be backed up only once in every three days，based on low volatility
D. a list of files for which a backup has already been performed in the last three days and which is required to be backed up again based on the high number of transactions performed on them

多项选择题WhichofthefollowingcannotbeusedasinputtotheSQLTuningAdvisor？（）

A. A single SQL statement provided by a user
B. An existing SQL Tuning Set （STS）
C. A preprocessed Database Replay workload
D. A schema name
E. SQL statement identified in EM as using excessive resources

单项选择题You want to set the following Initialization parameters for your database Instance   LOG_ARCHIVE_DEBT_1 = ，，LOCATION= disk1 arch LOG_ARCHIVE_DBST_2 = ，，LOCATION= disk2 arch LOC_ARCHIVB DBST_3 = ，，LOCATION= disk3 arch LOG_ARCHIVE DBST_ = ，，LOCATION= disk3 arch   Identify the statement that correctly describes this setting.（）

A. The MANDATORY location must be a flash recovery area.
B. The optional destinations may not use the flash recovery area.
C. This setting is not allowed because the first destination is not set as MANDATORY.
D. The online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth destination.