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

题目内容 (请给出正确答案)
多选题
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.


参考答案

参考解析
解析: 暂无解析
更多 “多选题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.” 相关考题
考题 You are working on the PROD database, which is in NOARCHIVELOG mode. You lost the active online redo log group due to a media failure. How should you recover your database?()A、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then, open the database with the RESETLOGS option after performing a cancel-based recovery.B、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then, drop the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.C、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then, clear the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.D、 Do nothing. You do not need to recover the database in this case; an instance recovery will be performed by the SMON process on startup.

考题 Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups?()A、The database is in mount state.B、One of the tablespaces is offline.C、One of the tablespaces is read only.D、The database operates in ARCHIEVELOG mode. E、The database operates in NOARCHIEVELOG mode.

考题 Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error, you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process?()A、 open the database with the RESTRICTED optionB、 open the database with the RESETLOGS optionC、 recover to the required SCN only that data file in which the error occurredD、 recover all the data files to the same system change number (SCN)

考题 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 test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database()A、You can perform online whole database backups.B、You can performofflinewhole database backups.C、You cannot perform schema-level export/import operations.D、You can perform the backup of only the SYSTEM tablespace when the database is open.

考题 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 read­only tablespacesC、backup of system­critical tablespacesD、backup of online, locally managed tablespacesE、backup of read/write dictionary­managed tablespaces

考题 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

考题 You are working on a database that must be functioning 24 hours a day, 7 days a week. The databaseis configured in ARCHIVELOG mode.  Which two options do you have for performing user-managed backups()A、You can perform consistent backups only.B、You can perform a complete database backup without shutting down the database instance.C、You can back up data files only when all data files have the same SCN recorded in the control file.D、You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands.

考题 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 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 operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error, you decided to perform an incomplete recovery.  Which two tasks would you be required to perform in the recovery process? ()A、open the database with the RESETLOGS optionB、open the database with the RESTRICTED optionC、recover all the data files to the same system change number (SCN)D、recover to the required SCN only that data file in which the error occurred

考题 Your boss at Certkiller .com wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups?()A、The database is in mount state.B、One of the tablespaces is offline.C、One of the tablespaces is read only.D、The database operates in ARCHIEVELOG mode.E、The database operates in NOARCHIEVELOG mode.

考题 You are working on an Oracle Database 10g database that operates in the ARCHIVELOG mode. At 06:00 p.m., you discovered that a table in the SYSTEM tablespace that does not belong to the data dictionary was dropped at 03:00 p.m. What would you do to recover the table?()A、 use the Flashback Transaction Query feature to identify the relevant SQL statement and use it to undrop the tableB、 restore the entire database from the most recent backup and open itC、 recover the table by using the Flashback Table featureD、 perform point-in-time recovery to recover the table

考题 多选题You are managing an Oracle Database 11g database. You configured the database to run inARCHIVELOG mode.  Which two statements are true in this scenario()AYou must shut down the database instance to perform the backups.BYou must configure the Flash Recovery Area (FRA) for the database.CYou can perform complete database backups without closing the database.DAll the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.

考题 多选题Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error, you decided to perform an incomplete recovery.  Which two tasks would you be required to perform in the recovery process? ()Aopen the database with the RESETLOGS optionBopen the database with the RESTRICTED optionCrecover all the data files to the same system change number (SCN)Drecover to the required SCN only that data file in which the error occurred

考题 多选题You are working on a database that must be functioning 24 hours a day, 7 days a week. The database isconfigured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups()AYou can perform consistent backups only.BYou can perform a complete database backup without shutting down the database instance.CYou can back up data files only when all data files have the same SCN recorded in the control file.DYou can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands

考题 单选题Your boss at Certkiller .com wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups?()A The database is in mount state.B One of the tablespaces is offline.C One of the tablespaces is read only.D The database operates in ARCHIEVELOG mode.E The database operates in NOARCHIEVELOG mode.

考题 多选题You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode.  Which two statements are true in this scenario()AYou must shut down the database instance to perform the backups.BYou must configure the Flash Recovery Area (FRA) for the database.CYou can perform complete database backups without closing the database.DAll the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.

考题 多选题You want to perform an RMAN backup of database as a copy. Which two factors will you consider whileperforming the backup operation?() (Choose two).AThe backup as copy can only be taken to diskBThe backup as copy can only be taken to tapeCBackup can be performed only when the instance is shutdownDBackup will constitute all used and unused blocks in the database

考题 单选题Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database()A You can perform online whole database backups.B You can performofflinewhole database backups.C You cannot perform schema-level export/import operations.D You can perform the backup of only the SYSTEM tablespace when the database is open.

考题 单选题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 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.

考题 多选题You are working on a database that must be functioning 24 hours a day, 7 days a week. The databaseis configured in ARCHIVELOG mode.  Which two options do you have for performing user-managed backups()AYou can perform consistent backups only.BYou can perform a complete database backup without shutting down the database instance.CYou can back up data files only when all data files have the same SCN recorded in the control file.DYou can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands.

考题 多选题Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error, you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process?()Aopen the database with the RESTRICTED optionBopen the database with the RESETLOGS optionCrecover to the required SCN only that data file in which the error occurredDrecover all the data files to the same system change number (SCN)

考题 单选题Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups?()A The database is in mount state.B One of the tablespaces is offline.C One of the tablespaces is read only.D The database operates in ARCHIEVELOG mode. E The database operates in NOARCHIEVELOG mode.

考题 多选题You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?()AThe backup as copy can only be taken to diskBThe backup as copy can only be taken to tapeCBackup can be performed only when the instance is shutdownDBackup will constitute all used and unused blocks in the database

考题 多选题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.

考题 多选题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.