单选题You work as a database administrator for Certkiller .com. 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 

题目
单选题
You work as a database administrator for Certkiller .com. 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.

相似考题

1.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.

2. You work as a database administrator for Certkiller .com. In your production  database， the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database， you want to accomplish this task with no impact on the user’s connections.  Which activity must you have completed before accomplishing this task？（）A、You must have started the database instance in restricted mode.B、You must have started the database instance inNORMALmode.C、You must have started the database instance with server parameter file.D、You must have started the database instance but must not have mounted.E、You must have started the database instance but must not have opened.

3.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.

4. Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you.  Which two statements are true in this scenario？（）A、The instance aborts.B、The database cannot be recovered.C、The database can be recovered by restoring the control files from the backup.D、The database remains opened and you have to shut it down with the ABORT option.E、The database can be restored till the point of the last closed whole database backup.

更多“单选题You work as a database administrator for Certkiller .com. 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 ”相关问题

  • 第1题：

    You work as a database administrator for Certkiller .com. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN； What two actions are performed as a result of this command？（）

    • A、All control files are opened
    • B、All redo files are opened
    • C、The password file is opened
    • D、The parameter file is opened
    • E、All online data files are opened

    正确答案:B,E

  • 第2题：

    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？（）

    • A、Restore all the data files and open the database
    • B、Create the data file and performtablespacerecovery
    • C、No need to restore any file， just recover the database
    • D、Restore only the system data file and recover the database
    • E、Restore only lost date file and performtablespacerecovery

    正确答案:A

  • 第3题：

    You work as a database administrator for Certkiller .com. According to your backup strategy， you performed an incremental level 0 backup of your database. Which statement regarding this backup is true？（）

    • A、The backup is similar to image copy.
    • B、The backup contains all used data blocks.
    • C、The backup contains only unused data blocks.
    • D、The backup contains all data blocks changed since the last incremental level 1 backup.

    正确答案:B

  • 第4题：

    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.

    正确答案:D

  • 第5题：

    You work as a database administrator for Certkiller .com. 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.

    正确答案:D

  • 第6题：

    单选题
    You work as a database administrator for Certkiller .com. 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.


    正确答案： B
    解析： 暂无解析

  • 第7题：

    单选题
    You work as a database administrator for Certkiller .com. 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.


    正确答案： F
    解析： 暂无解析

  • 第8题：

    多选题
    You work as a database administrator for Certkiller .com. Your database is opened in NOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode.  How would you do this？（）
    A

    Execute the ALTER DATABASE ARCHIVELOG statement

    B

    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.


    正确答案： B,D
    解析： 暂无解析

  • 第9题：

    单选题
    Due to media failure you lost one of the data files belonging to the USERS tablespace， and the tablespace is not available to use. Which statement regarding the status of the database is true？（）
    A

    The database remains open.

    B

    The database gets dismounted.

    C

    The database becomes read only.

    D

    The database instance gets aborted.

    E

    The database gets shut down automatically.

    F

    The status of the database depends on the status of the USERS tablespace.


    正确答案： F
    解析： 暂无解析

  • 第10题：

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

    B

    dropping a user in your database

    C

    enabling or disabling redo log archiving

    D

    dropping a tablespace in your database

    E

    re-creating the control files， after you lost all the control files in your database


    正确答案： C
    解析： 暂无解析

  • 第11题：

    单选题
    You work as a database administrator for Certkiller .com. On a Monday morning， you find the database instance aborted. After inspecting the alert log file， you execute the STARTUP command in SQL*Plus to bring the instance up. What statement is true？（）
    A

    PMON coordinates media recovery.

    B

    SMON coordinates instance recovery.

    C

    PMON coordinates instance recovery.

    D

    Undo Advisor would roll back all uncommitted transactions.

    E

    SQL*PLUS reports an error with the message asking you to perform instance recovery. 


    正确答案： B
    解析： 暂无解析

  • 第12题：

    多选题
    You work as a database administrator for Certkiller .com. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN； What two actions are performed as a result of this command？（）
    A

    All control files are opened

    B

    All redo files are opened

    C

    The password file is opened

    D

    The parameter file is opened

    E

    All online data files are opened


    正确答案： C,D
    解析： 暂无解析

  • 第13题：

    Due to media failure you lost one of the data files belonging to the USERS tablespace， and the tablespace is not available to use. Which statement regarding the status of the database is true？（）

    • A、The database remains open.
    • B、The database gets dismounted.
    • C、The database becomes read only.
    • D、The database instance gets aborted.
    • E、The database gets shut down automatically.
    • F、The status of the database depends on the status of the USERS tablespace.

    正确答案:A

  • 第14题：

    You work as a database administrator for Certkiller .com. 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

  • 第15题：

    You work as a database administrator for Certkiller .com. Your database is opened in NOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode.  How would you do this？（）

    • A、Execute the ALTER DATABASE ARCHIVELOG statement 
    • B、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. 

    正确答案:B,D

  • 第16题：

    You work as a database administrator for Certkiller .com. In the middle of a transaction， a user session was abnormally terminated but the instance is still up and the database is open. Which two statements are true in this scenario？（）

    • A、Event Viewer gives more details on the failure.
    • B、The alert log file gives detailed information about the failure.
    • C、PMON rolls back the transaction and releases the locks.
    • D、SMON rolls back the transaction and releases the locks.
    • E、The transaction is rolled back by the next session that refers to any of the blocks updates by the failed transaction.
    • F、Data modified by the transaction up to the last commit before the abnormal termination is retained in the database.

    正确答案:C,F

  • 第17题：

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


    正确答案： D
    解析： 暂无解析

  • 第18题：

    单选题
    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
    解析： 暂无解析

  • 第19题：

    单选题
    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？（）
    A

    Restore all the data files and open the database

    B

    Create the data file and performtablespacerecovery

    C

    No need to restore any file， just recover the database

    D

    Restore only the system data file and recover the database

    E

    Restore only lost date file and performtablespacerecovery


    正确答案： E
    解析： 暂无解析

  • 第20题：

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


    正确答案： C
    解析： 暂无解析

  • 第21题：

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


    正确答案： D
    解析： 暂无解析

  • 第22题：

    多选题
    Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you. Which two statements are true in this scenario？（）
    A

    The instance aborts.

    B

    The database cannot be recovered.

    C

    The database can be recovered by restoring the control files from the backup.

    D

    The database remains opened and you have to shut it down with the ABORT option.

    E

    The database can be restored till the point of the last closed whole database backup.


    正确答案： A,E
    解析： 暂无解析

  • 第23题：

    单选题
    You work as a database administrator for Certkiller .com. According to your backup strategy， you performed an incremental level 0 backup of your database. Which statement regarding this backup is true？（）
    A

    The backup is similar to image copy.

    B

    The backup contains all used data blocks.

    C

    The backup contains only unused data blocks.

    D

    The backup contains all data blocks changed since the last incremental level 1 backup.


    正确答案： C
    解析： 暂无解析

  • 第24题：

    单选题
    You work as a database administrator for Certkiller .com. Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2， and archiving has stopped. All the redo logs are filled and database activity is halted. Database writer has written everything to disk.  Which command would you execute to proceed further？（）
    A

    RECOVER LOFIEL BLOCK GROUP 2；

    B

    ALTER DATABASE DROP LOGFILE GROUP 2；

    C

    ALTER DATABASE CLEAR LOGFILE GROUP 2；

    D

    ALTER DATABASE RECOVER LOGFILE GROUP 2；

    E

    ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2；


    正确答案： D
    解析： 暂无解析

相关内容