网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
The database is currently open and the temp03.dbf tempfile belonging to the default temporarytablespace 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


参考答案

参考解析
解析: 暂无解析
更多 “单选题The database is currently open and the temp03.dbf tempfile belonging to the default temporarytablespace 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” 相关考题
考题 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

考题 打开数据库abc的正确命令是()A、USE abcB、USE DATABASE abcC、OPEN abcD、OPEN DATABASE abc

考题 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

考题 In your database, all the tablespaces are locally managed. You started Recovery Manager (RMAN) using recovery catalog. The following commands are used in the process of recovering the database by using the backup control file:  1.RESTORE CONTROLFILE;  2.RESTORE DATABASE;  3.ALTER DATABASE MOUNT;  4.SQL ALTER TABLESPACE temp ADD TEMPFILE  5.ALTER DATABASE OPEN RESETLOGS;  6.RECOVER DATABASE;  7.STARTUP NOMOUNT;  In what sequence would you use this process to perform the recovery?()A、 2, 7, 3, 5, 1, 6, 4B、 2, 1, 7, 6, 3, 5, 4C、 7, 1, 3, 2, 6, 5, 4D、 7, 2, 3, 1, 4, 6, 5

考题 What is the proper procedure to recover a lost tempfile?()  A、 Restore the backup copy of the tempfile from the backup media.B、 Re-create the tempfile with the create tempfile command.C、 Copy an existing tempfile from another database.D、 Re-create the tempfile with the create tablespace command.E、 Re-create the tempfile with the alter tablespace command.

考题 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

考题 After the recovery is complete, which command should you execute?()A、ALTER DATABASE OPEN;B、ALTER DATABASE CLEAR LOGFILE;C、ALTER DATABASE OPEN RESETLOGS;D、ALTER DATABASE OPEN NORESETLOGS;

考题 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?()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.

考题 单选题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

考题 单选题In your database, all the tablespaces are locally managed. You started Recovery Manager (RMAN) using recovery catalog. The following commands are used in the process of recovering the database by using the backup control file:  1.RESTORE CONTROLFILE;  2.RESTORE DATABASE;  3.ALTER DATABASE MOUNT;  4.SQL ALTER TABLESPACE temp ADD TEMPFILE  5.ALTER DATABASE OPEN RESETLOGS;  6.RECOVER DATABASE;  7.STARTUP NOMOUNT;  In what sequence would you use this process to perform the recovery?()A  2, 7, 3, 5, 1, 6, 4B  2, 1, 7, 6, 3, 5, 4C  7, 1, 3, 2, 6, 5, 4D  7, 2, 3, 1, 4, 6, 5

考题 多选题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

考题 单选题What is the proper procedure to recover a lost tempfile?()A Restore the backup copy of the tempfile from the backup media. B Re-create the tempfile with the create tempfile command. C Copy an existing tempfile from another database. D Re-create the tempfile with the create tablespace command. E Re-create the tempfile with the alter tablespace command.

考题 单选题After the recovery is complete, which command should you execute?()A ALTER DATABASE OPEN;B ALTER DATABASE CLEAR LOGFILE;C ALTER DATABASE OPEN RESETLOGS;D ALTER 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?()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.

考题 单选题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 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’;B SQL ALTER DATABASE ’OPEN’;C OPEN DATABASE;D DATABASE OPEN

考题 单选题What is the proper procedure to recover a lost tempfile?()A  Restore the backup copy of the tempfile from the backup media.B  Re-create the tempfile with the create tempfile command.C  Copy an existing tempfile from another database.D  Re-create the tempfile with the create tablespace command.E  Re-create the tempfile with the alter tablespace command.