单选题Your database is set in NOARCHIVELOG mode and is backed up every night. There are 10 redo log groups on the database， each with three members， making a total of 30 redo log files. At lunchtime the server unexpectedly gets shut down. Upon restarting you

题目

单选题

Your database is set in NOARCHIVELOG mode and is backed up every night. There are 10 redo log groups on the database， each with three members， making a total of 30 redo log files. At lunchtime the server unexpectedly gets shut down. Upon restarting you notice that the data file belonging to the SYSTEM tablespace has become corrupted. You also notice that there have been 15 log switches during the day. Which solution should you use to recover as much committed data as possible？（）

Restore the data file for the SYSTEM tablespace then open the database.

Restore all redo logs form last night's backup, then restart the database.

Perform a complete restore of all files from last night's backup. Data entered into the database today must be reentered.

Mount the instance, take the SYSTEM tablespace offline, open the database, and then restore the data file, recover it, and bring the tablespace online.

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

相似问题和答案

第1题：

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

第2题：

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.

正确答案:A

第3题：

Which three actions are required to configure the Flashback Database? ()

A. set Flash Recovery Area

B. enable Flashback logging

C. create FLASHBACK tablespace

D. start the database in the ARCHIVELOG mode

E. start the database in the NOARCHIVELOG mode

参考答案：A, B, D

第4题：

Which two requirements are critically important to implement for your database backup strategy if you require a 24 hours a day， 7 days a week production environment？（）

A、ARCHIVELOG mode.
B、NOARCHIVELOG mode.
C、Open database backups.
D、Consistent whole backups.

正确答案:A,C

第5题：

you can perform an active database duplication when the database is in NOARCHIVELOG mode.（）

A、 True
B、 False

正确答案:B

第6题：

Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode？（）

A、 Database datafiles
B、 Control files
C、 Archived redo logs
D、 Online redo logs
E、 Flashback logs

正确答案:A,B,D

第7题：

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

正确答案:C

第8题：

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 ARCHIVELOG mode and the tablespace is online.
C、The database is in ARCHIVELOG mode and the tablespace is offline.
D、The database is in NOARCHIVELOG mode and the tablespace is online.
E、The database is in NOARCHIVELOG mode and the tablespace is offline.

正确答案:B,C,E

第9题：

You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?（）

A、Database Datafiles
B、Database Control Files
C、Online redo logs
D、Archived redo logs
E、The database SPFILE
F、None of the above, all these files are backed up.

正确答案:C

第10题：

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 mode
B、 Yes， if the database is in NOARCHIVELOG mode
C、 No， the backup is not usable in any way
D、 Only if the ENABLE_ONLINE_BACKUP parameter is set to TRUE

正确答案:C

Your database is set in NOARCHIVELOG mode and is backed up e

题目

相似问题和答案

更多相关问题

相关内容