网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
单选题
Consider the following scenario for your database: - Backup optimization is enabled in RMAN. - The recovery window is set to 7 days in RMAN. - The most recent backup to disk for the TOOLS tablespace was taken on November 3, 2007. - The TOOLS tablespace is read-only since November 4, 2007. On November 23, 2007, you issue the RMAN command to back up the database to disk. Which statement is true regarding the backup of the TOOLS tablespace?()
A
The RMAN backup fails because the TOOLS tablespace is read-only
B
The RMAN skips the backup of the tablespace because backup optimization is enabled
C
The RMAN makes backup because optimization can be enabled only for backups to disk
D
The RMAN makes the backup because no backup of the tablespace exists within the seven day window
参考答案
参考解析
解析:
暂无解析
更多 “单选题Consider the following scenario for your database: - Backup optimization is enabled in RMAN. - The recovery window is set to 7 days in RMAN. - The most recent backup to disk for the TOOLS tablespace was taken on November 3, 2007. - The TOOLS tablespace is read-only since November 4, 2007. On November 23, 2007, you issue the RMAN command to back up the database to disk. Which statement is true regarding the backup of the TOOLS tablespace?()A The RMAN backup fails because the TOOLS tablespace is read-onlyB The RMAN skips the backup of the tablespace because backup optimization is enabledC The RMAN makes backup because optimization can be enabled only for backups to diskD The RMAN makes the backup because no backup of the tablespace exists within the seven day window” 相关考题
考题
You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?()
A. The backup as copy can only be taken to diskB. The backup as copy can only be taken to tapeC. Backup can be performed only when the instance is shutdownD. Backup will constitute all used and unused blocks in the database
考题
Examine the following scenario:The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host, using the Recovery Manager (RMAN) duplicate command as follows:Which statement is true about the duplicate database in this scenario?()A. It contains data till the last backupB. It contains all data from target database until the current timeC. It contains all data from only the committed transactions in the target databaseD. It contains all data except that which is used by the transactions in the current online redo file of target database
考题
You want to make sure that your database backup does not exceed 10 hours in length. What command would you issue that would meet this condition?()A、backup database plus archivelogB、backup database plus archivlog until time ‘10:00‘C、backup database plus archivelog timeout ‘10:00‘D、backup database plus archivelog duration 10:00
考题
A bare metal backup requires which of the following backup methodologies?()A、FullB、DifferentialC、IncrementalD、Database
考题
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
考题
Consider the following scenario for your database: - Backup optimization is enabled in RMAN. - The recovery window is set to 7 days in RMAN. - The most recent backup to disk for the TOOLS tablespace was taken on November 3, 2007. - The TOOLS tablespace is read-only since November 4, 2007. On November 23, 2007, you issue the RMAN command to back up the database to disk. Which statement is true regarding the backup of the TOOLS tablespace?()A、The RMAN backup fails because the TOOLS tablespace is read-onlyB、The RMAN skips the backup of the tablespace because backup optimization is enabledC、The RMAN makes backup because optimization can be enabled only for backups to diskD、The RMAN makes the backup because no backup of the tablespace exists within the seven day window
考题
Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager (RMAN) to perform backups. Which two backups would you be able to perform when the database is being accessed by users?()A、backup of offline tablespacesB、backup of readonly tablespacesC、backup of systemcritical tablespacesD、backup of online, locally managed tablespacesE、backup of read/write dictionarymanaged tablespaces
考题
You are maintaining the SALES database of a company. You have never backed up the USERS tablespace that is currently offline. On Sunday, you issued the following commands: CONFIGURE DEFAULT DEVICE TYPE TO sbt; CONFIGURE BACKUP OPTIMIZATION ON; CONFIGURE RETENTION POLICY TO REDUNDANCY 3; From Monday to Saturday, you performed the following actions: Day Action Monday BACKUP DATABASE Tuesday BACKUP DATABASE Wednesday BACKUP DATABASE Thursday BACKUP DATABASE Friday BACKUP DATABASE Saturday BACKUP DATABASE How many times will the backup of the USERS tablespace be performed?()A、 The backup will not be performed at all.B、 three timesC、 four timesD、 six times
考题
You want to perform an RMAN backup of database as a copy. Which two factors will you consider whileperforming the backup operation?() (Choose two).A、The backup as copy can only be taken to diskB、The backup as copy can only be taken to tapeC、Backup can be performed only when the instance is shutdownD、Backup will constitute all used and unused blocks in the database
考题
Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you. Which two statements are true in this scenario?()A、The instance aborts.B、The database cannot be recovered.C、The database can be recovered by restoring the control files from the backup.D、The database remains opened and you have to shut it down with the ABORT option.E、The database can be restored till the point of the last closed whole database backup.
考题
Every Sunday the Unix system administrator has a job that executes a full backup of the entire Unix system your database is on. Is this backup usable for backup and recovery of your database?() A、 Yes, if the database is in ARCHIVELOG modeB、 Yes, if the database is in NOARCHIVELOG modeC、 No, the backup is not usable in any wayD、 Only if the ENABLE_ONLINE_BACKUP parameter is set to TRUE
考题
You work as a database administrator for Supportcenter.cn. You are using Recovery Manager (RMAN) for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario?()A、The backup status will be marked expired in RMAN recovery catalog.B、The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.C、The backup will be deleted physically from the OS (Operating system)and the backup information is removed from the recovery cataloglD、The backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system).E、The backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system), if you are not using Oracle Managed Files (OMF).
考题
A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java. Knowing that your database is in danger,which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression?()A、 backup database allB、 backup compressed databaseC、 backup as compressed backupset databaseD、 backup as compressed backup database plus archivelog allE、 backup as compressed backupset database plus compress archivelog all
考题
You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?()A、The backup as copy can only be taken to diskB、The backup as copy can only be taken to tapeC、Backup can be performed only when the instance is shutdownD、Backup will constitute all used and unused blocks in the database
考题
Consider the following command: Backup database plus archivelog delete input; How many backup sets would be created by this command if the following were true:() Control-file a NN uto backups were enabled. NN The size of backup sets was not restricted. NN One channel was allocated. A、 1B、 2C、 3D、 4E、 5
考题
You have lost all your database control files. To recover them, you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery?() A、 You will need to open the database with the resetlogs command.B、 All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.C、 You will use the resetlogs version of the create controlfile command.D、 You will use the noresetlogs version of the create controlfile command.E、 You will use the trace file to create a backup control file, and then you will recover the database with the recover database using backup controlfile command
考题
单选题Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement: ALTER TABLESPACE data1 BEGIN BACKUP; While you are performing the backup, an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true?()A
The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.B
If you restart the database,the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.C
If you restart the database,the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.D
If you restart the database,the database will not be opened.
考题
单选题Consider the following scenario for your database: - Backup optimization is enabled in RMAN. - The recovery window is set to 7 days in RMAN. - The most recent backup to disk for the TOOLS tablespace was taken on November 3, 2007. - The TOOLS tablespace is read-only since November 4, 2007. On November 23, 2007, you issue the RMAN command to back up the database to disk. Which statement is true regarding the backup of the TOOLS tablespace?()A
The RMAN backup fails because the TOOLS tablespace is read-onlyB
The RMAN skips the backup of the tablespace because backup optimization is enabledC
The RMAN makes backup because optimization can be enabled only for backups to diskD
The RMAN makes the backup because no backup of the tablespace exists within the seven day window
考题
单选题A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java. Knowing that your database is in danger,which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression?()A
backup database allB
backup compressed databaseC
backup as compressed backupset databaseD
backup as compressed backup database plus archivelog allE
backup as compressed backupset database plus compress archivelog all
考题
单选题Every Sunday, consistent backups are performed on your database. Because of a user error, you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS option. A user error occurs again on Thursday, which necessitates an incomplete recovery. Sunday’s backup is the most recent backup available.What would you do in this scenario?()A
recovery cannot be performed because a backup was not performed after the last incomplete recoveryB
restore all the files from Sunday’s backup, and then recover up to the point in time when the RESETLOGS operation was performed on TuesdayC
restore all the files from Sunday’s backup, and open the database to reset the database to the point in time when the backup was performed on SundayD
restore all the files from Sunday’s backup, and then perform an incomplete recovery up to the point in time when the user error occurred on Thursday
考题
单选题Examine the following scenario: -Database is running in ARCHIVELOG mode. -Complete consistent backup is taken every Sunday. -On Tuesday the instance terminates abnormally because the disk on which control files are located gets corrupted -The disk having active online redo log files is also corrupted. -The hardware is repaired and the paths for online redo log files and control files are still valid. Which option would you use to perform the recovery of database till the point of failure?()A
Restore the latest whole backup, perform complete recovery, and open the database normallyB
Restore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGS optionC
Restore the latest backups control file, perform complete recovery, and open the database with the RESETLOGS optionD
Restore the latest backup control file, perform incomplete recovery using backup control file, and open the database with the RESETLOG option
考题
单选题Consider the following scenario for your database: Which statement is true regarding the backup of the TOOLS tablespace?()A
The RMAN backup fails because the TOOLS tablespace is read-onlyB
The RMAN skips the backup of the tablespace because backup optimization is enabledC
The RMAN makes backup because optimization can be enabled only for backups to diskD
The RMAN makes the backup because no backup of the tablespace exists within the seven day window
考题
单选题Every Sunday the Unix system administrator has a job that executes a full backup of the entire Unix system your database is on. Is this backup usable for backup and recovery of your database?()A
Yes, if the database is in ARCHIVELOG modeB
Yes, if the database is in NOARCHIVELOG modeC
No, the backup is not usable in any wayD
Only if the ENABLE_ONLINE_BACKUP parameter is set to TRUE
考题
单选题Consider the following command: Backup database plus archivelog delete input; How many backup sets would be created by this command if the following were true:() Control-file a NN uto backups were enabled. NN The size of backup sets was not restricted. NN One channel was allocated.A
1B
2C
3D
4E
5
考题
单选题You have lost all your database control files. To recover them, you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery?()A
You will need to open the database with the resetlogs command.B
All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.C
You will use the resetlogs version of the create controlfile command.D
You will use the noresetlogs version of the create controlfile command.E
You will use the trace file to create a backup control file, and then you will recover the database with the recover database using backup controlfile command
考题
多选题Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you. Which two statements are true in this scenario?()AThe instance aborts.BThe database cannot be recovered.CThe database can be recovered by restoring the control files from the backup.DThe database remains opened and you have to shut it down with the ABORT option.EThe database can be restored till the point of the last closed whole database backup.
考题
单选题You are maintaining the SALES database of a company. You have never backed up the USERS tablespace that is currently offline. On Sunday, you issued the following commands: CONFIGURE DEFAULT DEVICE TYPE TO sbt; CONFIGURE BACKUP OPTIMIZATION ON; CONFIGURE RETENTION POLICY TO REDUNDANCY 3; From Monday to Saturday, you performed the following actions: Day Action Monday BACKUP DATABASE Tuesday BACKUP DATABASE Wednesday BACKUP DATABASE Thursday BACKUP DATABASE Friday BACKUP DATABASE Saturday BACKUP DATABASE How many times will the backup of the USERS tablespace be performed?()A
The backup will not be performed at all.B
three timesC
four timesD
six times
考题
多选题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
热门标签
最新试卷