单选题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 

题目
单选题
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

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

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 switch
  • B、 You should make a backup of the database
  • C、 You should switch the database to the NONARCHIVELOG mode
  • D、 You should shut down the database instance and perform a complete database recovery

正确答案:B

第2题:

Your database runs in NOARCHIVELOG mode, and is backed up every night using RMAN scripts. However, last night your assistant DBA performed a manual operating system backup, instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo?()

  • A、You need to perform the restore and recover operations manually, because the backup was made manually. 
  • B、First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. 
  • C、First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. 
  • D、You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information. 

正确答案:C

第3题:

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

正确答案:C

第4题:

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.

正确答案:B

第5题:

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.

正确答案:A

第6题:

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,E

第7题:

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 backup
  • B、Online backup
  • C、consistent backup
  • D、incremental backup
  • E、inconsistent backup

正确答案:C

第8题:

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.

正确答案:A

第9题:

Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning,media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday.  What would you do in this situation?()

  • A、recover using Oracle Flashback Database technology
  • B、restore the data files from backup and perform a complete recovery
  • C、restore only the corrupted data file and perform tablespace recovery
  • D、restore the data files from backup and perform cancel-based recovery
  • E、restore the entire database from the most recent backup and start the instance and open the database

正确答案:E

第10题:

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?()

  • A、 Backup of offline tablespaces.
  • B、 Backup of read-only tablespaces.
  • C、 Backup of system-critical tablespaces.
  • D、 Backup of online, locally managed tablespaces.
  • E、 Backup of read/write dictionary-managed tablespaces.

正确答案:A,B

更多相关问题