单选题For which database operation would you need the database to be in the MOUNT state（）Arenaming the control filesBre-creating the control filesCdropping a user in your databaseDdropping a tablespace in your databaseEconfiguring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes
单选题
For which database operation would you need the database to be in the MOUNT state（）
A
renaming the control files
B
re-creating the control files
C
dropping a user in your database
D
dropping a tablespace in your database
E
configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes
参考解析
解析：
暂无解析
相关考题：
Your database instance is running.You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?() A. Oracle Net ManagerB. Listener Control utilityC. Database Configuration AssistantD. Oracle Net Configuration Assistant
You plan to execute the following command to perform a Flashback Database operation in your database:SQL FLASHBACK DATABASE TO TIMESTAMP (SYSDATE －5／24);Which two statements are true about this?() A. The database must have multiplexed redo log filesB. The database must be in the MOUNT state to execute the commandC. The database must be in the NOMOUNT state to execute the commandD. The database must be opened in RESTRICTED mode before this operationE. The database must be opened with the RESETLOGS option after the flashback operation
Your multitenant container database (CDB) contains three pluggable database (PDBs). You find that the control file is damaged. You plan to use RMAN to recover the control file. There are no startup triggers associated with the PDBs.Which three steps should you perform to recover the control file and make the database fully operational?（）A. Mount the container database (CDB) and restore the control file from the control file auto backup.B. Recover and open the CDB in NORMAL mode.C. Mount the CDB and then recover and open the database, with the RESETLOGS option.D. Open all the pluggable databases.E. Recover each pluggable database.F. Start the database instance in the nomount stage and restore the control file from control file auto backup.
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.
You plan to execute the following command to perform a Flashback Database operation in your database： SQL FLASHBACK DATABASE TO TIMESTAMP （SYSDATE -5/24）； Which two statements are true about this？（）A、 The database must have multiplexed redo log filesB、 The database must be in the MOUNT state to execute the commandC、 The database must be in the NOMOUNT state to execute the commandD、 The database must be opened in RESTRICTED mode before this operationE、 The database must be opened with the RESETLOGS option after the flashback operation
For which database operation would you need the database to be in the MOUNT state（）A、renaming the control filesB、re-creating the control filesC、dropping a user in your databaseD、dropping a tablespace in your databaseE、configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes
You work as a database administrator for Supportcenter.cn. You added atablespaceto your database. Because of the changes to the physical structure of your database， you performed a backup of the control file to trace. After this， you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database？（）A、Start the instance and open the database， instance recovery automatically recoverscontrol filesB、Create a file based on the contents of the trace file and save it to the control file locations and start the databaseC、Re-create the database （The recovery of the control file is not possible because you have lost all the control files.）D、Start the instance， in the NOMOUNTstate，re-create the control file using the CREATE CONTROLFILE command stored in the trace file.E、Start the instance and MOUNT the database， then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup？（）A、 online redo log filesB、 alert log filesC、 control fileD、 datafiles associated with the SYSTEM tablespace
Your database is in NOARCHIVELOG mode. After which two operations you should take the backup of control file？（）A、adding a new user to the databaseB、dropping a user from the databaseC、dropping a table from the databaseD、dropping a data file from a tablespaceE、adding a new tablespace to the database
You work as a database administrator for Supportcenter.cn. Your database is opened inNOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode. How would you do this？（）A、Execute the ALTER DATABASE ARCHIVELOG statementB、Select ARCHIVELOG option in the database control and restart the database to apply the changes.C、Shut down and start the instance， and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement.D、Shut down and start the instance， mount the database， then execute the ALTER DATABASE ARCHIVELOG statement.
You work as a database administrator for Supportcenter.cn. You started the instance using theinit.orafile. You have two control files and three redo log groups in your database. You decided to protect the database against failures by adding one more control file. Which file is the appropriate way to perform this task？（）A、Shut down the instance， copy the control file to the third location and open the database.B、Abort the instance， copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile and open the database.C、Copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile， restart the instance and open the database.D、Shut down the instance， copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile and open the database.E、Shut down the instance， startup in the mount state， copy the control file to the third location， modify the CONTROL_FILES parameter ininit.oraand open the database.
You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state？（）A、renaming the control filesB、dropping a user in your databaseC、enabling or disabling redo log archivingD、dropping a tablespace in your databaseE、re-creating the control files， after you lost all the control files in your database
You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover the index tablespace？（）A、 by using the Flashback Database featureB、 by using RMAN incomplete recoveryC、 by performing a user-managed incomplete recoveryD、 by dropping and re-creating the index tablespace
You work as a database administrator for Certkiller .com. You added atablespaceto your database. Because of the changes to the physical structure of your database， you performed a backup of the control file to trace. After this， you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database？（）A、Start the instance and open the database, instance recovery automatically recovers control files B、Create a file based on the contents of the trace file and save it to the control file locations and start the database C、Re-create the database (The recovery of the control file is not possible because you have lost all the control files.) D、Start the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file. E、Start the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
Your database instance is running.You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?（）A、Oracle Net ManagerB、Listener Control utilityC、Database Configuration AssistantD、Oracle Net Configuration Assistant
Which two database operations can be performed at the MOUNT stage of database startup？（）A、renaming of data filesB、dropping the database userC、renaming of control filesD、multiplexing of control filesE、configuring the database in ARCHIVELOG mode
单选题You work as a database administrator for Supportcenter.cn. You started the instance using theinit.orafile. You have two control files and three redo log groups in your database. You decided to protect the database against failures by adding one more control file. Which file is the appropriate way to perform this task？（）AShut down the instance， copy the control file to the third location and open the database.BAbort the instance， copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile and open the database.CCopy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile， restart the instance and open the database.DShut down the instance， copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile and open the database.EShut down the instance， startup in the mount state， copy the control file to the third location， modify the CONTROL_FILES parameter ininit.oraand open the database.
单选题Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started. Which tool or utility would you use to start the listener？（）A Oracle Net ManagerB Listener Control utilityC Database Configuration AssistantD Oracle Net Configuration Assistant
单选题You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup？（）A online redo log filesB alert log filesC control fileD datafiles associated with the SYSTEM tablespace
单选题One of the tablespaces is read-only in your database. The loss of all control files forced you to re-create the control file. Which operation do you need to perform after re-creating the control file and opening the database？（）A drop and re-create the read-only tablespacesB rename the read-only data files to their correct file namesC change the tablespace status from read/write to read-onlyD re-create the read-only tablespace because it is automatically removed
单选题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？（）AThe instance would hang.BThe instance needs to be shut down.CThe instance would be in the open state.DThe instance would abort in such cases.EThe instance would be in the open and invalid state.FThe instance would in the open state， but all the background processes will be restarted.
单选题Your database instance is running.You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?（）AOracle Net ManagerBListener Control utilityCDatabase Configuration AssistantDOracle Net Configuration Assistant
单选题You work as a database administrator for Supportcenter.cn. You added atablespaceto your database. Because of the changes to the physical structure of your database， you performed a backup of the control file to trace. After this， you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database？（）AStart the instance and open the database， instance recovery automatically recoverscontrol filesBCreate a file based on the contents of the trace file and save it to the control file locations and start the databaseCRe-create the database （The recovery of the control file is not possible because you have lost all the control files.）DStart the instance， in the NOMOUNTstate，re-create the control file using the CREATE CONTROLFILE command stored in the trace file.EStart the instance and MOUNT the database， then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
单选题You work as a database administrator for Certkiller .com. You added atablespaceto your database. Because of the changes to the physical structure of your database， you performed a backup of the control file to trace. After this， you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database？（）AStart the instance and open the database, instance recovery automatically recovers control files BCreate a file based on the contents of the trace file and save it to the control file locations and start the database CRe-create the database (The recovery of the control file is not possible because you have lost all the control files.) DStart the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file. EStart the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
单选题You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state？（）Arenaming the control filesBdropping a user in your databaseCenabling or disabling redo log archivingDdropping a tablespace in your databaseEre-creating the control files， after you lost all the control files in your database
单选题You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover the index tablespace？（）A by using the Flashback Database featureB by using RMAN incomplete recoveryC by performing a user-managed incomplete recoveryD by dropping and re-creating the index tablespace
单选题You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup？（）A Database DatafilesB Database Control FilesC Online redo logsD Archived redo logsE The database SPFILEF None of the above，all these files are backed up