单选题Which of the following shut down options should not be used before performing a consistent whole database backup？（）ANORMALBTRANSACTIONALCABORTDIMMEDIATEEINCONSISTENT
单选题
Which of the following shut down options should not be used before performing a consistent whole database backup？（）
A
NORMAL
B
TRANSACTIONAL
C
ABORT
D
IMMEDIATE
E
INCONSISTENT
参考解析
解析：
暂无解析
相关考题：
The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each.One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;Which action should you perform immediately after using this command?（）A. You should perform a log switchB. You should make a backup of the databaseC. You should switch the database to the NONARCHIVELOG modeD. You should shut down the database instance and perform a complete database recovery
Whichofthefollowingshutdownoptionsshouldnotbeusedbeforeperformingaconsistentwholedatabasebackup?() A.NORMALB.TRANSACTIONALC.ABORTD.IMMEDIATEE.INCONSISTENT
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
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.
The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file： ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3； Which action should you perform immediately after using this command？（） A、 You should perform a log switchB、 You should make a backup of the databaseC、 You should switch the database to the NONARCHIVELOG modeD、 You should shut down the database instance and perform a complete database recovery
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.
Management has decided that the database must be available 24 hours a day， 7 days a week. Given this requirement， which type of backup is required？（）A、user-managed backups.B、partial database backups.C、consistent database backups.D、inconsistent database backups.
Which of the following options is true about shutting down an Automatic Storage Management （ASM） instance？（） A、 If the SHUTDOWN IMMEDIATE command is issued to the ASM instance， the ASM instance immediately shuts down.B、 If the SHUTDOWN ABORT command is issued to the ASM instance， the ASM instance will shut down all the database instances and then shut down immediately.C、 If the SHUTDOWN NORMAL command is issued to the ASM instance， before shutting down， the ASM instance waits for the dependent database instances to shut down.D、 If the SHUTDOWN TRANSACTIONAL command is issued to the ASM instance， the ASM instance passes the same SHUTDOWN command to the dependent database instances， but does not wait for any active transactions to complete before it shuts down.
You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case？ （）A、Hot backupB、Online backupC、consistent backupD、incremental backupE、inconsistent backup
Your database is running in NOARCHIVELOG mode with two online redo log files. The SALES table contains sales information for the organization. The SALES table belongs to the SALESTB tablespace. On Monday， you insert 10 rows into the SALES table. The current log sequence number is 14. You change the tablespace status from READ WRITE to READ ONLY for the SALESTB tablespace. You shut down the database and take a backup of the SALESTB tablespace. On Tuesday， you start the database. You change the status for the SALESTB tablespace from READ ONLY to READ WRITE. You insert 10 more rows into the SALES table and shut down the database. The current log sequence number is 15. When you try to open the database on Wednesday morning， you discover that the SALESTB tablespace was lost because of a media failure. Which of the following options is true about recovering the SALES table？（）A、 The SALES table cannot be recovered because the database is running in NOARCHIVELOG mode.B、 The SALES table can be recovered by restoring the SALESTB tablespace from the backup and performing a media recovery.C、 The SALES table can be recovered by restoring the SALESTB tablespace from the backup without performing any media recovery.D、 The SALES table can be recovered by restoring the SALESTB tablespace from the backup， but the rows inserted on Tuesday need to be inserted again.
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.
Your database is in NOARCHIVELOG mode. You start to do a backup， but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you？（） A、 Put the database in hot backup mode and perform an online backup，including backing up the archived redo logs.B、 Just back up the database datafiles without shutting down the database.C、 You will have to wait until you can shut down the database to perform the backup.D、 Mark each datafile as backup in progress， back them up individually，and then mark them as backup not in progress. No archived redo logs will need to be backed up.E、 Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing，you can shut down the database and back up the datafiles the user changed during the course of the remaining backup
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.
What is the proper command to shut down the database in a consistent manner?（）A、shutdown abort B、shutdown kill C、Shutdown nowait D、shutdown immediateE、shutdown halt
Which of the following steps is incorrect in the following sequence of enabling the ARCHIVELOG mode of a database？（）A、Shut down the database.B、Set the appropriate parameters in init.ora file.C、Start the database in NOMOUNT state.D、Issue the ALTER DATABASE ARCHIVELOG command.E、Open the database.F、Take a full closed backup.
Which of the following shut down options should not be used before performing a consistent whole database backup？（）A、NORMALB、TRANSACTIONALC、ABORTD、IMMEDIATEE、INCONSISTENT
单选题Which of the following options is true about shutting down an Automatic Storage Management （ASM） instance？（）A If the SHUTDOWN IMMEDIATE command is issued to the ASM instance， the ASM instance immediately shuts down.B If the SHUTDOWN ABORT command is issued to the ASM instance， the ASM instance will shut down all the database instances and then shut down immediately.C If the SHUTDOWN NORMAL command is issued to the ASM instance， before shutting down， the ASM instance waits for the dependent database instances to shut down.D If the SHUTDOWN TRANSACTIONAL command is issued to the ASM instance， the ASM instance passes the same SHUTDOWN command to the dependent database instances， but does not wait for any active transactions to complete before it shuts down.
单选题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.
多选题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
单选题Which of the following shut down options should not be used before performing a consistent whole database backup？（）ANORMALBTRANSACTIONALCABORTDIMMEDIATEEINCONSISTENT
单选题The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. Oneof the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3; Which action should you perform immediately after using this command?（）AYou should perform a log switchBYou should make a backup of the databaseCYou should switch the database to the NONARCHIVELOG modeDYou should shut down the database instance and perform a complete database recovery
单选题Examine the following scenario: -Database is running in ARCHIVELOG mode. -Complete consistent backup is taken every Sunday. -On Tuesday the instance terminates abnormally because the disk on which control files are located gets corrupted -The disk having active online redo log files is also corrupted. -The hardware is repaired and the paths for online redo log files and control files are still valid. Which option would you use to perform the recovery of database till the point of failure?（）ARestore the latest whole backup, perform complete recovery, and open the database normallyBRestore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGS optionCRestore the latest backups control file, perform complete recovery, and open the database with the RESETLOGS optionDRestore the latest backup control file, perform incomplete recovery using backup control file, and open the database with the RESETLOG option
单选题Your database is running in NOARCHIVELOG mode with two online redo log files. The SALES table contains sales information for the organization. The SALES table belongs to the SALESTB tablespace. On Monday， you insert 10 rows into the SALES table. The current log sequence number is 14. You change the tablespace status from READ WRITE to READ ONLY for the SALESTB tablespace. You shut down the database and take a backup of the SALESTB tablespace. On Tuesday， you start the database. You change the status for the SALESTB tablespace from READ ONLY to READ WRITE. You insert 10 more rows into the SALES table and shut down the database. The current log sequence number is 15. When you try to open the database on Wednesday morning， you discover that the SALESTB tablespace was lost because of a media failure. Which of the following options is true about recovering the SALES table？（）A The SALES table cannot be recovered because the database is running in NOARCHIVELOG mode.B The SALES table can be recovered by restoring the SALESTB tablespace from the backup and performing a media recovery.C The SALES table can be recovered by restoring the SALESTB tablespace from the backup without performing any media recovery.D The SALES table can be recovered by restoring the SALESTB tablespace from the backup， but the rows inserted on Tuesday need to be inserted again.
多选题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.
单选题Which statement is true about a whole consistent database backup on a database running in ARCHIVELOG mode（）AThe backup will consist of used data blocks only.BThe database must be shut down to accomplish the backup.CThe backup can be accomplished without shutting down the database.DThe backup will contain all database files that have never been backed up.
单选题Which statement is true about a whole consistent database backup on a database running in ARCHIVELOGmode（）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
单选题The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file： ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3； Which action should you perform immediately after using this command？（）A You should perform a log switchB You should make a backup of the databaseC You should switch the database to the NONARCHIVELOG modeD You should shut down the database instance and perform a complete database recovery
单选题Your database is in NOARCHIVELOG mode. You start to do a backup， but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you？（）A Put the database in hot backup mode and perform an online backup，including backing up the archived redo logs.B Just back up the database datafiles without shutting down the database.C You will have to wait until you can shut down the database to perform the backup.D Mark each datafile as backup in progress， back them up individually，and then mark them as backup not in progress. No archived redo logs will need to be backed up.E Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing，you can shut down the database and back up the datafiles the user changed during the course of the remaining backup