Oracle认证考试
The database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner?（）A、Allow the database to continue runni
题目
The database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner?（）
- A、Allow the database to continue running, drop the TEMP tablespace, and then re-create it with new tempfiles
- B、Shut down the database, restore and recover the tempfile from backup, and then open the database with RESETLOGS
- C、Allow the database to continue running, take the TEMP tablespace offline, drop the missing tempfile, and then create a new tempfile
- D、Allow the database to continue running, add a new tempfile to TEMP tablespace with a new name, and drop the tempfile that has been corrupted.
相似问题和答案
第1题：
You realize that the control file is damaged in your production database.After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?（）
A. Mount the database
B. Open the database in NORMAL mode
C. Open the database in RESTRICTED mode
D. Open the database with the RESETLOGS option
第2题：
You work as a database administrator for Certkiller .com. Your database is functional. One of the disks containing a mirrored redo log member has bad sectors in it. You are unable to fix the damaged file. How does the loss of a redo log member affect the instance of the database that is currently running？（）
- A、The instance would normally abort.
- B、The instance would not be affected.
- C、The instance would be invalid， so would have to be aborted.
- D、The instance would remain open， but the LGWR process would fail.
- E、The instance would remain open and would automatically create the missing file
正确答案:B
第3题：
打开数据库abc的正确命令是（ ）。
A．OPEN DATABASE abc
B．USE abc
C．USE DATABASE abc
D．OPEN abc
第4题：
Which command is used to open the database after an incomplete recovery？（）
- A、 alter database open
- B、 alter database open repairlog
- C、 alter database open resetlogs
- D、 alter database open resetlog
- E、 alter database resetlogs open
正确答案:C
第5题：
You work as a database administrator for Supportcenter.cn. The database is open. A media failure has occurred， resulting in loss of all the control files in your database. Which statement regarding the database instance is true in this scenario？（）
- A、The instance would hang.
- B、The instance needs to be shut down.
- C、The instance would be in the open state.
- D、The instance would abort in such cases.
- E、The instance would be in the open and invalid state.
- F、The instance would in the open state， but all the background processes will be restarted.
正确答案:D
第6题：
You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database.The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?（）
A. Open the database in NORMAL mode
B. Open the database in read-only mode
C. Open the database in RESTRICTED mode
D. Open the database with the RESETLOGS option
第7题：
打开数据库abc的正确命令是（）
- A、USE abc
- B、USE DATABASE abc
- C、OPEN abc
- D、OPEN DATABASE abc
正确答案:D
第8题：
David ( ) on a new database at the moment.
A. currently work
B. is currently working
C. currently working
第9题：
RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database？（）
- A、’SQL ALTER DATABASE OPEN’；
- B、SQL ALTER DATABASE ’OPEN’；
- C、OPEN DATABASE；
- D、DATABASE OPEN
正确答案:C
第10题：
Which command would you use to determine what database backups are currently available for restore?（）
- A、list database backup
- B、report database backup
- C、list backup of database
- D、list summary backup
- E、report backup of database
正确答案:C