多选题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.
多选题
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.
参考解析
解析：
暂无解析
相关考题：
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 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.
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
You are managing an Oracle Database 11g database. You configured the database to run inARCHIVELOG mode. Which two statements are true in this scenario（）A、You must shut down the database instance to perform the backups.B、You must configure the Flash Recovery Area （FRA） for the database.C、You can perform complete database backups without closing the database.D、All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.
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.
A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java. Knowing that your database is in danger，which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression？（）A、 backup database allB、 backup compressed databaseC、 backup as compressed backupset databaseD、 backup as compressed backup database plus archivelog allE、 backup as compressed backupset database plus compress archivelog all
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.
单选题For which database operation would you need the database to be in the MOUNT state（）Arenaming the control filesBre-creating the control filesCdropping a user in your databaseDdropping a tablespace in your databaseEconfiguring 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？ （）AYou can perform open database backups.BYou can perform closed database backups.CYou cannot perform schema-level logical backups.DYou 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？（）Auntil the last commitBcannot be recoveredCuntil the last offline backupDuntil 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;ARECOVER DATABASE；BSWITCH DATAFILE ALL；CRESTORE CONTROL FILE；DRECOVER DATABASE USING BACKUP CONTROL FILE；
单选题A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java. Knowing that your database is in danger，which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression？（）A backup database allB backup compressed databaseC backup as compressed backupset databaseD backup as compressed backup database plus archivelog allE backup as compressed backupset database plus compress archivelog all
多选题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 test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database（）AYou can perform online whole database backups.BYou can performofflinewhole database backups.CYou cannot perform schema-level export/import operations.DYou 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?（）AEnable the flash recovery area and specify it as the archived redo log destination.BDisable the flash recovery area and start the database instance in ARCHIVELOG mode.CEnable the flash recovery area but do not specify it as the archived redo log destination.DDisable 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（）ATake the USERS tablespace offline and re-create the lost data file.BShut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.CShut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.DTake 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.
单选题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（）ATake the USERS tablespace offline and re-create the lost data file.BShut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.CShut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.DTake 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.
单选题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？（）ARestore all the data files and open the databaseBCreate the data file and performtablespacerecoveryCNo need to restore any file， just recover the databaseDRestore only the system data file and recover the databaseERestore only lost date file and performtablespacerecovery
多选题The database is running in NOARCHIVELOG mode. A data file is lost. Which two are valid options for recover？（）ARestore the data file and perform incomplete recovery.BRestore the data file and perform point-in-time recover.CDrop the tablespace and lose all data in the tablespace.DRestore the database and lose all data since the last backup.