网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
多选题
Which two changes and their effect on the system can be tested by using the Database Replay feature?()
A
multiplexing of the control file
B
adding the redo log member to the database
C
database and operating system upgrades
D
changing the database storage to ASM-managed storage
参考答案
参考解析
解析:
暂无解析
更多 “多选题Which two changes and their effect on the system can be tested by using the Database Replay feature?()Amultiplexing of the control fileBadding the redo log member to the databaseCdatabase and operating system upgradesDchanging the database storage to ASM-managed storage” 相关考题
考题
Which three tasks can be performed using a duplicate database?()
A. Testing the backup and recovery proceduresB. Testing the upgrade of an Oracle database to a new releaseC. Testing the effect of an application changes on database performanceD. Continuously updating archive log files from the target database to support failover
考题
Which two changes and their effect on the system can be tested by using the Database Replay feature?()A、 multiplexing of the control fileB、 adding the redo log member to the databaseC、 database and operating system upgradesD、 changing the database storage to ASM-managed storage
考题
Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt: RMAN CONFIGURE CONTROLFILE AUTOBACKUP OFF; RMAN BACKUP DATABASE; Which files from the database will be backed up as a result of this BACKUP command?()A、 control fileB、 all datafilesC、 password fileD、 online redo log fileE、 archive redo log fileF、 server parameter fileG、 only the SYSTEM datafile
考题
Which three tasks can be performed using a duplicate database? ()(Choose three.)A、Testing the backup and recovery proceduresB、Testing the upgrade of an Oracle database to a new releaseC、Testing the effect of an application changes on database performanceD、Continuously updating archive log files from the target database to support failover
考题
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
考题
Which two file types must be included in a closed database backup taken with operating system commands?()A、data filesB、control fileC、password fileD、online redo log filesE、initialization parameter file
考题
You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup?()A、 online redo log filesB、 alert log filesC、 control fileD、 datafiles associated with the SYSTEM tablespace
考题
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).
考题
You have configured OMF in your database. You enabled the ALTER DATABASE ENABLE BLOCK CHANGE TRACKING; statement to enable the block change tracking feature. What information will be written in the change tracking file?()A、 the system change numberB、 the locations of the redo log filesC、 the locations of the datafilesD、 the physical location of all the database changes
考题
Which two files in the database can be configured for automatic backups by using the autobackupfeature in Recovery Manager (RMAN)()A、data filesB、control filesC、parameter fileD、online redo log filesE、server parameter file
考题
You are working on a database, where you have three redo log groups. When the database is down for a backup, an operating system (OS) user deletes all the redo log files in a group. What will happen when you open your database?()A、 The instance starts, the database is mounted, but efforts to open the database fail, and an error about the missing redo log group is displayed.B、 Before the instance starts, you receive an error about the missing redo log files of a group.C、 The instance starts and the database opens with an error message written to the alert log file.D、 The instance starts and the database opens because two redo log groups still exist.E、 The instance starts and the database opens, but every attempt to write to redo log files fails with an error.
考题
Which two files in the database can be configured for automatic backups by using the autobackup feature inRecovery Manager (RMAN)()A、Data filesB、Control filesC、Parameter fileD、Online redo log filesE、Server parameter file
考题
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
考题
Which three tasks can be performed using a duplicate database?()A、 Testing the backup and recovery proceduresB、 Testing the upgrade of an Oracle database to a new releaseC、 Testing the effect of an application changes on database performanceD、 Continuously updating archive log files from the target database to support failover
考题
多选题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?()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
考题
单选题You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup?()A
online redo log filesB
alert log filesC
control fileD
datafiles associated with the SYSTEM tablespace
考题
单选题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).
考题
单选题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 a tempfileB
loss of a system data fileC
loss of one of the control filesD
loss of one of the tablespacesE
loss of a member from each redo log groupF
loss of the only member of an unarchived redo log group
考题
多选题Which three tasks can be performed using a duplicate database? ()(Choose three.)ATesting the backup and recovery proceduresBTesting the upgrade of an Oracle database to a new releaseCTesting the effect of an application changes on database performanceDContinuously updating archive log files from the target database to support failover
考题
多选题Which two file types must be included in a closed database backup taken with operating system commands?()Adata filesBcontrol fileCpassword fileDonline redo log filesEinitialization parameter file
考题
单选题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
考题
多选题Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt: RMAN CONFIGURE CONTROLFILE AUTOBACKUP OFF; RMAN BACKUP DATABASE; Which files from the database will be backed up as a result of this BACKUP command?()Acontrol fileBall datafilesCpassword fileDonline redo log fileEarchive redo log fileFserver parameter fileGonly the SYSTEM datafile
考题
多选题Which two files in the database can be configured for automatic backups by using the autobackupfeature in Recovery Manager (RMAN)()Adata filesBcontrol filesCparameter fileDonline redo log filesEserver parameter file
考题
多选题Which two files in the database can be configured for automatic backups by using the autobackup feature inRecovery Manager (RMAN)()AData filesBControl filesCParameter fileDOnline redo log filesEServer parameter file
考题
多选题Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) whileduplicating a running database? ()(Choose Two)ACreating the control file for the duplicate databaseBRestoring the target data files to the duplicate databaseCPerforming complete recovery using all available backupsDGenerating a new, unique DBID for the duplicate databaseECopying the online redo log files from the target database to the duplicate database
考题
多选题Which three tasks can be performed using a duplicate database?()ATesting the backup and recovery proceduresBTesting the upgrade of an Oracle database to a new releaseCTesting the effect of an application changes on database performanceDContinuously updating archive log files from the target database to support failover
考题
多选题In which two cases would you perform only consistent backup?()AYou are working on a database where downtime is not tolerated.BYou are working on a database where downtime can be tolerated.CYou are working on a database that operates in ARCHIVELOG mode.DYou are working on a database that operates in NOARCHIVELOG mode.EYou are working on a database where all the tablespaces are locally managed.FYou are working on a database where control files and redo log files are multiplexed.GYou are working on a database where control files and redo log files are not multiplexed.
热门标签
最新试卷