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 tempfilesB、Shut down the database, restore and recover the tempfile from backup, and then open the database with RESETLOGSC、Allow the database to continue running, take the TEMP tablespace offline, drop the missing tempfile, and then create a new tempfileD、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.
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.
相关考题：
David ( ) on a new database at the moment.A. currently workB. is currently workingC. currently working
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 databaseB. Open the database in NORMAL modeC. Open the database in RESTRICTED modeD. Open the database with the RESETLOGS option
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 modeB. Open the database in read-only modeC. Open the database in RESTRICTED modeD. Open the database with the RESETLOGS option
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
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.
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
Which command is used to open the database after an incomplete recovery？（）A、 alter database openB、 alter database open repairlogC、 alter database open resetlogsD、 alter database open resetlogE、 alter database resetlogs open
Which command would you use to determine what database backups are currently available for restore?（）A、list database backupB、report database backup C、list backup of databaseD、list summary backupE、report backup of database
You have to shut down the database instance with the ABORT option because of a hardware failure. Which statement is true about the subsequent opening of the database？（）A、The database would open normally.B、The database would not open， and it would stop at mount stage.C、The database would open after automatically performing instance recovery.D、The database would not open， and you have to perform database recovery to open it.
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 databaseB、Open the database in NORMAL modeC、Open the database in RESTRICTED modeD、Open the database with the RESETLOGS option
Given the following RMAN commands，choose the option that reflects the order required to restore your currently operational ARCHIVELOG-mode database.（） a. restore database b. recover database c. shutdown immediate d. startup e. restore archivelog all f. alter database open A、 a， b， c， d， e， fB、 c， b， a， d， e， fC、 c， b， a， d， fD、 c， a， b， dE、 c， a， e， b， d， f
Which command would you use to determine what database backups are currently available for restore？（） A、 list database backupB、 report database backupC、 list backup of databaseD、 list summary backupE、 report backup of database
When performing a full database disaster recovery with RMAN， in what order would you execute these steps？（） a. Restore the control file from autobackups. b. Run the RMAN restore and recover command. c.Restore the database spfile from autobackups. d. Make the RMAN backup set pieces available. e. Open the database with the alter database open resetlogs command. f.Open the database with the alter database open command. A、 a， b， c， d， e， fB、 c， d， a， b， fC、 d， c， a， b， fD、 d， b， d， c， eE、 d， c， a， b， e
You are managing a single instance Oracle 10g database that utilizes the following parameters： Which of the following set of commands must you execute to enable Flashback Database？（）A、 STARTUP MOUNT EXCLUSIVE ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；B、 STARTUP MOUNT ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；C、 STARTUP MOUNT EXCLUSIVE ATLER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；D、 STARTUP MOUNT ALTER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；
Your database is in ARCHIVELOG mode. You lost an index tablespace due to a disk failure while the database was open. You have neither a backup of the lost index tablespace nor the scripts containing the CREATE INDEX statements to recreate the indexes. Currently， several users are executing long-running queries on the database. What will happen to the ongoing activity in the database？（）A、 The queries that are currently executing will abort and an error message will be returned to the user.B、 The queries that are currently executing will execute normally but future queries will not executed.C、 Data Manipulation Language （DML） statements cannot be performed on the tables on which the indexes are based.D、 The currently executing and future queries will execute normally， but will be slower
Identify three valid methods of opening, pluggable databases (PDBs).（）A、ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from the rootB、ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from a pdbC、ALTER PLUGGABLE DATABASE PDB OPEN issued from the seedD、ALTER DATABASE PDB OPEN issued from the rootE、ALTER DATABASE OPEN issued from that pdbF、ALTER PLUGGABLE DATABASE PDB OPEN issued from another pdbG、ALTER PLUGGABLE DATABASE OPEN issued from that pdb
单选题You have to shut down the database instance with the ABORT option because of a hardware failure. Which statement is true about the subsequent opening of the database？（）AThe database would open normally.BThe database would not open， and it would stop at mount stage.CThe database would open after automatically performing instance recovery.DThe database would not open， and you have to perform database recovery to open it.
单选题Your database is in ARCHIVELOG mode. You lost an index tablespace due to a disk failure while the database was open. You have neither a backup of the lost index tablespace nor the scripts containing the CREATE INDEX statements to recreate the indexes. Currently， several users are executing long-running queries on the database. What will happen to the ongoing activity in the database？（）A The queries that are currently executing will abort and an error message will be returned to the user.B The queries that are currently executing will execute normally but future queries will not executed.C Data Manipulation Language （DML） statements cannot be performed on the tables on which the indexes are based.D The currently executing and future queries will execute normally， but will be slower
单选题Which command is used to open the database after an incomplete recovery？（）A alter database openB alter database open repairlogC alter database open resetlogsD alter database open resetlogE alter database resetlogs open
单选题Another DBA issues a shutdown abort command on a database on which you were running an online backup. What will happen when you try to restart the database？（）A Oracle will automatically take the datafile out of hot backup mode，generate a warning message，and then open the database.B Oracle will automatically take the datafile out of hot backup mode and then open the database.C Oracle will generate an error when trying to open the database，indicating that a datafile is in hot backup mode.You will need to correct this error before you can open the database.D The database will open with the file in hot backup mode. You can restart the backup at any time.E The datafile in hot backup mode will be corrupted and you will have to recover it.
多选题Identify three valid methods of opening, pluggable databases (PDBs).（）AALTER PLUGGABLE DATABASE OPEN ALL ISSUED from the rootBALTER PLUGGABLE DATABASE OPEN ALL ISSUED from a pdbCALTER PLUGGABLE DATABASE PDB OPEN issued from the seedDALTER DATABASE PDB OPEN issued from the rootEALTER DATABASE OPEN issued from that pdbFALTER PLUGGABLE DATABASE PDB OPEN issued from another pdbGALTER PLUGGABLE DATABASE OPEN issued from that pdb
单选题After the recovery is complete， which command should you execute？（）AALTER DATABASE OPEN；BALTER DATABASE CLEAR LOGFILE；CALTER DATABASE OPEN RESETLOGS；DALTER DATABASE OPEN NORESETLOGS；
单选题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?（）AAllow the database to continue running, drop the TEMP tablespace, and then re-create it with new tempfilesBShut down the database, restore and recover the tempfile from backup, and then open the database with RESETLOGSCAllow the database to continue running, take the TEMP tablespace offline, drop the missing tempfile, and then create a new tempfileDAllow the database to continue running, add a new tempfile to TEMP tablespace with a new name, and drop the tempfile that has been corrupted.
单选题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？（）AThe instance would normally abort.BThe instance would not be affected.CThe instance would be invalid， so would have to be aborted.DThe instance would remain open， but the LGWR process would fail.EThe instance would remain open and would automatically create the missing file
单选题You are managing a single instance Oracle 10g database that utilizes the following parameters： Which of the following set of commands must you execute to enable Flashback Database？（）A STARTUP MOUNT EXCLUSIVE ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；B STARTUP MOUNT ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；C STARTUP MOUNT EXCLUSIVE ATLER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；D STARTUP MOUNT ALTER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；
单选题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’；BSQL ALTER DATABASE ’OPEN’；COPEN DATABASE；DDATABASE OPEN