You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure， the instance has shut down before synchronizing all the database files. Which two statements are true？（）A、On startup， SMON coordinates instance

题目

You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure， the instance has shut down before synchronizing all the database files. Which two statements are true？（）

A、On startup， SMON coordinates instance recovery.
B、On startup， CKPT coordinates instance recovery.
C、On startup， use RMAN to perform instance recovery.
D、Uncommitted changes will be rolled back after the database is opened.
E、On startup， perform media recovery and then instance recovery.
F、On startup， all the files will be synchronized and you get both committed and uncommitted data.

相似考题

1.View the Exhibit to examine the error during the database startup.You open an RMAN session for the database instance. To repair the failure, you executed the following as the first command in the RMAN session:RMAN> REPAIR FAILURE;Which statement describes the consequence of the command?（）A. The command performs the recovery and closes the failures.B. The command only displays the advice and the RMAN script required for repair.C. The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command.D. The command executes the RMAN script to repair the failure and removes the entry from the Automatic Diagnostic Repository (ADR).

2. You are in the middle of a transaction updating a very important table. The machine on which a database wasrunning reboots because of power outage. This caused a database instance failure. Which statement is true inthis situation（）A、The online redo log files and archived redo log files are required to accomplish the recovery.B、The uncommitted transaction will be committed at the next startup of the database instance.C、The uncommitted transaction is rolled back automatically at the next opening of the database.D、The DBA has to perform the recovery on the database to recover the uncommitted transaction

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

4. Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten sincethe last backup. What would you do to recover the data file（）A、Take the USERS tablespace offline and re-create the lost data file.B、Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.C、Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.D、Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online

更多“You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure， the instance has shut down before synchronizing all the database files. Which two statements are true？（）A、On startup， SMON coordinates instance ”相关问题

第1题：

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
第2题：

You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, while all three production database instances are running, you execute the following command on the ASM instance : SQL> shutdown immediate; What is the result of executing this command?（）
- A、The ASM instance is shut down, but the other instances are still running.
- B、It results in an error because other database instances are connected to it.
- C、All the instances, including the ASM instance, are shut down in the IMMEDIATE mode.
- D、HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode.
正确答案:B
第3题：

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.
正确答案:C
第4题：

Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERStablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last backup. What would you do to recover the data file（）
- A、Take the USERS tablespace offline and re-create the lost data file.
- B、Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.
- C、Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.
- D、Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online.
正确答案:C
第5题：

After performing a clean shut down of the database instance for maintenance， you mount thedatabase and then execute a command to open the database： SQL> ALTER DATABASE OPEN； Which two statements are true（）
- A、The online redo log files and online data files are opened.
- B、All the online data file headers are checked for consistency.
- C、Instance recovery is performed before opening the database.
- D、The path and existence of all the log file members are checked
正确答案:A,B
第6题：

Which two statements about the background process of the database writer are true（）
- A、It is possible to have multiple database writers in an Oracle instance.
- B、It writes dirty buffers， if any， to data files whenever a checkpoint occurs.
- C、It writes dirty buffers， if any， to data files whenever a transaction commits.
- D、It writes dirty buffers， if any， to data files before the log writer （LGWR） writes
正确答案:A,B
第7题：

单选题
Which of the following options is true about shutting down an Automatic Storage Management （ASM） instance？（）
A
If the SHUTDOWN IMMEDIATE command is issued to the ASM instance， the ASM instance immediately shuts down.
B
If the SHUTDOWN ABORT command is issued to the ASM instance， the ASM instance will shut down all the database instances and then shut down immediately.
C
If the SHUTDOWN NORMAL command is issued to the ASM instance， before shutting down， the ASM instance waits for the dependent database instances to shut down.
D
If the SHUTDOWN TRANSACTIONAL command is issued to the ASM instance， the ASM instance passes the same SHUTDOWN command to the dependent database instances， but does not wait for any active transactions to complete before it shuts down.

正确答案： C
解析：暂无解析
第8题：

多选题
After performing a clean shut down of the database instance for maintenance， you mount the database andthen execute a command to open the database：SQL> ALTER DATABASE OPEN； Which two statements are true（）
A
The online redo log files and online data files are opened.
B
All the online data file headers are checked for consistency.
C
Instance recovery is performed before opening the database.
D
The path and existence of all the log file members are checked

正确答案： C,A
解析：暂无解析
第9题：

多选题
You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure， the instance has shut down before synchronizing all the database files. Which two statements are true？（）
A
On startup， SMON coordinates instance recovery.
B
On startup， CKPT coordinates instance recovery.
C
On startup， use RMAN to perform instance recovery.
D
Uncommitted changes will be rolled back after the database is opened.
E
On startup， perform media recovery and then instance recovery.
F
On startup， all the files will be synchronized and you get both committed and uncommitted data.

正确答案： B,F
解析：暂无解析
第10题：

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

正确答案： E,F
解析：暂无解析
第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题：

多选题
After performing a clean shut down of the database instance for maintenance， you mount thedatabase and then execute a command to open the database： SQL> ALTER DATABASE OPEN； Which two statements are true（）
A
The online redo log files and online data files are opened.
B
All the online data file headers are checked for consistency.
C
Instance recovery is performed before opening the database.
D
The path and existence of all the log file members are checked

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

Which of the following options is true about shutting down an Automatic Storage Management （ASM） instance？（）
- A、 If the SHUTDOWN IMMEDIATE command is issued to the ASM instance， the ASM instance immediately shuts down.
- B、 If the SHUTDOWN ABORT command is issued to the ASM instance， the ASM instance will shut down all the database instances and then shut down immediately.
- C、 If the SHUTDOWN NORMAL command is issued to the ASM instance， before shutting down， the ASM instance waits for the dependent database instances to shut down.
- D、 If the SHUTDOWN TRANSACTIONAL command is issued to the ASM instance， the ASM instance passes the same SHUTDOWN command to the dependent database instances， but does not wait for any active transactions to complete before it shuts down.
正确答案:C
第14题：

You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode. Which two statements are true in this scenario（）
- A、You must shut down the database instance to perform the backups.
- B、You must configure the Flash Recovery Area （FRA） for the database.
- C、You can perform complete database backups without closing the database.
- D、All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.
正确答案:C,D
第15题：

After performing a clean shut down of the database instance for maintenance， you mount the database andthen execute a command to open the database：SQL> ALTER DATABASE OPEN； Which two statements are true（）
- A、The online redo log files and online data files are opened.
- B、All the online data file headers are checked for consistency.
- C、Instance recovery is performed before opening the database.
- D、The path and existence of all the log file members are checked
正确答案:A,B
第16题：

In your database， UNDO_RETENTION has been set to 600 sec and UNDO tablespace is configured for RETENTION GUARANTEE. Which statement regarding RETENTION GUARANTEE is true？（）
- A、Undo data is retained until the next full database backup.
- B、No committed undo data will be overwritten for 10 minutes.
- C、Committed undo data will be kept forever if not overwritten within 600 seconds.
- D、Guarantees that requested undo information are available until the instance is shut down.
正确答案:B
第17题：

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
第18题：

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
第19题：

单选题
ou are in the middle of a transaction updating a very important table. The machine on which adatabase was running reboots because of power outage. This caused a database instance failure. Which statement is true in this situation（）
A
The online redo log files and archived redo log files are required to accomplish the recovery.
B
The uncommitted transaction will be committed at the next startup of the database instance.
C
The uncommitted transaction is rolled back automatically at the next opening of the database.
D
The DBA has to perform the recovery on the database to recover the uncommitted transaction.

正确答案： C
解析：暂无解析
第20题：

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

多选题
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
解析：暂无解析
第22题：

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

正确答案： D
解析：暂无解析
第23题：

单选题
You are in the middle of a transaction updating a very important table. The machine on which a database wasrunning reboots because of power outage. This caused a database instance failure. Which statement is true inthis situation（）
A
The online redo log files and archived redo log files are required to accomplish the recovery.
B
The uncommitted transaction will be committed at the next startup of the database instance.
C
The uncommitted transaction is rolled back automatically at the next opening of the database.
D
The DBA has to perform the recovery on the database to recover the uncommitted transaction

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

You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure， the instance has shut down before synchronizing all the database files. Which two statements are true？（）A、On startup， SMON coordinates instance

题目

相似考题

更多“You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure， the instance has shut down before synchronizing all the database files. Which two statements are true？（）A、On startup， SMON coordinates instance ”相关问题

相关内容