单选题Which of the following statements is true when the database is in ARCHIVELOG mode and tablespaces are in hot backup mode？（）A Archive log generation is suspended until the tablespaces are taken out of hot backup mode. B Datafiles are not written to during hot backups.C Changes to the database are cached during the backup and not written to the datafiles to ensure that the datafiles are consistent when recovered.D The datafile headers are not updated during the backup.E The way data is written to the online redo logs is unchanged during the backup.
单选题
Which of the following statements is true when the database is in ARCHIVELOG mode and tablespaces are in hot backup mode？（）
A
Archive log generation is suspended until the tablespaces are taken out of hot backup mode.
B
Datafiles are not written to during hot backups.
C
Changes to the database are cached during the backup and not written to the datafiles to ensure that the datafiles are consistent when recovered.
D
The datafile headers are not updated during the backup.
E
The way data is written to the online redo logs is unchanged during the backup.
参考解析
解析：
暂无解析
相关考题：
You are managing a 24*7 database. The backup strategy for the database is to perform user－managedbackups.Identify two prerequisites to perform the backups. (Choose two.)() A. The database must be opened in restricted mode.B. The database must be configured to run in ARCHIVELOG mode.C. The tablespaces are required to be in backup mode before taking the backup.D. The tablespaces are required to be in read-only mode before taking the backup
To accomplish user-managed backup for the USERS tablespace， you issued the following command to put the database in backup mode： SQL ALTER TABLESPACE users BEGIN BACKUP； While copying the file to the backup destination a power outage caused the instance to te minate abnormally. Which statement is true about the next database startup and the USERS tablespace？（） A、 The database will open，and the tablespace automatically comes out of the backup mode.B、 The database will be mounted，and recovery must be performed on the USERS tablespace.C、 The database will be mounted，and data files in the USERS tablespace must be taken out of the backup mode.D、 The database will not be mounted，and you must restore all the data files for the USERS tablespace from the backup，and perform recovery.
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.
Which two statements are true regarding the database in ARCHIVELOG mode？（）A、You have to shut down the database to perform the backups.B、Archiving information is written to the data files and redo log files.C、You can perform complete database backups without closing the database.D、Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.E、All the previous database backups become invalid after you configure the database to ARCHIVELOG mode.
Your database is running in NOARCHIVELOG mode. You want to put the database in ARCHIVELOG mode. Which two statements regarding archive log destinations are true？（）A、The destination must be global only.B、A maximum of five destinations can be assigned.C、A maximum of ten different destinations can be assigned.D、All the destinations are determined by the server automatically.E、The destination may be local or remote for a Standby Database.F、The destination can be changed by setting the LOG_ARCHIVE_FORMAT initialization parameter.
You are managing a 24*7 database. The backup strategy for the database is to perform user-managedbackups.Identify two prerequisites to perform the backups. (Choose two.)（）A、The database must be opened in restricted mode.B、The database must be configured to run in ARCHIVELOG mode.C、The tablespaces are required to be in backup mode before taking the backup.D、The tablespaces are required to be in read-only mode before taking the backup
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 tablespaces.B、 Backup of read-only tablespaces.C、 Backup of system-critical tablespaces.D、 Backup of online， locally managed tablespaces.E、 Backup of read/write dictionary-managed tablespaces.
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
Your database is in NOARCHIVELOG mode. You start to do a backup， but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you？（） A、 Put the database in hot backup mode and perform an online backup，including backing up the archived redo logs.B、 Just back up the database datafiles without shutting down the database.C、 You will have to wait until you can shut down the database to perform the backup.D、 Mark each datafile as backup in progress， back them up individually，and then mark them as backup not in progress. No archived redo logs will need to be backed up.E、 Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing，you can shut down the database and back up the datafiles the user changed during the course of the remaining backup
In what state are the datafiles of a tablespace after a TSPITR has been successfully completed？（） A、 The datafiles have an ONLINE status.B、 The datafiles have an OFFLINE status.C、 The datafiles have an ONLINE status and are in hot backup mode prepared for an online backup.D、 The datafiles have an OFFLINE status and are in hot backup mode for an online backup.E、 The datafiles are in STANDBY mode.
Another DBA issues a shutdown abort command on a database on which you were running an online backup. What will happen when you try to restart the database？（） A、 Oracle will automatically take the datafile out of hot backup mode，generate a warning message，and then open the database.B、 Oracle will automatically take the datafile out of hot backup mode and then open the database.C、 Oracle will generate an error when trying to open the database，indicating that a datafile is in hot backup mode.You will need to correct this error before you can open the database.D、 The database will open with the file in hot backup mode. You can restart the backup at any time.E、 The datafile in hot backup mode will be corrupted and you will have to recover it.
The database Is configured in ARCHIVELOG mode. The database needs to be up 24 X 7. You want to perform user managed backup for the data files of the HR_DATA tablespace.To accomplish the task, you issued the following command: SQL ALTER TABLESPACE hi_data BEGIN BACKUP; Which two statements are true in this scenario? （）A、No transaction on the tablespace is allowed but you can perform queries.B、The tablespace will automatically come out of backup mode when the file copy is complete.C、The checkpoint change number is frozen in headers of the data files until the file is removed from backup mode.D、The database writes the before image of an entire block to the redo stream before modifying. block tor the first time.
You are peer reviewing a fellow DBAs backup plan for his NOARCHIVELOG mode database， as shown here： Put the tablespaces in backup mode. Back up the datafiles for all tablespaces. Take the tablespaces out of backup mode. Back up all archived redo logs. Your colleague asks for you to comment on his plan. Which response would be correct？（）A、 The plan will work as is.B、 The plan needs to be modified to allow for an archive-log switch after step 3.C、 The plan needs to be modified so that a backup of the archived redo logs occurs before step 1.D、 The plan needs to be adjusted to shut down the database after step 1 and to restart the database after step 2.E、 The plan cannot work as presented.
Which of the following statements is true when the database is in ARCHIVELOG mode and tablespaces are in hot backup mode？（）A、 Archive log generation is suspended until the tablespaces are taken out of hot backup mode. B、 Datafiles are not written to during hot backups.C、 Changes to the database are cached during the backup and not written to the datafiles to ensure that the datafiles are consistent when recovered.D、 The datafile headers are not updated during the backup.E、 The way data is written to the online redo logs is unchanged during the backup.
单选题Another DBA issues a shutdown abort command on a database on which you were running an online backup. What will happen when you try to restart the database？（）A Oracle will automatically take the datafile out of hot backup mode，generate a warning message，and then open the database.B Oracle will automatically take the datafile out of hot backup mode and then open the database.C Oracle will generate an error when trying to open the database，indicating that a datafile is in hot backup mode.You will need to correct this error before you can open the database.D The database will open with the file in hot backup mode. You can restart the backup at any time.E The datafile in hot backup mode will be corrupted and you will have to recover it.
多选题You are managing a 24*7 database. The backup strategy for the database is to perform user-managedbackups.Identify two prerequisites to perform the backups. (Choose two.)（）AThe database must be opened in restricted mode.BThe database must be configured to run in ARCHIVELOG mode.CThe tablespaces are required to be in backup mode before taking the backup.DThe tablespaces are required to be in read-only mode before taking the backup
单选题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?（）AThe DATA1 tablespace is automatically taken out of backup mode when the instance aborts.BIf you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.CIf you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.DIf you restart the database, the database will not be opened.
多选题Your database is running in NOARCHIVELOG mode. You want to put the database in ARCHIVELOG mode. Which two statements regarding archive log destinations are true？（）AThe destination must be global only.BA maximum of five destinations can be assigned.CA maximum of ten different destinations can be assigned.DAll the destinations are determined by the server automatically.EThe destination may be local or remote for a Standby Database.FThe destination can be changed by setting the LOG_ARCHIVE_FORMAT initialization parameter.
单选题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.
单选题You are peer reviewing a fellow DBAs backup plan for his NOARCHIVELOG mode database， as shown here： Put the tablespaces in backup mode. Back up the datafiles for all tablespaces. Take the tablespaces out of backup mode. Back up all archived redo logs. Your colleague asks for you to comment on his plan. Which response would be correct？（）A The plan will work as is.B The plan needs to be modified to allow for an archive-log switch after step 3.C The plan needs to be modified so that a backup of the archived redo logs occurs before step 1.D The plan needs to be adjusted to shut down the database after step 1 and to restart the database after step 2.E The plan cannot work as presented.
单选题To accomplish user-managed backup for the USERS tablespace， you issued the following command to put the database in backup mode： SQL ALTER TABLESPACE users BEGIN BACKUP； While copying the file to the backup destination a power outage caused the instance to te minate abnormally. Which statement is true about the next database startup and the USERS tablespace？（）A The database will open，and the tablespace automatically comes out of the backup mode.B The database will be mounted，and recovery must be performed on the USERS tablespace.C The database will be mounted，and data files in the USERS tablespace must be taken out of the backup mode.D The database will not be mounted，and you must restore all the data files for the USERS tablespace from the backup，and perform recovery.
多选题Which two statements about Recovery Manager （RMAN） backups are true？ （）AOnline redo log files can be backed up.BArchived redo log files are backed up.COnly used data blocks can be backed up as backup sets.DOnly consistent database backups can be performed.ERMAN backup can be taken only if the database is configured in ARCHIVELOG mode.
单选题In what state are the datafiles of a tablespace after a TSPITR has been successfully completed？（）A The datafiles have an ONLINE status.B The datafiles have an OFFLINE status.C The datafiles have an ONLINE status and are in hot backup mode prepared for an online backup.D The datafiles have an OFFLINE status and are in hot backup mode for an online backup.E The datafiles are in STANDBY mode.
多选题The database Is configured in ARCHIVELOG mode. The database needs to be up 24 X 7. You want to perform user managed backup for the data files of the HR_DATA tablespace. To accomplish the task， you issued the following command： SQL ALTER TABLESPACE hi_data BEGIN BACKUP； Which two statements are true in this scenario？（）ANo transaction on the tablespace is allowed but you can perform queries.BThe tablespace will automatically come out of backup mode when the file copy is complete.CThe checkpoint change number is frozen in headers of the data files until the file is removed from backup mode.DThe database writes the before image of an entire block to the redo stream before modifying. block tor the first time.
单选题To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance to terminate abnormally. Which statement is true about the next database startup and the USERS tablespace?（）AThe database will open, and the tablespace automatically comes out of the backup mode.BThe database will be mounted, and recovery must be performed on the USERS tablespace.CThe database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.DThe database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.
多选题Which two statements are true regarding the database in ARCHIVELOG mode？（）AYou have to shut down the database to perform the backups.BArchiving information is written to the data files and redo log files.CYou can perform complete database backups without closing the database.DOnline redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.EAll the previous database backups become invalid after you configure the database to ARCHIVELOG mode.
单选题Which of the following statements is true when the database is in ARCHIVELOG mode and tablespaces are in hot backup mode？（）A Archive log generation is suspended until the tablespaces are taken out of hot backup mode. B Datafiles are not written to during hot backups.C Changes to the database are cached during the backup and not written to the datafiles to ensure that the datafiles are consistent when recovered.D The datafile headers are not updated during the backup.E The way data is written to the online redo logs is unchanged during the backup.
单选题Your database is in NOARCHIVELOG mode. You start to do a backup， but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you？（）A Put the database in hot backup mode and perform an online backup，including backing up the archived redo logs.B Just back up the database datafiles without shutting down the database.C You will have to wait until you can shut down the database to perform the backup.D Mark each datafile as backup in progress， back them up individually，and then mark them as backup not in progress. No archived redo logs will need to be backed up.E Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing，you can shut down the database and back up the datafiles the user changed during the course of the remaining backup