网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defragmentation you lose the redo log member, which is not a member of the current group. How would you recover from the loss of the redo log member?()
A

SMON would automatically restore the lost file.

B

You would need to restore the whole database from the last backup.

C

You would need to restore the file from the last full database backup.

D

You would need to use flashback technology to restore the lost redo log member.

E

You would need to use Recovery Manager (RMAN) to restore the lost redo log member.

F

You would need to restore the missing log file by copying one of the remaining files from the same group.


参考答案

参考解析
解析: 暂无解析
更多 “单选题Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defragmentation you lose the redo log member, which is not a member of the current group. How would you recover from the loss of the redo log member?()A SMON would automatically restore the lost file.B You would need to restore the whole database from the last backup.C You would need to restore the file from the last full database backup.D You would need to use flashback technology to restore the lost redo log member.E You would need to use Recovery Manager (RMAN) to restore the lost redo log member.F You would need to restore the missing log file by copying one of the remaining files from the same group.” 相关考题
考题 Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defragmentation you lose the redo log member, which is not a member of the current group. How would you recover from the loss of the redo log member?()A、SMON would automatically restore the lost file.B、You would need to restore the whole database from the last backup.C、You would need to restore the file from the last full database backup.D、You would need to use flashback technology to restore the lost redo log member.E、You would need to use Recovery Manager (RMAN) to restore the lost redo log member.F、You would need to restore the missing log file by copying one of the remaining files from the same group.

考题 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?()A、increase the size of the redo log bufferB、increase the number of redo log groupsC、increase the number of log writer processesD、increase the number of ARCn processesE、change the appropriate LOG_ARCHIVE_DEST_n parameter to place the archived log files in a separate location

考题 In which two cases would you perform only consistent backup?()A、You are working on a database where downtime is not tolerated.B、You are working on a database where downtime can be tolerated.C、You are working on a database that operates in ARCHIVELOG mode.D、You are working on a database that operates in NOARCHIVELOG mode.E、You are working on a database where all the tablespaces are locally managed.F、You are working on a database where control files and redo log files are multiplexed.G、You are working on a database where control files and redo log files are not multiplexed.

考题 You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state?()A、renaming the control filesB、dropping a user in your databaseC、enabling or disabling redo log archivingD、dropping a tablespace in your databaseE、re-creating the control files, after you lost all the control files in your database

考题 Which type of database file is spread across all disks in a disk group?()A、 All types of files are spread across all disks in the disk group.B、 DatafilesC、 Redo log filesD、 Archived redo log filesE、 Control files

考题 You have configured the flash recovery area to store online redo log files, control files, archived redo logs and RMAN backups. Which of the following files can you successfully delete from the flash recovery area if you want to reclaim the space within it?()A、 multiplexed control filesB、 RMAN obsolete backupsC、 multiplexed online redo log filesD、 archived redo logs that have not been copied to tape

考题 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()A、flashback log filesB、backups that have become obsoleteC、copies of the data files and control filesD、archived redo log files that have multiple copies in a different archive location and not backed up

考题 You have the following online redo log configuration:    Group       Member   1     ’/disk1/oradata/redo01a.log’   2     ’/disk2/oradata/redo02a.log’   3     ’/disk3/oradata/redo03a.log’   You decide to multiplex the online redo log groups for recovery of redo log files in case of any disaster. Which two statements will you NOT issue to multiplex the online redo log files?()A、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo01b.log’ TO GROUP 1;B、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo01b.log’ TO GROUP 1;C、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo02b.log’ TO GROUP 2;D、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo02b.log’ TO GROUP 2;E、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo3b.log’ TO GROUP 3;F、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo3b.log’ TO GROUP3;

考题 In your database, online redo log files are multiplexed and one of the members in a group is lost due to media failure.  How would you recover the lost redo log member?()A、import the database from the last exportB、restore all the members in the group from the last backupC、drop the lost member from the database, and then add a new member to the groupD、restore all the database files from the backup, and then perform a complete recovery E、restore all the database files from the backup, and then perform an incomplete recovery

考题 In which scenario is a Database Administrator NOT required to perform an incomplete recovery?()A、 when all the online redo log groups are multiplexed and one of the members of a group is missingB、 when all the online redo log groups are not multiplexed and one log group is missingC、 when all the control files are missingD、 when some important tables are deleted from the database and purged from the Recycle Bin

考题 单选题Your boss at Certkiller .com wants you to clarify Oracle 10g. Which statement regarding the usage of redo log files during instance recovery is true?()A Transactions are rolled back using redo log files.B Transactions are rolled forward using redo log files.C Transactions are rolled back using redo log files and archived log files.D Transactions are rolled forward using redo log files and rolled back using redo log files.

考题 单选题You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state?()A renaming the control filesB dropping a user in your databaseC enabling or disabling redo log archivingD dropping a tablespace in your databaseE re-creating the control files, after you lost all the control files in your database

考题 多选题You configured the Flash Recovery Area (FRA) for your database. The database instance is running inARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area.  Which twofiles are removed automatically if the space is required in the FRA as per the retention policy()AFlashback log filesBBackups that have become obsoleteCUser managed backups of the data files and control filesDArchived redo log files that have multiple copies in a different archive location and not backed up

考题 单选题In which scenario is a Database Administrator NOT required to perform an incomplete recovery?()A  when all the online redo log groups are multiplexed and one of the members of a group is missingB  when all the online redo log groups are not multiplexed and one log group is missingC  when all the control files are missingD  when some important tables are deleted from the database and purged from the Recycle Bin

考题 多选题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?()Aincrease the size of the redo log bufferBincrease the number of redo log groupsCincrease the number of log writer processesDincrease the number of ARCn processesEchange the appropriate LOG_ARCHIVE_DEST_n parameter to place the archived log files in a separate location

考题 单选题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 work as a database administrator for Supportcenter.cn. Users in the SupportCenter PROD database complain about the slow response when accessing the database. In the Active Session Waiting: Configuration page you find that the majority of the wait time is for the redo log buffer. Further investigation using the Run Queue graph and operating system tools reveals that the redo log files are on the same disks, and that the disk I/O for the redo log files is the reason for the performance degradation.  Which two actions would you take to gain performance?()AIncrease the size of redo log filesBIncrease the size of redo log bufferCIncrease the number of redo log filesDPlace the redo log files on a separate diskEDecrease the number of redo log groups to twoFIncreate the number Log Writer (LGWR) process

考题 单选题Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2, and archiving has stopped. All the redo logs are filled and database activity is halted. Database writer has written everything to disk. Which command would you execute to proceed further?()A RECOVER LOGFILE BLOCK GROUP 2;B ALTER DATABASE DROP LOGFILE GROUP 2;C ALTER DATABASE CLEAR LOGFILE GROUP 2;D ALTER DATABASE RECOVER LOGFILE GROUP 2;E ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2;

考题 单选题You have configured the flash recovery area to store online redo log files, control files, archived redo logs and RMAN backups. Which of the following files can you successfully delete from the flash recovery area if you want to reclaim the space within it?()A  multiplexed control filesB  RMAN obsolete backupsC  multiplexed online redo log filesD  archived redo logs that have not been copied to tape

考题 单选题You are analyzing the components of the redo log mechanisms in your Oracle database. Which of the following purposes does the CKPT process serve?()A Writes buffers to disk B Writes current redo log number to datafile headers C Writes redo log information to disk D Reads information into memory for users

考题 单选题Which type of database file is spread across all disks in a disk group?()A  All types of files are spread across all disks in the disk group.B  DatafilesC  Redo log filesD  Archived redo log filesE  Control files

考题 单选题In your database, online redo log files are multiplexed and one of the members in a group is lost due to media failure? How would you recover the lost redo log member?()A  import the database from the last exportB  restore all the members in the group from the last backupC  drop the lost member from the database and then add a new member to the groupD  restore all the database files from the backup and then perform a complete recoveryE  restore all the database files from the backup and then perform an incomplete recovery

考题 单选题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()A Archiving will be disabled because the destination for the redo log files is missing.B The database instance will shut down and the error details will be logged in the alert log file.C Archiving will be enabled and the destination for the archived redo log file will be set to the FlashRecovery Area implicitly.D Archiving will be enabled and the location for the archive redo log file will be created in the defaultlocation $ORACLE_HOME/log.

考题 单选题You work as a database administrator for Certkiller .com. Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2, and archiving has stopped. All the redo logs are filled and database activity is halted. Database writer has written everything to disk.  Which command would you execute to proceed further?()A RECOVER LOFIEL BLOCK GROUP 2;B ALTER DATABASE DROP LOGFILE GROUP 2;C ALTER DATABASE CLEAR LOGFILE GROUP 2;D ALTER DATABASE RECOVER LOGFILE GROUP 2;E ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2;

考题 单选题You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database. The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?()A Open the database in NORMAL modeB Open the database in read-only modeC Open the database in RESTRICTED modeD Open the database with the RESETLOGS option