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
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、 Datafiles
- C、 Redo log files
- D、 Archived redo log files
- E、 Control files
相关考题：
The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three locations. The Flash Recovery Area is one of the locations. The details are given below:Which statement is true regarding what this command accomplishes?（）A. All archived redo log files backed up at least twice to tape are deleted.B. All archived redo log files backed up at least once to tape are eligible for deletion.C. All archived redo log files backed up at least twice to tape are deleted from the flash recovery area.D. All archived redo log files in local archiving destinations and the flash recovery area backed up at least twice to tape are eligible for deletion.
The RMAN BACKUP command using the DELETE INPUT option can be used with which three types of files？ （）A、data filesB、backup setsC、control filesD、archived redo log files
The instance abnormally terminates because of a power outage. Which statement is true about redo log filesduring instance recovery（）A、Inactive and current redo log files are required to accomplish recovery.B、Online and archived redo log files are required to accomplish instance recovery.C、All redo log entries after the last checkpoint are applied from redo log files to data files.D、All redo log entries recorded in the current redo log file until the checkpoint position are applied to data files
Which statement is true regarding the Archiver （ARCn） process，archived log files，and recovery？ （）A、A database backup, combined with archived redo log files, guarantees that all committed data can be recovered to the point of failure. B、During recovery the ARCn background process copies its redo entries identified for recovery by the control file to the data files. C、After each write to an archived log, the mandatory background process ARCn writes its log sequence number and the first and last SCN number within the log sequence to the control file. D、At database recover time, and archived redo log is uniquely identified for recovery use by its redo thread number and destination ID number retrieved from the control file.
You are performing backup and recovery operations by using RMAN. You are using a recovery catalog for the RMAN repository. You are planning to migrate to ASM disk storage to enable new disks to be added to the database without shutting down the database. Which information is NOT required during the migration process？（）A、 Database Identifier （DBID）B、 names and location of datafilesC、 names and location of control filesD、 names and location of online redo log files
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 are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RESETLOGS option？（）A、This operation resets the SCN for the database.B、This operation creates a new incarnation of the database.C、This operation moves all the redo log files to a different location.D、This operation deletes the old redo log files and creates new redo log files.E、This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.
You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement： SQLALTER DATABASE OPEN RESETLOGS； Which of the following options is true about using the RESETLOGS option？（）A、 The log sequence is reset to 0.B、 All the online redo logs are deleted.C、 All the archived redo logs from a previous incarnation become useless.D、 The full database backup taken from a previous incarnation can be used in future.E、 Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.
You work as a database administrator for Certkiller .com. Users in the Certkiller 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？（）A、Increase the size of redo log filesB、Increase the size of redo log bufferC、Increase the number of redo log filesD、Place the redo log files on a separate diskE、Decrease the number of redo log groups to twoF、Increate the number Log Writer （LGWR） process
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.
You need to recover five data files that are spread across multiple disks. Which initialization parameter should you set to speed up redo application？（）A、RECOVERY_PARALLELISMB、FAST_START_MTTR_TARGETC、LOG_CHECKPOINT_INTERVALD、FAST_START_PARALLEL_ROLLBACK
Because of hardware failure， you decided to drop a redo log member from the database. Which condition should be met to drop a redo log file？（）A、 The redo log file should belong to an active group.B、 The redo log file should belong to an inactive group.C、 The redo log file should belong to the current group.D、 The redo log file can be dropped only if all the transactions are stopped.E、 Before a redo log file is dropped， it should be deleted from the operating system （OS）.
ASM supports all but which of the following file types？（）A、 Database filesB、 SpfilesC、 Redo-log filesD、 Archived log filesE、 RMAN backup setsF、 Password filesG、 init.ora files
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；
The instance abnormally terminates because of a power outage. Which statement is true about redolog files during instance recovery（）A、Inactive and current redo log files are required to accomplish recovery.B、Online and archived redo log files are required to accomplish instance recovery.C、All redo log entries after the last checkpoint are applied from redo log files to data files.D、All redo log entries recorded in the current redo log file until the checkpoint position are applied to datafiles.
The loss of which two types of files may require a recovery with the RESETLOGS option？（）A、 control filesB、 password fileC、 archived log filesD、 system-critical data files for which all the redo entries are presentE、 non-system-critical data files for which all the redo entries are present
You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）A、 loss of one of the tablespacesB、 loss of a system data fileC、 loss of one of the control filesD、 loss of a tempfileE、 loss of the only member of an unarchived redo log groupF、 loss of a member from each redo log group
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
View the Exhibit.You executed the following command to perform a backup of the USERS tablespace： RMAN BACKUP TABLESPACE USERS； Which three types of files are backed up？ （）A、 all the data files belonging to the USERS tablespaceB、 password fileC、 online redo log filesD、 the current control fileE、 archived redo log filesF、 the current server parameter fileG、 data files belonging to the USERS tablespace and all the default tablespaces
单选题You are performing backup and recovery operations by using RMAN. You are using a recovery catalog for the RMAN repository. You are planning to migrate to ASM disk storage to enable new disks to be added to the database without shutting down the database. Which information is NOT required during the migration process？（）A Database Identifier （DBID）B names and location of datafilesC names and location of control filesD names and location of online redo log files
单选题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.
单选题The performance of your database is affected by the presence of two log members in each online redo log group and the placement of redo log members of a group on the same disk. You decide to place the redo log members of a group on separate disks. Which view will you query to find the name and location of all the online redo log members？（）A V$LOGB V$LOGFILEC DBA_LOG_GROUPSD V$LOG_HISTORY
单选题You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）Aloss of a tempfileBloss of a system data fileCloss of one of the control filesDloss of one of the tablespacesEloss of a member from each redo log groupFloss of the only member of an unarchived redo log group
单选题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 are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）A loss of one of the tablespacesB loss of a system data fileC loss of one of the control filesD loss of a tempfileE loss of the only member of an unarchived redo log groupF loss of a member from each redo log group
单选题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
单选题The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three locations. The Flash Recovery Area is one of the locations. The details are given below： LOG_ARCHIVE_DEST_1 = ’LOCATION = /disk1/archive’ LOG_ARCHIVE_DEST_2 = ’SERVICE = stdb1’ DB_RECOVERY_FILE_DEST = ’/u01/oradata’ Examine the following RMAN command issued to set the deletion policy for archived log files： RMAN CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO sbt； Which statement is true regarding what this command accomplishes？（）A All archived redo log files backed up at least twice to tape are deleted.B All archived redo log files backed up at least once to tape are eligible for deletion.C All archived redo log files backed up at least twice to tape are deleted from the flash recovery area.D All archived redo log files in local archiving destinations and the flash recovery area backed up at least twice to tape are eligible for deletion.