网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
The database is running in ARCHIVELOG mode and the FORMAT option is not configured in RMAN for disk backups. You configured the flash recovery area location and size by using the DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE initialization parameters. Which statement is correct in this scenario？（）
A
If the FORMAT option to the RMAN BACKUP command is specified， then RMAN creates backup pieces and image copies in the flash recovery area with names in the Oracle Managed Files （OMF） format.
B
If any local destinations for LOG_ARCHIVE_DEST_n are set， then archived redo logs are stored in these destinations as well as in the flash recovery area.
C
If the flash recovery area location is configured using the DB_RECOVERY_FILE_DEST initialization parameter， then the RMAN backup of Oracle managed datafiles （OMF） only will go to the flash recovery area by default.
D
If no other destination is configured for recovery files， then RMAN places the control file autobackups in the flash recovery area by default.
参考答案
参考解析
解析：
暂无解析
更多 “单选题The database is running in ARCHIVELOG mode and the FORMAT option is not configured in RMAN for disk backups. You configured the flash recovery area location and size by using the DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE initialization parameters. Which statement is correct in this scenario？（）A If the FORMAT option to the RMAN BACKUP command is specified， then RMAN creates backup pieces and image copies in the flash recovery area with names in the Oracle Managed Files （OMF） format.B If any local destinations for LOG_ARCHIVE_DEST_n are set， then archived redo logs are stored in these destinations as well as in the flash recovery area.C If the flash recovery area location is configured using the DB_RECOVERY_FILE_DEST initialization parameter， then the RMAN backup of Oracle managed datafiles （OMF） only will go to the flash recovery area by default.D If no other destination is configured for recovery files， then RMAN places the control file autobackups in the flash recovery area by default.” 相关考题
考题
You executed the following command in Recovery Manager （RMAN） to perform a backup of the DETTBS tablespace： RMAN BACKUP TABLESPACE DETTBS; Under which conditions would this command execute successfully？ （）A、The database is in NOMOUNT state.B、The database is in ARCHIVELOG mode and the tablespace is online.C、The database is in ARCHIVELOG mode and the tablespace is offline.D、The database is in NOARCHIVELOG mode and the tablespace is online.E、The database is in NOARCHIVELOG mode and the tablespace is offline.
考题
What Oracle process runs when the database is in ARCHIVELOG mode but not when it is in NOARCHIVELOG mode？（）A、 MMONB、 LGWRC、 ARCHD、 ARWRE、 COPY
考题
Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens？ （）A、archivalB、log writerC、database writerD、system monitorE、process monitorF、change tracking writer
考题
In order to perform Flashback Transaction Query operations， which of these steps are required？（）A、 Ensure that database is running with version 10.1 compatibility.B、 Enable Flashback Logging.C、 Enable Supplemental Logging.D、 Ensure that the database is running with version 10.0 compatibility.E、 Ensure that the database is in ARCHIVELOG mode.
考题
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.
考题
The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database？（）A、 Enable flashback logging.B、 Start the database in the ARCHIVELOG mode.C、 Issue the ALTER DATABASE FLASHBACK ON； command.D、 Set the FAST_START_MTTR_TARGET initialization parameter.
考题
You are managing an Oracle Database 11g database. The database is open， and you plan to perform Recovery Manager （RMAN） backups. Which three statements are true about these backups（）A、The backups would be consistent.B、The backups would be inconsistent.C、The backups would be possible only if the database is running in ARCHIVELOG mode.D、The backups would be possible only if the database is running in NOARCHIVELOG mode.E、The backups need to be restored and the database has to be recovered in case of a media failure
考题
Which statement is true about a whole consistent database backup on a database running in ARCHIVELOG mode（）A、The backup will consist of used data blocks only.B、The database must be shut down to accomplish the backup.C、The backup can be accomplished without shutting down the database.D、The backup will contain all database files that have never been backed up.
考题
Which two database operations can be performed at the MOUNT stage of database startup？（）A、renaming of data filesB、dropping the database userC、renaming of control filesD、multiplexing of control filesE、configuring the database in ARCHIVELOG mode
考题
Which is the correct command to put the database in ARCHIVELOG mode？（） A、 alter database archivelogB、 alter system enable archivelog modeC、 alter database enable archiveD、 alter database archivelog enableE、 None of the above
考题
多选题In order to perform Flashback Transaction Query operations， which of these steps are required？（）AEnsure that database is running with version 10.1 compatibility.BEnable Flashback Logging.CEnable Supplemental Logging.DEnsure that the database is running with version 10.0 compatibility.EEnsure that the database is in ARCHIVELOG mode.
考题
单选题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.
考题
单选题A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message . Which is the recommended sequence of operations you need to perform for the query successfully?（）A
Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace. B
Take the affected datafile offline (if not already offline), restore the damaged image of the datafile, and then bring it online. C
Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then open the database with resetlogs.D
Put the database in RESTRICTED mode, restore all the datafiles in the affected datafile and recover the tablespace, and then put the database in normal operational mode.
考题
多选题You are managing an Oracle Database 11g database. The database is open， and you plan to performRecovery Manager （RMAN） backups. Which three statements are true about these backups（）AThe backups would be consistent.BThe backups would be inconsistent.CThe backups would be possible only if the database is running in ARCHIVELOG mode.DThe backups would be possible only if the database is running in NOARCHIVELOG mode.EThe backups need to be restored and the database has to be recovered in case of a media failure.
考题
多选题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.
考题
单选题The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database？（）A
Enable flashback logging.B
Start the database in the ARCHIVELOG mode.C
Issue the ALTER DATABASE FLASHBACK ON； command.D
Set the FAST_START_MTTR_TARGET initialization parameter.
考题
多选题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.
考题
单选题You execute this command in MOUNT mode： ALTER DATABASE ARCHIVELOG； Where is the information that the database is now in ARCHIVELOG mode stored？（）A
SPFILEB
archive logC
control fileD
system tablespace
考题
单选题Which statement is true about a whole consistent database backup on a database running in ARCHIVELOG mode（）A
The backup will consist of used data blocks only.B
The database must be shut down to accomplish the backup.C
The backup can be accomplished without shutting down the database.D
The backup will contain all database files that have never been backed up.
考题
多选题You work as a database administrator for Certkiller .com. Your database is opened in NOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode. How would you do this？（）AExecute the ALTER DATABASE ARCHIVELOG statementBSelect ARCHIVELOG option in the database control and restart the database to apply the changes.CShut down and start the instance, and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement.DShut down and start the instance, mount the database, then execute the ALTER DATABASE ARCHIVELOG statement.
考题
单选题A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message： Which is the recommended sequence of operations you need to perform for the query successfully？（）A
Drop the affected tablespace，re-create the tablespace，restore the datafiles，and the tablespace.B
Take the affected datafile offline（if not already offline），restore the damaged image of the datafile，and then bring it online.C
Restart the database in MOUNT mode，restore the damaged datafile，recover the datafile and then open the database with resetlogs.D
Put the database in RESTRICTED mode，restore all the datafiles in the affected datafile and recover the tablespace，and then put the database in normal operational mode.
考题
多选题You are managing an Oracle Database 11g database. The database is open， and you plan to perform Recovery Manager （RMAN） backups. Which three statements are true about these backups（）AThe backups would be consistent.BThe backups would be inconsistent.CThe backups would be possible only if the database is running in ARCHIVELOG mode.DThe backups would be possible only if the database is running in NOARCHIVELOG mode.EThe backups need to be restored and the database has to be recovered in case of a media failure
考题
多选题You executed the following command in Recovery Manager （RMAN） to perform a backup of the DETTBS tablespace： RMAN BACKUP TABLESPACE DETTBS； Under which conditions would this command execute successfully？ （）AThe database is in NOMOUNT state.BThe database is in ARCHIVELOG mode and the tablespace is online.CThe database is in ARCHIVELOG mode and the tablespace is offline.DThe database is in NOARCHIVELOG mode and the tablespace is online.EThe database is in NOARCHIVELOG mode and the tablespace is offline.
考题
单选题Which is the correct command to put the database in ARCHIVELOG mode？（）A
alter database archivelogB
alter system enable archivelog modeC
alter database enable archiveD
alter database archivelog enableE
None of the above
考题
多选题Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens？ （）AarchivalBlog writerCdatabase writerDsystem monitorEprocess monitorFchange tracking writer
考题
多选题Which two database operations can be performed at the MOUNT stage of database startup？（）Arenaming of data filesBdropping the database userCrenaming of control filesDmultiplexing of control filesEconfiguring the database in ARCHIVELOG mode
考题
单选题What Oracle process runs when the database is in ARCHIVELOG mode but not when it is in NOARCHIVELOG mode？（）A
MMONB
LGWRC
ARCHD
ARWRE
COPY
考题
单选题If you issue the command shutdown abort prior to trying to put the database in ARCHIVELOG mode， what will be the result when you issue the command alter database archivelog？（）A
The alter database archivelog command will failB
The alter database archivelog inconsistent command must be used to put the database in ARCHIVELOG modeC
The alter database archivelog command will succeedD
The alter database archivelog command will ask if you want to make the database consistent firstE
There is no alter database archivelog command. The correct command is alter database alterlogging
热门标签
最新试卷
