单项选择题
You performed an incomplete recovery and opened the database with the RESETLOGS option. The LOG_ARCHIVE_FORMAT parameter is set to ’ora_%t_%s_%r.log’.
Which statement regarding the archived redo log files, created in an earlier incarnation of the database,is true?()
A. The archived redo log files will be overwritten.
B. The archived redo log files are deleted automatically.
C. The archived redo log files should be moved to some other location.
D. The archived redo log files are still maintained because the file names are unique.
相关考题
-
单项选择题
Whichmethodwouldyouusetoundothechangesmadebyaparticulartransactionwithoutaffectingthechangesmadebyothertransactions?()
A. point-in-time recovery
B. execute the ROLLBACK command with transaction number
C. flashback the database to before the transaction was committed
D. determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery -
单项选择题
You want to convert your existing non-ASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task?()
A. Data Pump Export and Import
B. conventional export and import
C. the CONVERT command of RMAN
D. the BACKUP AS COPY. command of RMAN -
单项选择题
WhichofthefollowingadvisorswithintheOracleadvisoryframeworkwillanalyzeasingleSQLstatementandmakerecommendationsforperformanceimprovement?()
A. SQL Repair Advisor
B. SQL Optimizer
C. SQL Access Advisor
D. SQL Tuning Advisor
