网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
Your database is configured in NOARCHIVELOG mode. Due to a media failure， you have lost one of the datafiles belonging to a read-only tablespace. You know that the last backup was performed after the tablespace was made read-only. Which action should you take to restore the missing datafile in the minimum amount of time？（）
A
Restore all the datafiles from the backup.
B
Restore only the lost datafile from the backup.
C
Restore all the datafiles for the lost tablespace from the backup.
D
Restore all the datafiles for the lost tablespace and all the SYSTEM and SYSAUX datafiles from the backup.
参考答案
参考解析
解析：
暂无解析
更多 “单选题Your database is configured in NOARCHIVELOG mode. Due to a media failure， you have lost one of the datafiles belonging to a read-only tablespace. You know that the last backup was performed after the tablespace was made read-only. Which action should you take to restore the missing datafile in the minimum amount of time？（）A Restore all the datafiles from the backup.B Restore only the lost datafile from the backup.C Restore all the datafiles for the lost tablespace from the backup.D Restore all the datafiles for the lost tablespace and all the SYSTEM and SYSAUX datafiles from the backup.” 相关考题
考题
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.
考题
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.
考题
For which database operation would you need the database to be in the MOUNT state（）A、renaming the control filesB、re-creating the control filesC、dropping a user in your databaseD、dropping a tablespace in your databaseE、configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes
考题
Your database is in NOARCHIVELOG mode. After which two operations you should take the backup of control file？（）A、adding a new user to the databaseB、dropping a user from the databaseC、dropping a table from the databaseD、dropping a data file from a tablespaceE、adding a new tablespace to the database
考题
you can perform an active database duplication when the database is in NOARCHIVELOG mode.（）A、 TrueB、 False
考题
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 want to use the automatic management of backup and recovery operations features for your database. Which configuration must you set？（）A
Enable the flash recovery area and specify it as the archived redo log destination.B
Disable the flash recovery area and start the database instance in ARCHIVELOG mode.C
Enable the flash recovery area but do not specify it as the archived redo log destination. D
Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.
考题
单选题For which database operation would you need the database to be in the MOUNT state（）A
renaming the control filesB
re-creating the control filesC
dropping a user in your databaseD
dropping a tablespace in your databaseE
configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes
考题
单选题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.
考题
多选题Your database is in NOARCHIVELOG mode. After which two operations you should take the backup of control file？（）Aadding a new user to the databaseBdropping a user from the databaseCdropping a table from the databaseDdropping a data file from a tablespaceEadding a new tablespace to the database
考题
单选题Your database is in the NOARCHIVELOG mode. Since last night’s offline backup， the logs in group 1 have been written to twice. This morning， the SYSTEM data file has become corrupted. Up to what point can it be recovered？（）A
until the last commitB
cannot be recoveredC
until the last offline backupD
until the beginning of the last transaction
考题
单选题Assume your situation can be described as follows： x A full backup taken using RMAN is available on disk. x The current control files were NOT damaged and do not need to be restored. x All data files are damaged or lost. x The database is in NOARCHIVELOG mode. Which RMAN command would be most appropriate to use in line 3 of the following RMAN command set to restore and fully recover your database？（） 1. RMAN STARTUP MOUNT 2. RMAN RESTORE DATABASE; 3. RMAN （） 4. RMAN ALTER DATABASE OPEN;A
RECOVER DATABASE；B
SWITCH DATAFILE ALL；C
RESTORE CONTROL FILE；D
RECOVER DATABASE USING BACKUP CONTROL FILE；
考题
多选题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.
考题
单选题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 want to use the automatic management of backup and recovery operations features for your database.Which configuration must you set?（）A
Enable the flash recovery area and specify it as the archived redo log destination.B
Disable the flash recovery area and start the database instance in ARCHIVELOG mode.C
Enable the flash recovery area but do not specify it as the archived redo log destination.D
Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.
考题
单选题you can perform an active database duplication when the database is in NOARCHIVELOG mode.（）A
TrueB
False
考题
多选题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？（）Abackup of offline tablespacesBbackup of readonly tablespacesCbackup of systemcritical tablespacesDbackup of online， locally managed tablespacesEbackup of read/write dictionarymanaged tablespaces
考题
单选题Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten sincethe last backup. What would you do to recover the data file（）A
Take the USERS tablespace offline and re-create the lost data file.B
Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.C
Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.D
Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online
考题
多选题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？（）ABackup of offline tablespaces.BBackup of read-only tablespaces.CBackup of system-critical tablespaces.DBackup of online， locally managed tablespaces.EBackup of read/write dictionary-managed tablespaces.
考题
多选题You are maintaining a database that is in ARCHIVELOG mode. You have configured the flash recovery area in your database. The database is in MOUNT EXCLUSIVE mode， and you want to configure the Flashback Database feature. Which two options are NOT required to configure the Flashback Database feature？ （）AOpen the database in read-only mode.BSet the retention target with the DB_FLASHBACK_RETENTION_TARGET initialization parameter.CEnable the block change tracking feature.DExecute the ALTER DATABASE FLASHBACK ON statement.
考题
单选题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 test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERStablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last backup. What would you do to recover the data file（）A
Take the USERS tablespace offline and re-create the lost data file.B
Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.C
Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.D
Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online.
考题
单选题Your database is configured in NOARCHIVELOG mode. Due to a media failure， you have lost one of the datafiles belonging to a read-only tablespace. You know that the last backup was performed after the tablespace was made read-only. Which action should you take to restore the missing datafile in the minimum amount of time？（）A
Restore all the datafiles from the backup.B
Restore only the lost datafile from the backup.C
Restore all the datafiles for the lost tablespace from the backup.D
Restore all the datafiles for the lost tablespace and all the SYSTEM and SYSAUX datafiles from the backup.
考题
多选题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 work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file？（）A
Restore all the data files and open the databaseB
Create the data file and performtablespacerecoveryC
No need to restore any file， just recover the databaseD
Restore only the system data file and recover the databaseE
Restore only lost date file and performtablespacerecovery
热门标签
最新试卷