Archiver Process (ARCn): 1, 2, 5
System Monitor Process (SMON): 1, 4, 5
Process Monitor Process (PMON): 4, 5, 6
Database Writer Process (DBWn): 1, 3, 4
第1题:
Your database is running In ARCIIIVELOG mode. One of the data files, USBRDATAOI. DBF, in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available. Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?()
第2题:
Your production database is running in archivelog mode and you are using recovery manager (RMAN) with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the database instance after a regular maintenance task on Sunday, the database fails to open displaying the message that the data file belonging to the users tablespace are corrupted. The steps to recover the damaged data files are follows: 1. Mount the database 2. Open the database 3. Recover the data file 4. Restore the data file 5. Make the data file offline 6. Make the data file online Which option identifies the correct sequence that you must use to recover the data files?()
第3题:
Note the following functionalities of various background processes: 1:Record the checkpoint information in data file headers. CKPT 2:Perform recovery at instance startup. SMON 3:Cleanup unused temporary segments. SMON 4:Free the resources used by a user process when it fails. 5:Dynamically register database services with listeners. 6:Monitor sessions for idle session timeout. Which option has the correct functionalities listed for a background process()
第4题:
An important tablespace of your database is dropped by mistake. You use the Flashback Database feature to retrieve the tablespace. You perform the following steps to retrieve the tablespace: 1. You log on to Enterprise Manager as SYSDBA. 2. You select the maintenance screen. 3. You choose Perform Recovery option on the maintenance screen. 4. You choose Whole Database in the Object Type drop-down list Perform Recovery: Type screen. 5. You choose Recover to Current Time from the Operation Type on the Perform Recovery: Type screen. 6. You provide the Host Credentials for a database user. on the Perform Recovery: Type screen. 7. You click the continue button. An information screen appears saying that the database is unavailable. What is this information screen?()
第5题:
Note the following functionalities of various background processes: 1. Record the checkpoint information in data file headers. 2. Perform recovery at instance startup. 3. Cleanup unused temporary segments. 4. Free the resources used by a user process when it fails. 5. Dynamically register database services with listeners. 6. Monitor sessions for idle session timeout. Which option has the correct functionalities listed for a background process()
第6题:
uses undo data for roll forward
uses Flashback Log for recovery
uses online redo logs to roll back
uses undo data to roll back the transaction
uses Recovery Manager (RMAN) to roll back
uses the System Monitor (SMON) background process to perform instance recovery
第7题:
Archiver Process (ARCn): 1, 2, 5
System Monitor Process (SMON): 1, 4, 5
Process Monitor Process (PMON): 4, 5, 6
Database Writer Process (DBWn): 1, 3, 4
第8题:
Checkpoint (CKPT): 1, 2, 5
System Monitor (SMON): 1, 6
Process Monitor (PMON): 4, 6, 7
Database Writer (DBWR): 1, 3, 4
第9题:
7, 1, 5, 2, 3, 6, 4
1, 5, 7, 2, 3, 6; step 4 is not required
7, 1, 5, 2, 3, 6; step 4 is not requiredThis document was downloaded from =>> http://www.amaderforum.com
1, 2, 3, 5, 6, 4; step 7 is not required
第10题:
2,4,3
1,4,3,2
2,5,4,3,6
5,2,4,3,6
1,5,4,3,6,2
第11题:
Redo logs
Control file
The latest backup of only the damaged data file
The latest backup of all the data file in the USERS tablespace
Temporary files of temporary tablespace
Archive Logs since the latest backup to point of failure
第12题:
redo logs
control file
temporary files of temporary tablespace
the latest backup of only the damaged data file
the latest backup of all the data files In the USERS tablespace
第13题:
Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error, you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process?()
第14题:
You work as a database administrator for Certkiller .com. One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it?()
第15题:
Case 1: 1. Shut down the database and perform a backup. 2. Restore all the data files. 3. Mount the database. 4. Recover the database. 5. Without applying all the redo log files, open the database using the RESETLOGS option. 6. Back up the database. Case 2: 1. Shut down the database and perform a backup. 2. Restore only the data files of the tablespace where user error damaged the data. 3. Mount the database. 4. Recover the database. 5. Open the database with the RESETLOGS option. 6. Back up the database. Case 3: 1. Shut down the database. 2. Restore the data files. 3. Open the database. 4. Perform recovery to the current point in time. Which case has the correct steps for an incomplete recovery?()
第16题:
One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it?()
第17题:
Only case 1
Only case 2
Only case 3
Case 1 and 2
Case 2 and 3
Case 1 and 3
All cases, case 1, case 2, case 3
第18题:
1
2
3
4
1 and 3
1, 2, 3, and 4
第19题:
Inactive and current redo log files are required to accomplish recovery.
Online and archived redo log files are required to accomplish instance recovery.
All redo log entries after the last checkpoint are applied from redo log files to data files.
All redo log entries recorded in the current redo log file until the checkpoint position are applied to data files
第20题:
Archiver Process (ARCn): 1, 2, 5
System Monitor Process (SMON): 1, 4, 5
Process Monitor Process (PMON): 4, 5, 6
Database Writer Process (DBWn): 1, 3, 4
第21题:
Recovery Manager
Recovery Window
Recovery Wizard
Enterprise Manager Home Page
第22题:
Uses undo data for roll forward
Uses Flashback Log for recovery
Uses online redo logs to roll back
Uses undo data to roll back the transaction
Uses Recovery Manager (RMAN) to roll back
Uses the System Monitor (SMON) background process to perform instance recovery
第23题:
Archiver Process (ARCn):1, 2,5
System Monitor Process (SMON):1,4,5
Process Monitor Process (PMON):4,5,6
Database Writer Process (DBWn):1,3,4
第24题:
7, 1, 5, 2, 3, 6, 4
1, 2, 3,7, 5, 6, 4
7, 1, 4, 5, 2, 3, 6
1, 7, 5, 4, 2, 3, 6