until Thursday morning
until that point in time when the database is opened
until that point in time when the recovery is performed
until last Sunday’s backup
until that point in time when the table is dropped and purged
until Wednesday evening
第1题:
Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens? ()
第2题:
Which two statements are true regarding the database in ARCHIVELOG mode?()
第3题:
You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Thursday morning, you find that an important table has been dropped and purged. With reference to this scenario, up to what point in time can the data be recovered?()
第4题:
In your production database, you have observed that the database server performance degrades whenever there is a switch between the log groups. On further investigation, you find that the database is running in ARCHIVELOG mode and the archived log files are being written to the same disk that is used to store the redo log members. Which two actions would you take to improve the performance of the database server? ()
第5题:
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?()
第6题:
You database operates in ARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Tuesday, at 9:00 a.m. the current log sequence number was 369. Also, on Tuesday you lost the data file belonging to the SYSTEM tablespace and an achivelog file (sequence number 356) that contained redo entries between 8:00 a.m. and 8.30 a.m. With reference to this scenario, what would you do to recover the database?()
第7题:
In which two cases would you perform only consistent backup?()
第8题:
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?()
第9题:
Your database is in ARCHIVELOG mode. You have two online redo log groups,each of which contains one redo member. When you attempt to start the database, you receive the following errors:()
第10题:
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?()