网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
In a situation where no multiplexing of redo logs takes place, what happens when Oracle cannot read data from the online redo log group for archiving?（）
A
Nothing happens
B
Oracle will automatically switch redo logs when detected
C
Oracle eventually won't allow new records to be added to the database
D
The instance crashes
参考答案
参考解析
解析：
暂无解析
更多 “单选题In a situation where no multiplexing of redo logs takes place, what happens when Oracle cannot read data from the online redo log group for archiving?（）A Nothing happensB Oracle will automatically switch redo logs when detected C Oracle eventually won't allow new records to be added to the database D The instance crashes” 相关考题
考题
Which of the following files cannot be backed up by RMAN? ()(Choose all that apply.)
A. Database datafilesB. Control filesC. Online redo logsD. Database pfilesE. Archived redo logs
考题
Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode？（） A、 Database datafilesB、 Control filesC、 Archived redo logsD、 Online redo logsE、 Flashback logs
考题
You are working on a test database where instance recovery takes a considerable amount of time.How can reduce the recovery time？（）A、By multiplexing the control filesB、By multiplexing the redo log filesC、By decreasing the size of redo log filesD、By configuring mean time to recover （MTTR） to a lower valueE、By setting the UNDO_RETENTION parameter to a higher value
考题
Because of a power outage， instance failure has occurred. From what point in the redo log does recovery begin and where does it end？（）A、current redo log and inactive redo logB、checkpoint position to end of redo logC、beginning of redo log to end of redo logD、all redo logs before the point of last commitE、beginning of redo log to checkpoint position
考题
You have configured the flash recovery area to store online redo log files， control files， archived redo logs and RMAN backups. Which of the following files can you successfully delete from the flash recovery area if you want to reclaim the space within it？（）A、 multiplexed control filesB、 RMAN obsolete backupsC、 multiplexed online redo log filesD、 archived redo logs that have not been copied to tape
考题
Which is the correct command to back up the database， back up the archived redo logs， and then remove the backed-up archived redo logs？（） A、 backup databaseB、 backup database and archivelogsC、 backup database plus archivelogsD、 backup database plus archivelog delete inputE、 backup database and archivelog delete input
考题
You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RESETLOGS option？ （）A、This operation resets the SCN for the database.B、This operation creates a new incarnation of the database.C、This operation moves all the redo log files to a different location.D、This operation deletes the old redo log files and creates new redo log files.E、This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.
考题
Which of the following does the recover command not do？（） A、 Restore archived redo logs.B、 Apply archived redo logs.C、 Restore incremental backups.D、 Apply incremental backups.E、 Restore datafile images.
考题
Which of the following parameters defines the location where Oracle should create archived redo logs?（）A、LOG_ARCHIVE_1 B、LOG_DESTINATION_1 C、LOG_ARCHIVED_DESTINATION_1D、LOG_ARCHIVE_DEST_1E、LOG_ARCHIVE_SOURCE_1
考题
单选题You are working as a DBA on Oracle Database 9i. You plan to upgrade your 9i database to Oracle 10g. To be familiar with the new database technology， you decide to install Oracle Database 10g on your workstation at home. You create a general purpose database. After the installation， you make the following changes in your initialization parameter file：LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST’ DB_RECOVERY_FILE_DEST = ’LOCATION=d：/product/10.1.0/flash_recovery_area’ DB_RECOVERY_FILE_DEST_SIZE=10g Where are the archived redo logs stored for your database？（）A
The archived redo logs are stored in an operating system-dependent location.B
The archived redo logs are stored in the location specified by LOG_ARCHIVE_DEST_1.C
The archived redo logs are stored in the location specified by DB_RECOVERY_FILE_DEST.D
The archived redo logs are stored in the locations specified by both LOG_ARCHIVE_DEST_1 and DB_RECOVERY_FILE_DEST.
考题
单选题You are adding redo logs to the Oracle database. Creating a new redo log adds information to which of the following Oracle resources? （）A
Shared pool B
Control file C
SGA D
PGA
考题
单选题Which is the correct command to back up the database， back up the archived redo logs， and then remove the backed-up archived redo logs？（）A
backup databaseB
backup database and archivelogsC
backup database plus archivelogsD
backup database plus archivelog delete inputE
backup database and archivelog delete input
考题
单选题In a situation where no multiplexing of redo logs takes place, what happens when Oracle cannot read data from the online redo log group for archiving?（）A
Nothing happensB
Oracle will automatically switch redo logs when detected C
Oracle eventually won't allow new records to be added to the database D
The instance crashes
考题
单选题Your database has a backup that was taken yesterday （Tuesday） between 13：00 and 15：00 hours. This is the only backup you have. You have lost all the archived redo logs generatedsince the previous Monday， but you have archived redo logs available from the previous Sunday and earlier. You now need to restore your backup due to database loss. To which point can you restore your database？（）A
13：00 on Tuesday.B
15：00 on Tuesday.C
Up until the last available archived redo log on Sunday.D
To any point； all the redo should still be available in the online redo logs.E
The database is not recoverable.
考题
单选题When you are allowing RMAN to backup your archived redo log files，how does RMAN know which archived redo logs to back up from your archive log destination？（）A
RMAN keeps a list of archive logs in a text file.B
The DBA must manually tell RMAN which archive logs to backup.C
RMAN has access to target control file and/or catalog information.D
RMAN looks at the ARCHIVE_LOG_DEST parameter of your target database and backs up all archive logs found.
考题
单选题You have configured the flash recovery area to store online redo log files， control files， archived redo logs and RMAN backups. Which of the following files can you successfully delete from the flash recovery area if you want to reclaim the space within it？（）A
multiplexed control filesB
RMAN obsolete backupsC
multiplexed online redo log filesD
archived redo logs that have not been copied to tape
考题
多选题Which of the following files cannot be backed up by RMAN？（）ADatabase datafilesBControl filesCOnline redo logsDDatabase pfilesEArchived redo logs
考题
多选题You are working on a test database where instance recovery takes a considerable amount of time. How can reduce the recovery time？（）ABy multiplexing the control filesBBy multiplexing the redo log filesCBy decreasing the size of redo log filesDBy configuring mean time to recover （MTTR） to a lower valueEBy setting the UNDO_RETENTION parameter to a higher value
考题
多选题You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RESETLOGS option？ （）AThis operation resets the SCN for the database.BThis operation creates a new incarnation of the database.CThis operation moves all the redo log files to a different location.DThis operation deletes the old redo log files and creates new redo log files.EThis operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.
考题
单选题The database is being restored from a closed backup. The data files， control files， password file， and parameter file are available， but the online redo logs are not. Because the online redo logs are not available， you must simulate recovery and alter the database open with the reset logs option so the online redo logs are created while the database opens. Which type of recover is used in this situation？（）A
until SCNB
until timeC
until cancelD
using backup control file
考题
单选题Because of a power outage， instance failure has occurred. From what point in the redo log does recovery begin and where does it end？ （）A
current redo log and inactive redo logB
checkpoint position to end of redo logC
beginning of redo log to end of redo logD
all redo logs before the point of last commitE
beginning of redo log to checkpoint position
考题
多选题Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode？（）ADatabase datafilesBControl filesCArchived redo logsDOnline redo logsEFlashback logs
考题
多选题Which of the following files cannot be backed up by RMAN? （）(Choose all that apply.）ADatabase datafilesBControl filesCOnline redo logsDDatabase pfilesEArchived redo logs
考题
单选题Which of the following does the recover command not do？（）A
Restore archived redo logs.B
Apply archived redo logs.C
Restore incremental backups.D
Apply incremental backups.E
Restore datafile images.
考题
单选题Which of the following parameters defines the location where Oracle should create archived redo logs?（）A
LOG_ARCHIVE_1 B
LOG_DESTINATION_1 C
LOG_ARCHIVED_DESTINATION_1D
LOG_ARCHIVE_DEST_1E
LOG_ARCHIVE_SOURCE_1
热门标签
最新试卷