A
B
C
D
第1题:
The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file: ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3; Which action should you perform immediately after using this command?()
第2题:
You want to use the automatic management of backup and recovery operations features for your database.Which configuration must you set?()
第3题:
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?()
第4题:
You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?()
第5题:
In your production database, you have observed that the database server performance degrades whenever there is a switch between the log groups. On further investigation, you find that the database is running in ARCHIVELOG mode and the archived log files are being written to the same disk that is used to store the redo log members. Which two actions would you take to improve the performance of the database server? ()
第6题:
Your database is in ARCHIVELOG mode. You have two online redo log groups each of which contains one redo member. When you attempt to start the database, you receive the following errors: ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: ’D:///REDO01.LOG’ You discover that the online redo log file of the current redo group is corrupted. Which statement should you use to resolve this issue?()
第7题:
Flashback log files
Backups that have become obsolete
User managed backups of the data files and control files
Archived redo log files that have multiple copies in a different archive location and not backed up
第8题:
Shut down the database
Clear the online redo log
Back up the database
Checkpoint the database
Call Oracle support
第9题:
You should perform a log switch
You should make a backup of the database
You should switch the database to the NONARCHIVELOG mode
You should shut down the database instance and perform a complete database recovery
第10题:
Enable the flash recovery area and specify it as the archived redo log destination.
Disable the flash recovery area and start the database instance in ARCHIVELOG mode.
Enable the flash recovery area but do not specify it as the archived redo log destination.
Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.
第11题:
A
B
C
D
第12题:
You should perform a log switch
You should make a backup of the database
You should switch the database to the NONARCHIVELOG mode
You should shut down the database instance and perform a complete database recovery
第13题:
You want to use the automatic management of backup and recovery operations features for your database.Which configuration must you set?()
第14题:
Which two statements are true regarding the database in ARCHIVELOG mode?()
第15题:
As soon as you discover that you have lost an online redo log, if the database is still functioning, what should be your first action?()
第16题:
You configured the Flash Recovery Area (FRA) for your database. The database instance is runningin ARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area. Which two files are removed automaticallyif the space is required in the FRA as per the retention policy()
第17题:
You configured the Flash Recovery Area for your database. The database instance has been startedin ARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set. What will be the implications on the archiving and the location of archive redo log files()
第18题:
increase the size of the redo log buffer
increase the number of redo log groups
increase the number of log writer processes
increase the number of ARCn processes
change the appropriate LOG_ARCHIVE_DEST_n parameter to place the archived log files in a separate location
第19题:
flashback log files
backups that have become obsolete
copies of the data files and control files
archived redo log files that have multiple copies in a different archive location and not backed up
第20题:
The archived redo log files will be overwritten.
The archived redo log files are deleted automatically.
The archived redo log files should be moved to some other location.
The archived redo log files are still maintained because the file names are unique.
第21题:
ALTER DATABASE DROP LOGFILE GROUP 1;
ALTER DATABASE CLEAR LOGFILE GROUP 1;
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;
ALTER DATABASE DROP LOGFILE MEMBER 'D:/REDO01.LOG
第22题:
Enable the flash recovery area and specify it as the archived redo log destination.
Disable the flash recovery area and start the database instance in ARCHIVELOG mode.
Enable the flash recovery area but do not specify it as the archived redo log destination.
Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.
第23题:
SQL>ALTER DATABASE DROP LOGFILE GROUP 1;
SQL>ALTER DATABASE CLEAR LOGFILE GROUP 1;
SQL>ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;
SQL>ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’;
第24题:
Database Datafiles
Database Control Files
Online redo logs
Archived redo logs
The database SPFILE
None of the above,all these files are backed up