网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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.
参考答案
参考解析
解析：
暂无解析
更多 “单选题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. ” 相关考题
考题
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.
考题
At database startup， you discover that one of the disks containing an index tablespace has been lost due to a media failure. A backup of the lost index tablespace is not available. You have all the necessary scripts to recreate the indexes. You need to re-create the indexes in a new index tablespace. Which action must you perform before re-creating the indexes？（）A、 Start the database in OPEN mode， and create a new index tablespace.B、 Start the database in OPEN mode， and drop the lost index tablespace from the database.C、Start the database in MOUNT mode， create a new index tablespace， and drop the lost index tablespace from the database.D、 Start the database in MOUNT mode， drop the lost index tablespace from the database， open the database， and create a new index tablespace.
考题
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.
考题
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.
考题
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.
考题
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）
考题
The database is configured in ARCHIVELOG mode and regular complete database backups are taken. The loss of which two types of files may require a recovery with the RESETLOGS option？（）A、 Control filesB、 Password filesC、 Inactive online redo log fileD、 Archived log files required to perform recoveryE、 Newly created tablespace which is not backed up
考题
Your database is open and running in ARCHIVELOG mode. You take RMAN full backups every Sunday night. On Monday morning， while querying the user1.employees table， you receive the following error message： 01578： ORACLE data block corrupted （file # 5， block # 51） ORA-01110： data file 5： ’/u01/app/oracle/oradata/orcl/example01.dbf’ You need to rectify the corruption while ensuring the following： The data file should remain online. The mean time to recover （MTTR） should be minimal. You are not using a backup control file， and all the archived logs are accessible. Which option would you choose？（）A、flash back the corrupted blocksB、use the DBMS_REPAIR packageC、use the RMAN TSPITR commandD、use the RMAN BLOCKRECOVER commandE、use the RESTORE DATABASE and RECOVER DATABASE commandsF、investigate the time at which the corruption occurred and perform a point-in-time recovery
考题
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.
考题
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
考题
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 NOARCHIVELOG mode and the tablespace is online.C、 The database is in NOARCHIVELOG mode and the tablespace is offline.D、 The database is in ARCHIVELOG mode and the tablespace is offline.E、 The database is in ARCHIVELOG mode and the tablespace is online.
考题
You are maintaining your database in Oracle10g. You perform a full user-managed backup every Sunday at 8：00 P.M. Your database is running in ARCHIVELOG mode. On Monday， at 9：00 A.M.， a tablespace is dropped. You decide to perform incomplete recovery to recover the dropped tablespace. Which two clauses can you use with the RECOVER command？（）A、 UNTIL SEQUENCEB、 UNTIL SCNC、 UNTIL CHANGED、 UNTIL CANCEL
考题
Your test database is running in NOARCHIVELOG mode. What are the implications of this？ （）A、You can perform open database backups.B、You can perform closed database backups.C、You cannot perform schema-level logical backups.D、You can perform the backup of only the SYSTEM tablespace when the database is open.
考题
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（）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.
考题
单选题At database startup， you discover that one of the disks containing an index tablespace has been lost due to a media failure. A backup of the lost index tablespace is not available. You have all the necessary scripts to recreate the indexes. You need to re-create the indexes in a new index tablespace. Which action must you perform before re-creating the indexes？（）A
Start the database in OPEN mode， and create a new index tablespace.B
Start the database in OPEN mode， and drop the lost index tablespace from the database.C
Start the database in MOUNT mode， create a new index tablespace， and drop the lost index tablespace from the database.D
Start the database in MOUNT mode， drop the lost index tablespace from the database， open the database， and create a new index tablespace.
考题
单选题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.
考题
单选题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.
考题
单选题Your database is open and running in ARCHIVELOG mode. You take RMAN full backups every Sunday night. On Monday morning， while querying the user1.employees table， you receive the following error message： 01578： ORACLE data block corrupted （file # 5， block # 51） ORA/x7f01110： data file 5： ’/u01/app/oracle/oradata/orcl/example01.dbf’ You need to rectify the corruption while ensuring the following： The data file should remain online. The mean time to recover （MTTR） should be minimal. You are not using a backup control file， and all the archived logs are accessible. Which option would you choose？（）A
flash back the corrupted blocksB
use the DBMS_REPAIR packageC
use the RMAN TSPITR commandD
use the RMAN BLOCKRECOVER commandE
use the RESTORE DATABASE and RECOVER DATABASE commandsF
investigate the time at which the corruption occurred and perform a pointintime recovery
考题
单选题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 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 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.
考题
单选题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 working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true？（）A
You must have change tracking enabled in your databaseB
Your database must be running in NOARCHIVELOG modeC
To back up a tablespace，it must be in backup modeD
To back up a tablespace，it must first be taken offline
考题
多选题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.
考题
多选题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.
考题
多选题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.
考题
多选题The database is configured in ARCHIVELOG mode and regular complete database backups are taken. Theloss of which two types of files may require a recovery with the RESETLOGS option? （）(Choose two)AControl filesBPassword filesCInactive online redo log fileDArchived log files required to perform recoveryENewly created tablespace which is not backed up
热门标签
最新试卷
