1. You have a database failure, which was due to some unidentifiable data corruption. You know that the corruption occurred at approximately between 6:15 P.M. and 7:00 P.M. What type of recovery would you perform? Choose the best answer.
A. Cancel-based recovery
B. SCN-based recovery
C. Time-based recovery
D. Incomplete recovery
Answer: C
Any time you stop the recovery process before all transactions are applied to the database, you are performing an incomplete recovery. All of the answers are a form of incomplete recovery and would work if you knew additional information. The best answer is a time-based incomplete recovery because you have the time frame when the corruption occurred. See Chapter 11 for more information.
Chapter: 103
2. You have an export that is generated from an online transaction processing (OLTP) database to validate data in the Data Mart database, which takes extracts from the OLTP database weekly. The export must be scripted to run nightly and include five tables that make up the primary tables in the Data Mart database. How could this export be performed?
A. By utilizing the config.ora export option
B. By utilizing the PARFILE export option
C. By utilizing the ifile export option
D. By performing an interactive export
Answer: B
The PARFILE command option allows you to group export commands together in a file so that you don't have to interactively respond to the prompts when you are running the export. This also allows you to script exports more efficiently. See Chapter 14 for more information.
Chapter: 103
3. In what file would you find the following entry?
NAMES.DIRECTORY_PATH= (HOSTNAME)
A. init.ora
B. sqlnet.ora
C. listener.ora
D. tnsnames.ora
Answer: B
The NAMES.DIRECTORY_PATH would be found in the sqlnet.ora file. This parameter specifies the names resolution search order that a client will use when attempting to resolve a net service name. See Chapter 3 for more information.
Chapter: 103
4. When specifying a log archive destination, which parameter can cause the database to hang if the log archive destination location cannot be written to?
A. OPTIONAL
B. REOPEN
C. MANDATORY
D. REQUIRED
Answer: C
The correct parameter is MANDATORY, which is used to further describe the LOG_ARCHIVE_DEST_N parameter. The MANDATORY parameter requires the archived logs to reach the LOG_ARCHIVE_DEST_N before writing new archived logs. See Chapter 7 for more information.
Chapter: 103
5. A statement failure and a process failure are what types of failure?
A. Media failure
B. User failure
C. Non-media failure
D. Statement failure
Answer: C
Statement failure and process failure are both types of non-media failure. These types of failure are usually less critical than media failures. See Chapter 5 for more information.
Chapter: 103
6. What method of undoing changes in the database uses an external data dictionary?
A. Flashback Query
B. Parallel query
C. LogMiner
D. Undo query
Answer: C
The LogMiner utility utilizes an external data dictionary that must be built before beginning the operations. See Chapter 5 for more information.
Chapter: 103
7. The Oracle Shared Server environment addresses which one of these problems?
A. Security
B. Extensibility
C. Performance
D. Scalability
Answer: D
The Oracle Shared Server environment addresses the problem of scalability. When memory or the number of processes on a server is taxed, the Shared Server configuration can address these problems. See Chapter 4 for more information.
Chapter: 103
8. Which V$ view can you use to monitor instance recovery performance of parallel rollback?
A. V$FAST_SERVERS
B. V$FAST_START
C. V$FAST_START_SERVERS
D. V$FAST_START_SERVER
Answer: C
The V$FAST_START_SERVERS view can help monitor instance recovery of parallel rollback. This view helps monitor the parallel transaction rollback process. See Chapter 6 for more information.
Chapter: 103
9. Which command unregisters the target database from the recovery catalog?
A. UNREGISTER from within RMAN
B. UNREGISTER from within SQL*Plus
C. Execute DBMS_RCVCAT.UNREGISTERDATABASE procedure
D. REMOVE REGISTER from within RMAN
Answer: C
To unregister a database, you must execute a stored procedure DBMS_RCVCAT.UNREGISTERDATABASE(<db_key>,<db_id>). The DB_KEY and DB_ID can be obtained from DB table when connected to the RMAN schema owner. See Chapter 13 for more information.
Chapter: 103
10. Which statement best describes a recovery performed in NOARCHIVELOG mode?
A. Some data will be lost in most situations.
B. Complete recovery can be performed in most situations.
C. Tablespace recovery can be performed.
D. No data will be lost in most situations.
Answer: A
Recovery in NOARCHIVELOG mode will result in some data being lost because the backup is from some previous timeframe and transactions haven't been stored since that backup. See Chapter 10 for more information.
Chapter: 103
11. Writing modified blocks to the database files and synchronizing the control files and data files best describes which process?
A. Complete recovery
B. Incomplete recovery
C. Checkpointing
D. Flushing dirty buffers
Answer: C
The main purpose of the database checkpoint is to record that the DBWR has written modified buffers to the data files by synchronizing these changes among the physical structures accordingly. See Chapter 6 for more information.
Chapter: 103
12. What action is the parameter LOG_ARCHIVE_MIN_SUCCEED_DEST responsible for?
A. Determining the maximum unsuccessful archived log destinations
B. Determining the minimum successful archived log destinations
C. Determining the minimum unsuccessful archived log destinations
D. Determining the maximum successful archived log destinations
Answer: B
The LOG_ARCHIVE_MIN_SUCCEED_DEST parameter determines the number of successful archive destinations required before the redo logs can be overwritten. See Chapter 7 for more information.
Chapter: 103
13. Study the RMAN script below. Choose the best answer to describe its function.
RMAN> create script db_backup{
2> allocate channel c1 type tape;
3> backup database;
4> }
A. This will create a RMAN script called db_backup.
B. This will create and store a RMAN script called db_backup.
C. This will create and execute a RMAN script called db_backup.
D. This will store a RMAN script called db_backup.
Answer: B
The create script will create and store a script in the recovery catalog for later use. See Chapter 13 for more information.
Chapter: 103
14. If the spfile.ora, init.ora, and config files exist in the appropriate directories, which file will be read first?
A. spfile.ora
B. init.ora
C. config.ora
D. ifile.ora
Answer: A
The spfile.ora file is new to Oracle9i. This is the binary initialization file that is the default when Oracle is started. The init.ora file is searched for only if there isn't a spfile.ora initialization file. See Chapter 6 for more information.
Chapter: 103
15. Which Oracle view will provide information on the request queue?
A. V$REQUEST_QUEUE
B. V$SHARED_QUEUE
C. V$QUEUE
D. V$PROCESS_QUEUE
Answer: C
The V$QUEUE view will display information regarding the shared server request and response queues. The information deals with how long requests are waiting in the queues. See Chapter 4 for more information.
Chapter: 103
16. You attempt to place a tablespace in backup mode, but are unable to do it. Why has this situation occurred?
A. The database does not have automatic archive logging enabled.
B. The database has automatic archive logging enabled.
C. The database is in ARCHIVELOG mode.
D. The database is not in ARCHIVELOG mode.
Answer: D
The database must be in ARCHIVELOG mode so that the tablespaces can be backed up online. See Chapter 7 for more information.
Chapter: 103
17. Which RMAN command is responsible for applying the archived logs to the database?
A. RESTORE DATABASE
B. RECOVER DATABASE
C. RECOVER ARCHIVE
D. RESTORE ARCHIVE
Answer: B
The RECOVER DATABASE command is responsible for applying the necessary archived logs to the database in the RMAN recovery process. See Chapter 10 for more information.
Chapter: 103
18. Which type of export will the export syntax shown below perform?
exp parfile=tst9par.pr file=tst9.dmp
A. Interactive export
B. Export utilizing PARFILE
C. Export utilizing a command file
D. Regular export
Answer: B
The export syntax is an example of the PARFILE command option. This allows you to group export commands together in a file so you don't have to interactively respond to the prompts when running the export. See Chapter 14 for more information.
Chapter: 103
19. You have a small network and would like to avoid configuring network files on the client workstations. One method of naming that would accomplish this would be
A. Localnaming
B. Hostnaming
C. Oracle Internet Directory
D. Internal naming
Answer: B
The hostnaming method allows the DBA to configure connectivity without having to have configuration files on the client machines. There are some caveats to using this method. See Chapter 3 for more information.
Chapter: 103
20. What is the name of the initialization parameter that designates the Flashback Query to store the undo data?
A. UNDO_ROLLBACK
B. ROLLBACK
C. UNDO_MANAGEMENT
D. UNDO_TABLESPACE
Answer: D
UNDO_TABLESPACE is the initialization parameter that designates the undo tablespace to be used for the Flashback Query. See Chapter 5 for more information.
Chapter: 103
21. What type of incomplete recovery is based on a point in time?
A. Cancel-based
B. Time-based
C. Change-based
D. Sequence-based
Answer: B
Time-based recovery requires the DBA to choose a point in time at which to end the recovery process. See Chapter 11 for more information.
Chapter: 103
22. A client is receiving the following error: "ORA-12154: TNS:could not resolve service name." Assuming you are using localnaming names resolution, which of the following is a possible cause of this error?
A. The Oracle listener is not running.
B. The user supplied a valid net service name but an invalid password.
C. An entry of NAMES.DIRECTORY_PATH=(HOSTNAME) in the sqlnet.ora file on the client.
D. An invalid HOST entry for this net service name definition in the tnsnames.ora file.
Answer: C
The NAMES.DIRECTORY_PATH=(HOSTNAME) will force the client to use hostnaming resolution and not localnaming names resolution. Therefore, the tnsnames.ora file will not be searched and will cause this error to occur if you are not using hostnaming. Answers A, B, and D would cause other ORA errors to occur. See Chapter 3 for more information.
Chapter: 103
23. You are in a recovery situation in which you must stop the recovery process before all transactions are applied to the database. You don't know when the best time is or at which transaction to stop the recovery. How would you recover the database?
A. Use cancel-based recovery.
B. Use time-based recovery.
C. Use change-based recovery.
D. Use sequence-based recovery.
Answer: A
Cancel-based recovery requires the DBA to manually cancel the recovery process at the command line. This can be used when you don't know when the best time, log file, or system change number at which to stop the recovery. This can also be used to arbitrarily stop the recovery process at any given point. See Chapter 11 for more information.
Chapter: 103
24. Study the following RMAN command. Choose the best answer to describe it.
catalog datafilecopy '/staging/cold/tst9/data01.dbf';
A. The RMAN command records that data files were copied or backed up from user-managed backup.
B. The RMAN command is invalid.
C. The RMAN command backs up control files that were copied or backed up from a user-managed backup.
D. The RMAN command backs up archived logs that were copied or backed up from user-managed backup.
Answer: A
The command CATALOG DATAFILECOPY records in the recovery catalog that the data files were copied or backed up by OS commands in user-managed backups. See Chapter 12 for more information.
Chapter: 103
25. Which dynamic performance view will show statistics on dispatcher processes, such as average number of bytes processed, the maximum number of inbound and outbound connections, and the average rate of bytes processed per client connection?
A. V$DISPATCHER
B. V$DISPATCHER_RATE
C. V$DISPATCHER_STATS
D. V$CIRCUIT
Answer: B
The V$DISPATCHER_RATE dynamic performance view contains statistics on the performance of the dispatchers in an Oracle Shared Server environment. See Chapter 4 for more information.
Chapter: 103
26. Which of the following commands is used for RMAN-based recovery based on SCN or transactional changes?
A. SET UNTIL CANCEL
B. SET UNTIL CHANGE
C. SET UNTIL SCN
D. SET UNTIL TIME
Answer: C
The RMAN command SET UNTIL SCN is used to perform recoveries based on SCNs or changes in the redo logs. See Chapter 11 for more information.
Chapter: 103
27. You want to see if a client can see a particular IP address on a TCP/IP network. Which command would you use?
A. tnsping 10.24.129.8
B. ping 10.24.129.8
C. ping host 10.24.129.8
D. tnsping host 10.24.129.8
Answer: B
The ping command can be used to determine if a client computer can see another computer on a TCP/IP network. You can supply either the hostname or the IP address of the computer you want to attempt to connect to. See Chapter 3 for more information.
Chapter: 103
28. You have a development database called DEV1 that has full nightly backups from RMAN with a recovery catalog. You have refreshed DEV1 on the dev server from your production database environment server called PRD1. This was accomplished by moving the PRD1 data files and parameter files to new locations and performing an incomplete recovery. What must be done to get the RMAN backup to work?
A. The new incarnation must be registered.
B. The DEV1 database must be unregistered.
C. The DEV1 database must be RESET.
D. The PRD1 database must be RESET.
Answer: C
The RESET command must be used on the incarnation of the database within the recovery catalog if the target database has been opened with ALTER DATABASE OPEN RESETLOGS. The ALTER DATABASE OPEN RESETLOGS command must be performed with all incomplete recoveries. See Chapter 13 for more information.
Chapter: 103
29. Which of the following files would not be found on an Oracle client?
A. tnsnames.ora
B. sqlnet.ora
C. listener.ora
D. All of the above
Answer: C
None of these network files can be found on the Oracle server. The listener.ora file would not be found on Oracle clients. See Chapter 3 for more information.
Chapter: 103
30. All transactions have been applied to a failed database. Which situation does this best describe?
A. Incomplete recovery
B. Complete recovery
C. Cancel-based recovery
D. Time-based recovery
Answer: B
Complete recovery means that all transactions are recovered. No data is lost or will need to be reentered when the database is recovered. See Chapter 10 for more information.
Chapter: 103
31. How could the existing RETENTION POLICY be identified?
A. Within SQL*Plus, you would execute the SHOW ALL command.
B. Within RMAN, you would execute the SHOW ALL command.
C. Within RMAN, you would execute the LIST ALL command.
D. Within SQL*Plus, you would execute the LIST ALL command.
Answer: B
The SHOW ALL command within RMAN will show all the configuration parameters, one of which is the retention policy. See Chapter 12 for more information.
Chapter: 103
32. What is the name of the preferred centralized naming solution provided by Oracle Net with Oracle9i?
A. Oracle Names Server
B. Oracle Internet Directory
C. Oracle Shared Server
D. Oracle Directory Server
Answer: B
Oracle Internet Directory is now the preferred centralized naming solution. This replaces the Oracle Names Server. See Chapter 1 for more information.
Chapter: 103
33. The database you are responsible for suddenly hangs and does not allow transactions to process. The only thing you have done recently is configure your database to operate in ARCHIVELOG mode and you have verified that one of the five redo logs was written to an archived log at the first log file switch. What has most likely happened?
A. Instance failure has occurred.
B. The SYSTEM tablespace is full.
C. The LOG_ARCHIVE_START parameter is not equal to TRUE.
D. The LOG_ARCHIVING parameter is not equal to TRUE.
Answer: C
The LOG_ARCHIVE_START command must be set to TRUE to enable automatic archiving. If it is not set to TRUE and the database is in ARCHIVELOG mode, the database will hang before it can recycle the online redo logs. See Chapter 7 for more information.
Chapter: 103
34. You have just installed an ATL device to improve the performance and capacity of the backup operations. When you execute the same RMAN backup scripts, you receive errors. Where should you begin your troubleshooting?
A. Validate the recovery catalog is still consistent.
B. Validate the media management library (MML) is correct and configured properly.
C. Verify that the RMAN backup scripts are compiled for the MML.
D. Verify that you are using the default MML from Oracle.
Answer: B
The media management library or media management layer (MML) is a third-party vendor library, which is linked in with the Oracle kernel so that the server session generated by RMAN interfaces with the third-party vendor's hardware. This library file should be received from the ATL hardware vendor and be configured according to their specifications. See Chapter 8 for more information.
Chapter: 103
35. If the database is not in ARCHIVELOG mode, which of the following is true?
A. Redo logs will not be generated.
B. Automatic archived logs will be created.
C. The ALTER TABLESPACE <tablespace_name> BEGIN BACKUP command will fail.
D. Only the ALTER TABLESPACE <tablespace_name> END BACKUP command will fail.
Answer: C
The database must be in ARCHIVELOG mode so that the tablespaces can be backed up online. This means that the ALTER TABLESPACE <tablespace_name> BEGIN BACKUP command, as well as the END BACKUP command, will fail. See Chapter 7 for more information.
Chapter: 103
36. What is the default port that the listener will be configured with when using TCP/IP?
A. 1521
B. 1575
C. 1526
D. 4381
Answer: A
Port 1521 is the default port that the listener will listen to for TCP/IP connections. This can be changed if necessary. See Chapter 2 for more information.
Chapter: 103
37. You perform nightly online backups of the database that you manage. You determine by checking the RMAN logs that the database backup did not complete last night. What should you do?
A. Check the status of the data files in the V$BACKUP view.
B. Check the status of the tablespaces in the ALL_BACKUP view.
C. Check the status of the RMAN backup in RC_BACKUP view.
D. Check the status of the database backup in DBA_BACKUP view.
Answer: A
The V$BACKUP view can be used to identify whether a database is actively being backed up or not. See Chapter 9 for more information.
Chapter: 103
38. Which of the following statements is TRUE about the entry below:
local_listener="(ADDRESS_LIST = (Address =
(Protocol = TCP) (Host=weishan) (Port=1522)))
A. You would see this entry in the tnsnames.ora file when configuring the Oracle Shared Server.
B. You would see this entry in the listener.ora file when configuring dynamic service registration.
C. You would see this entry in the init.ora file when configuring dynamic service registration.
D. You would see this entry in the sqlnet.ora file when configuring static service registration.
Answer: C
The entry would be found in the init.ora file when you want to configure a non-default listener to use for dynamic service registration. See Chapter 2 for more information.
Chapter: 103
39. What is the default initialization parameter when an Oracle9i database is started?
A. spfile.ora or spfile$ORACLE_SID.ora
B. init.ora or init$ORACLE_SID.ora
C. config.ora
D. ifile.ora
Answer: A
The spfile.ora is new for 9i. This is the binary initialization file that is the default when Oracle is started. The init.ora is searched for only if there isn't a spfile.ora initialization file. See Chapter 6 for more information.
Chapter: 103
40. If you want to modify the amount of trace information that will be produced by the listener, you would modify what parameter in the listener.ora file?
A. TRACE_LEVEL_LISTENER
B. TRACE_FILE_LISTENER
C. TRACE_DIRECTORY_LISTENER
D. TRACE_STATUS_LISTENER
Answer: A
The TRACE_LEVEL_LISTENER parameter in the listener.ora file determines the level of tracing output the listener will produce. The four possible values of this parameter are OFF, USER, ADMIN, and SUPPORT, with SUPPORT being the highest level of tracing. See Chapter 2 for more information.
Chapter: 103
41. Which of the following are features of the Oracle RMAN utility? (Choose all that apply.)
A. It provides scripting capabilities.
B. It interfaces with third-party tape media software.
C. It provides reports and lists of information.
D. It determines whether backups are still available in media.
E. It requires the use of a recovery catalog.
Answer: A, B, C, D
With the exception of option E, all of these are features of the RMAN utility. The recovery catalog is optional. See Chapter 8 for more information.
Chapter: 103
42. Study the following RMAN command. Choose the best answer to describe it.
RESYNCHRONIZE CATALOG;
A. This command resynchronizes the selected target database within the recovery catalog.
B. This command resynchronizes the recovery catalog database.
C. This is an invalid command.
D. This command resets the selected target database within the recovery catalog.
Answer: C
This is an invalid command. The proper syntax is RESYNCH CATALOG. See Chapter 13 for more information.
Chapter: 103
43. Which of the following are the main server-side components of Oracle Shared Server? (Choose all that apply.)
A. Dispatchers
B. Listeners
C. Shared servers
D. Database writers
Answer: A, C
The Oracle Shared Server configuration utilizes dispatchers to manage client connections and shared servers to process client requests. See Chapter 4 for more information.
Chapter: 103
44. Which statement best describes the purpose of the CROSSCHECK command?
A. It compares the recovery catalog with the tape media library for backups and the media they are stored on.
B. It compares the RMAN repository information in the control file with the tape media library for the existence of backups and the media they are stored on.
C. It checks the catalog for the existence of backups.
D. It checks the repository for the existence of backups.
Answer: A
The CROSSCHECK command performs comparison activities on the disk/tape media and the recovery catalog contents. See Chapter 12 for more information.
Chapter: 103
45. You are a DBA interested in using the Oracle Shared Server. Which one of these steps would NOT be performed to configure and initiate the Oracle Shared Server?
A. Configure the SHARED_SERVERS parameter in the init.ora file.
B. Stop and restart the Oracle Instance to enable use of the Oracle Shared Server.
C. Configure the DISPATCHERS parameter in the init.ora file.
D. Mount the database and issue the ALTER SYSTEM ENABLE SHARED SERVER command.
Answer: D
There is no need to issue any type of command to initiate the use of the Oracle Shared Server. The init.ora parameters should be set up and the instance can be stopped and restarted to have the changes take effect. See Chapter 4 for more information.
Chapter: 103
46. Which command initiates direct-path export?
A. DIRECT=Y
B. DIRECT=TRUE
C. DIRECT_PATH=Y
D. DIRECT_PATH=TRUE
Answer: A
The DIRECT=Y command will switch the export method from conventional path to direct path. See Chapter 14 for more information.
Chapter: 103
47. You have made a change to the listener.ora file and want to have the change take effect immediately. What is the best way to accomplish this with minimal interruption?
A. Stop and start the listener.
B. Stop and start the Oracle server.
C. Use the lsnrctl refresh command.
D. Use the lsnrctl reload command.
Answer: D
The lsnrctl reload command will reread information in the listener.ora file without bringing down the listener. This would cause the least amount of disruption to clients that are attempting to connect to the Oracle server. See Chapter 2 for more information.
Chapter: 103
48. What is the maximum retention period of the Flashback Query?
A. One day
B. Two days
C. Three days
D. Five days
Answer: D
Flashback query can only query data that is five days old or less regardless of the retention policy. See Chapter 5 for more information.
Chapter: 103
49. Study the following RMAN command. Choose the best answer to describe it.
change datafile '/staging/cold/tst9/data01.dbf' available;
A. Changes the status of a data file to available
B. Changes the status of a control file to available
C. This is an invalid RMAN command.
D. Changes the status of a data file to unavailable
Answer: C
This is an invalid RMAN command. The DATAFILE keyword should be DATAFILECOPY. See Chapter 12 for more information.
Chapter: 103
50. What line in this direct-load insert statement will cause the statement to fail?
ALTER SESSION DISABLE PARALLEL DML;
INSERT /*+PARALLEL (TEST.T1_NEW, 4) / INTO T1_NEW
NOLOGGING
SELECT * FORM T1
COMMIT;
A. The first line
B. The second line
C. The third line
D. The fourth line
E. The fifth line
Answer: A
In order to run direct-load insert, the performing session will need to have parallel DML enabled as opposed to disabled. The correct syntax is ALTER SESSION ENABLE PARALLEL DML;. See Chapter 15 for more information.
Chapter: 103
51. What file must be present on an Oracle client to start the listener process?
A. listener.ora
B. tnsnames.ora
C. sqlnet.ora
D. None of the above
Answer: D
Read the question carefully. There is no file that is required on the client to start the Oracle listener. The listener is a server-side process. See Chapter 2 for more information.
Chapter: 103
52. You have just experienced a media failure on one of the disks that contains one of the databases, four control files, and the temporary tablespace's data file. What are valid options to recover the database? (Choose all that apply.)
A. Restore and recover the control file and tablespace from the backup.
B. Restore and recover the data file from the backup and do nothing with the control file or init.ora reference.
C. Restore and recover the control file from the backup and do nothing with the temporary tablespace data file.
D. Remove the existing temporary tablespace reference from the data dictionary and create a new temporary tablespace. Remove the reference to the impacted control file from the init.ora file.
Answer: A, D
You could restore both the temporary tablespace's data file and the control file from the backup and recover to bring the files current with the rest of the database. Or, you could rebuild the temporary tablespace because it doesn't contain permanent objects-only temporary objects. This could be done by offline dropping the temporary tablespace and the creation of a new one. Since there are four control files, the impacted one is not necessary and could be removed from init.ora parameters, thus leaving three control files-which is adequate redundancy for the database. See Chapter 5 for more information.
Chapter: 103
53. An Oracle dedicated server process could most closely be compared to which one of the following?
A. A waiter who waits on only one person
B. A waiter who waits on many people
C. A cook who prepares meals for every person
D. A waiter who shows an individual to their seat and then helps other patrons to their seats
Answer: A
A dedicated server process is most like a waiter who waits on only one person. The waiter is responsible for serving only the needs of this person until that person leaves. See Chapter 4 for more information.
Chapter: 103
54. Which aspect of the recovery plan is the most often overlooked?
A. Backup process
B. Recovery process
C. The testing of the backup and recovery process
D. Restore process
Answer: C
Testing the backup and recovery process is usually the most overlooked aspect of the plan. At a minimum, certain tests should be performed on a regular basis. See Chapter 5 for more information.
Chapter: 103
55. Which of the following needs to be true of a database before a closed backup can be performed?
A. The database needs to be in NOARCHIVELOG mode.
B. The database needs to be in ARCHIVELOG mode.
C. A hot backup must also be able to be performed.
D. The database must have been shut down.
Answer: D
A closed backup is also called a cold backup, and it can only be performed when the database is shut down. The database can be in either ARCHIVELOG or NOARCHIVELOG mode. Remember to shut the database down cleanly. Do not use SHUTDOWN ABORT because it does not checkpoint the data files and control files. See Chapter 9 for more information.
Chapter: 103
56. Which of the following can you use to monitor instance recovery time estimates?
A. V$INSTANCE_RECOVER
B. V$INSTANCE_RECOVERY
C. V$INSTANCE_RECOVERIES
D. V$INST_RECOVERY
Answer: B
The V$INSTANCE_RECOVERY view can help monitor the estimated time of instance recovery. See Chapter 6 for more information.
Chapter: 103
A. Cancel-based recovery
B. SCN-based recovery
C. Time-based recovery
D. Incomplete recovery
Answer: C
Any time you stop the recovery process before all transactions are applied to the database, you are performing an incomplete recovery. All of the answers are a form of incomplete recovery and would work if you knew additional information. The best answer is a time-based incomplete recovery because you have the time frame when the corruption occurred. See Chapter 11 for more information.
Chapter: 103
2. You have an export that is generated from an online transaction processing (OLTP) database to validate data in the Data Mart database, which takes extracts from the OLTP database weekly. The export must be scripted to run nightly and include five tables that make up the primary tables in the Data Mart database. How could this export be performed?
A. By utilizing the config.ora export option
B. By utilizing the PARFILE export option
C. By utilizing the ifile export option
D. By performing an interactive export
Answer: B
The PARFILE command option allows you to group export commands together in a file so that you don't have to interactively respond to the prompts when you are running the export. This also allows you to script exports more efficiently. See Chapter 14 for more information.
Chapter: 103
3. In what file would you find the following entry?
NAMES.DIRECTORY_PATH= (HOSTNAME)
A. init.ora
B. sqlnet.ora
C. listener.ora
D. tnsnames.ora
Answer: B
The NAMES.DIRECTORY_PATH would be found in the sqlnet.ora file. This parameter specifies the names resolution search order that a client will use when attempting to resolve a net service name. See Chapter 3 for more information.
Chapter: 103
4. When specifying a log archive destination, which parameter can cause the database to hang if the log archive destination location cannot be written to?
A. OPTIONAL
B. REOPEN
C. MANDATORY
D. REQUIRED
Answer: C
The correct parameter is MANDATORY, which is used to further describe the LOG_ARCHIVE_DEST_N parameter. The MANDATORY parameter requires the archived logs to reach the LOG_ARCHIVE_DEST_N before writing new archived logs. See Chapter 7 for more information.
Chapter: 103
5. A statement failure and a process failure are what types of failure?
A. Media failure
B. User failure
C. Non-media failure
D. Statement failure
Answer: C
Statement failure and process failure are both types of non-media failure. These types of failure are usually less critical than media failures. See Chapter 5 for more information.
Chapter: 103
6. What method of undoing changes in the database uses an external data dictionary?
A. Flashback Query
B. Parallel query
C. LogMiner
D. Undo query
Answer: C
The LogMiner utility utilizes an external data dictionary that must be built before beginning the operations. See Chapter 5 for more information.
Chapter: 103
7. The Oracle Shared Server environment addresses which one of these problems?
A. Security
B. Extensibility
C. Performance
D. Scalability
Answer: D
The Oracle Shared Server environment addresses the problem of scalability. When memory or the number of processes on a server is taxed, the Shared Server configuration can address these problems. See Chapter 4 for more information.
Chapter: 103
8. Which V$ view can you use to monitor instance recovery performance of parallel rollback?
A. V$FAST_SERVERS
B. V$FAST_START
C. V$FAST_START_SERVERS
D. V$FAST_START_SERVER
Answer: C
The V$FAST_START_SERVERS view can help monitor instance recovery of parallel rollback. This view helps monitor the parallel transaction rollback process. See Chapter 6 for more information.
Chapter: 103
9. Which command unregisters the target database from the recovery catalog?
A. UNREGISTER from within RMAN
B. UNREGISTER from within SQL*Plus
C. Execute DBMS_RCVCAT.UNREGISTERDATABASE procedure
D. REMOVE REGISTER from within RMAN
Answer: C
To unregister a database, you must execute a stored procedure DBMS_RCVCAT.UNREGISTERDATABASE(<db_key>,<db_id>). The DB_KEY and DB_ID can be obtained from DB table when connected to the RMAN schema owner. See Chapter 13 for more information.
Chapter: 103
10. Which statement best describes a recovery performed in NOARCHIVELOG mode?
A. Some data will be lost in most situations.
B. Complete recovery can be performed in most situations.
C. Tablespace recovery can be performed.
D. No data will be lost in most situations.
Answer: A
Recovery in NOARCHIVELOG mode will result in some data being lost because the backup is from some previous timeframe and transactions haven't been stored since that backup. See Chapter 10 for more information.
Chapter: 103
11. Writing modified blocks to the database files and synchronizing the control files and data files best describes which process?
A. Complete recovery
B. Incomplete recovery
C. Checkpointing
D. Flushing dirty buffers
Answer: C
The main purpose of the database checkpoint is to record that the DBWR has written modified buffers to the data files by synchronizing these changes among the physical structures accordingly. See Chapter 6 for more information.
Chapter: 103
12. What action is the parameter LOG_ARCHIVE_MIN_SUCCEED_DEST responsible for?
A. Determining the maximum unsuccessful archived log destinations
B. Determining the minimum successful archived log destinations
C. Determining the minimum unsuccessful archived log destinations
D. Determining the maximum successful archived log destinations
Answer: B
The LOG_ARCHIVE_MIN_SUCCEED_DEST parameter determines the number of successful archive destinations required before the redo logs can be overwritten. See Chapter 7 for more information.
Chapter: 103
13. Study the RMAN script below. Choose the best answer to describe its function.
RMAN> create script db_backup{
2> allocate channel c1 type tape;
3> backup database;
4> }
A. This will create a RMAN script called db_backup.
B. This will create and store a RMAN script called db_backup.
C. This will create and execute a RMAN script called db_backup.
D. This will store a RMAN script called db_backup.
Answer: B
The create script will create and store a script in the recovery catalog for later use. See Chapter 13 for more information.
Chapter: 103
14. If the spfile.ora, init.ora, and config files exist in the appropriate directories, which file will be read first?
A. spfile.ora
B. init.ora
C. config.ora
D. ifile.ora
Answer: A
The spfile.ora file is new to Oracle9i. This is the binary initialization file that is the default when Oracle is started. The init.ora file is searched for only if there isn't a spfile.ora initialization file. See Chapter 6 for more information.
Chapter: 103
15. Which Oracle view will provide information on the request queue?
A. V$REQUEST_QUEUE
B. V$SHARED_QUEUE
C. V$QUEUE
D. V$PROCESS_QUEUE
Answer: C
The V$QUEUE view will display information regarding the shared server request and response queues. The information deals with how long requests are waiting in the queues. See Chapter 4 for more information.
Chapter: 103
16. You attempt to place a tablespace in backup mode, but are unable to do it. Why has this situation occurred?
A. The database does not have automatic archive logging enabled.
B. The database has automatic archive logging enabled.
C. The database is in ARCHIVELOG mode.
D. The database is not in ARCHIVELOG mode.
Answer: D
The database must be in ARCHIVELOG mode so that the tablespaces can be backed up online. See Chapter 7 for more information.
Chapter: 103
17. Which RMAN command is responsible for applying the archived logs to the database?
A. RESTORE DATABASE
B. RECOVER DATABASE
C. RECOVER ARCHIVE
D. RESTORE ARCHIVE
Answer: B
The RECOVER DATABASE command is responsible for applying the necessary archived logs to the database in the RMAN recovery process. See Chapter 10 for more information.
Chapter: 103
18. Which type of export will the export syntax shown below perform?
exp parfile=tst9par.pr file=tst9.dmp
A. Interactive export
B. Export utilizing PARFILE
C. Export utilizing a command file
D. Regular export
Answer: B
The export syntax is an example of the PARFILE command option. This allows you to group export commands together in a file so you don't have to interactively respond to the prompts when running the export. See Chapter 14 for more information.
Chapter: 103
19. You have a small network and would like to avoid configuring network files on the client workstations. One method of naming that would accomplish this would be
A. Localnaming
B. Hostnaming
C. Oracle Internet Directory
D. Internal naming
Answer: B
The hostnaming method allows the DBA to configure connectivity without having to have configuration files on the client machines. There are some caveats to using this method. See Chapter 3 for more information.
Chapter: 103
20. What is the name of the initialization parameter that designates the Flashback Query to store the undo data?
A. UNDO_ROLLBACK
B. ROLLBACK
C. UNDO_MANAGEMENT
D. UNDO_TABLESPACE
Answer: D
UNDO_TABLESPACE is the initialization parameter that designates the undo tablespace to be used for the Flashback Query. See Chapter 5 for more information.
Chapter: 103
21. What type of incomplete recovery is based on a point in time?
A. Cancel-based
B. Time-based
C. Change-based
D. Sequence-based
Answer: B
Time-based recovery requires the DBA to choose a point in time at which to end the recovery process. See Chapter 11 for more information.
Chapter: 103
22. A client is receiving the following error: "ORA-12154: TNS:could not resolve service name." Assuming you are using localnaming names resolution, which of the following is a possible cause of this error?
A. The Oracle listener is not running.
B. The user supplied a valid net service name but an invalid password.
C. An entry of NAMES.DIRECTORY_PATH=(HOSTNAME) in the sqlnet.ora file on the client.
D. An invalid HOST entry for this net service name definition in the tnsnames.ora file.
Answer: C
The NAMES.DIRECTORY_PATH=(HOSTNAME) will force the client to use hostnaming resolution and not localnaming names resolution. Therefore, the tnsnames.ora file will not be searched and will cause this error to occur if you are not using hostnaming. Answers A, B, and D would cause other ORA errors to occur. See Chapter 3 for more information.
Chapter: 103
23. You are in a recovery situation in which you must stop the recovery process before all transactions are applied to the database. You don't know when the best time is or at which transaction to stop the recovery. How would you recover the database?
A. Use cancel-based recovery.
B. Use time-based recovery.
C. Use change-based recovery.
D. Use sequence-based recovery.
Answer: A
Cancel-based recovery requires the DBA to manually cancel the recovery process at the command line. This can be used when you don't know when the best time, log file, or system change number at which to stop the recovery. This can also be used to arbitrarily stop the recovery process at any given point. See Chapter 11 for more information.
Chapter: 103
24. Study the following RMAN command. Choose the best answer to describe it.
catalog datafilecopy '/staging/cold/tst9/data01.dbf';
A. The RMAN command records that data files were copied or backed up from user-managed backup.
B. The RMAN command is invalid.
C. The RMAN command backs up control files that were copied or backed up from a user-managed backup.
D. The RMAN command backs up archived logs that were copied or backed up from user-managed backup.
Answer: A
The command CATALOG DATAFILECOPY records in the recovery catalog that the data files were copied or backed up by OS commands in user-managed backups. See Chapter 12 for more information.
Chapter: 103
25. Which dynamic performance view will show statistics on dispatcher processes, such as average number of bytes processed, the maximum number of inbound and outbound connections, and the average rate of bytes processed per client connection?
A. V$DISPATCHER
B. V$DISPATCHER_RATE
C. V$DISPATCHER_STATS
D. V$CIRCUIT
Answer: B
The V$DISPATCHER_RATE dynamic performance view contains statistics on the performance of the dispatchers in an Oracle Shared Server environment. See Chapter 4 for more information.
Chapter: 103
26. Which of the following commands is used for RMAN-based recovery based on SCN or transactional changes?
A. SET UNTIL CANCEL
B. SET UNTIL CHANGE
C. SET UNTIL SCN
D. SET UNTIL TIME
Answer: C
The RMAN command SET UNTIL SCN is used to perform recoveries based on SCNs or changes in the redo logs. See Chapter 11 for more information.
Chapter: 103
27. You want to see if a client can see a particular IP address on a TCP/IP network. Which command would you use?
A. tnsping 10.24.129.8
B. ping 10.24.129.8
C. ping host 10.24.129.8
D. tnsping host 10.24.129.8
Answer: B
The ping command can be used to determine if a client computer can see another computer on a TCP/IP network. You can supply either the hostname or the IP address of the computer you want to attempt to connect to. See Chapter 3 for more information.
Chapter: 103
28. You have a development database called DEV1 that has full nightly backups from RMAN with a recovery catalog. You have refreshed DEV1 on the dev server from your production database environment server called PRD1. This was accomplished by moving the PRD1 data files and parameter files to new locations and performing an incomplete recovery. What must be done to get the RMAN backup to work?
A. The new incarnation must be registered.
B. The DEV1 database must be unregistered.
C. The DEV1 database must be RESET.
D. The PRD1 database must be RESET.
Answer: C
The RESET command must be used on the incarnation of the database within the recovery catalog if the target database has been opened with ALTER DATABASE OPEN RESETLOGS. The ALTER DATABASE OPEN RESETLOGS command must be performed with all incomplete recoveries. See Chapter 13 for more information.
Chapter: 103
29. Which of the following files would not be found on an Oracle client?
A. tnsnames.ora
B. sqlnet.ora
C. listener.ora
D. All of the above
Answer: C
None of these network files can be found on the Oracle server. The listener.ora file would not be found on Oracle clients. See Chapter 3 for more information.
Chapter: 103
30. All transactions have been applied to a failed database. Which situation does this best describe?
A. Incomplete recovery
B. Complete recovery
C. Cancel-based recovery
D. Time-based recovery
Answer: B
Complete recovery means that all transactions are recovered. No data is lost or will need to be reentered when the database is recovered. See Chapter 10 for more information.
Chapter: 103
31. How could the existing RETENTION POLICY be identified?
A. Within SQL*Plus, you would execute the SHOW ALL command.
B. Within RMAN, you would execute the SHOW ALL command.
C. Within RMAN, you would execute the LIST ALL command.
D. Within SQL*Plus, you would execute the LIST ALL command.
Answer: B
The SHOW ALL command within RMAN will show all the configuration parameters, one of which is the retention policy. See Chapter 12 for more information.
Chapter: 103
32. What is the name of the preferred centralized naming solution provided by Oracle Net with Oracle9i?
A. Oracle Names Server
B. Oracle Internet Directory
C. Oracle Shared Server
D. Oracle Directory Server
Answer: B
Oracle Internet Directory is now the preferred centralized naming solution. This replaces the Oracle Names Server. See Chapter 1 for more information.
Chapter: 103
33. The database you are responsible for suddenly hangs and does not allow transactions to process. The only thing you have done recently is configure your database to operate in ARCHIVELOG mode and you have verified that one of the five redo logs was written to an archived log at the first log file switch. What has most likely happened?
A. Instance failure has occurred.
B. The SYSTEM tablespace is full.
C. The LOG_ARCHIVE_START parameter is not equal to TRUE.
D. The LOG_ARCHIVING parameter is not equal to TRUE.
Answer: C
The LOG_ARCHIVE_START command must be set to TRUE to enable automatic archiving. If it is not set to TRUE and the database is in ARCHIVELOG mode, the database will hang before it can recycle the online redo logs. See Chapter 7 for more information.
Chapter: 103
34. You have just installed an ATL device to improve the performance and capacity of the backup operations. When you execute the same RMAN backup scripts, you receive errors. Where should you begin your troubleshooting?
A. Validate the recovery catalog is still consistent.
B. Validate the media management library (MML) is correct and configured properly.
C. Verify that the RMAN backup scripts are compiled for the MML.
D. Verify that you are using the default MML from Oracle.
Answer: B
The media management library or media management layer (MML) is a third-party vendor library, which is linked in with the Oracle kernel so that the server session generated by RMAN interfaces with the third-party vendor's hardware. This library file should be received from the ATL hardware vendor and be configured according to their specifications. See Chapter 8 for more information.
Chapter: 103
35. If the database is not in ARCHIVELOG mode, which of the following is true?
A. Redo logs will not be generated.
B. Automatic archived logs will be created.
C. The ALTER TABLESPACE <tablespace_name> BEGIN BACKUP command will fail.
D. Only the ALTER TABLESPACE <tablespace_name> END BACKUP command will fail.
Answer: C
The database must be in ARCHIVELOG mode so that the tablespaces can be backed up online. This means that the ALTER TABLESPACE <tablespace_name> BEGIN BACKUP command, as well as the END BACKUP command, will fail. See Chapter 7 for more information.
Chapter: 103
36. What is the default port that the listener will be configured with when using TCP/IP?
A. 1521
B. 1575
C. 1526
D. 4381
Answer: A
Port 1521 is the default port that the listener will listen to for TCP/IP connections. This can be changed if necessary. See Chapter 2 for more information.
Chapter: 103
37. You perform nightly online backups of the database that you manage. You determine by checking the RMAN logs that the database backup did not complete last night. What should you do?
A. Check the status of the data files in the V$BACKUP view.
B. Check the status of the tablespaces in the ALL_BACKUP view.
C. Check the status of the RMAN backup in RC_BACKUP view.
D. Check the status of the database backup in DBA_BACKUP view.
Answer: A
The V$BACKUP view can be used to identify whether a database is actively being backed up or not. See Chapter 9 for more information.
Chapter: 103
38. Which of the following statements is TRUE about the entry below:
local_listener="(ADDRESS_LIST = (Address =
(Protocol = TCP) (Host=weishan) (Port=1522)))
A. You would see this entry in the tnsnames.ora file when configuring the Oracle Shared Server.
B. You would see this entry in the listener.ora file when configuring dynamic service registration.
C. You would see this entry in the init.ora file when configuring dynamic service registration.
D. You would see this entry in the sqlnet.ora file when configuring static service registration.
Answer: C
The entry would be found in the init.ora file when you want to configure a non-default listener to use for dynamic service registration. See Chapter 2 for more information.
Chapter: 103
39. What is the default initialization parameter when an Oracle9i database is started?
A. spfile.ora or spfile$ORACLE_SID.ora
B. init.ora or init$ORACLE_SID.ora
C. config.ora
D. ifile.ora
Answer: A
The spfile.ora is new for 9i. This is the binary initialization file that is the default when Oracle is started. The init.ora is searched for only if there isn't a spfile.ora initialization file. See Chapter 6 for more information.
Chapter: 103
40. If you want to modify the amount of trace information that will be produced by the listener, you would modify what parameter in the listener.ora file?
A. TRACE_LEVEL_LISTENER
B. TRACE_FILE_LISTENER
C. TRACE_DIRECTORY_LISTENER
D. TRACE_STATUS_LISTENER
Answer: A
The TRACE_LEVEL_LISTENER parameter in the listener.ora file determines the level of tracing output the listener will produce. The four possible values of this parameter are OFF, USER, ADMIN, and SUPPORT, with SUPPORT being the highest level of tracing. See Chapter 2 for more information.
Chapter: 103
41. Which of the following are features of the Oracle RMAN utility? (Choose all that apply.)
A. It provides scripting capabilities.
B. It interfaces with third-party tape media software.
C. It provides reports and lists of information.
D. It determines whether backups are still available in media.
E. It requires the use of a recovery catalog.
Answer: A, B, C, D
With the exception of option E, all of these are features of the RMAN utility. The recovery catalog is optional. See Chapter 8 for more information.
Chapter: 103
42. Study the following RMAN command. Choose the best answer to describe it.
RESYNCHRONIZE CATALOG;
A. This command resynchronizes the selected target database within the recovery catalog.
B. This command resynchronizes the recovery catalog database.
C. This is an invalid command.
D. This command resets the selected target database within the recovery catalog.
Answer: C
This is an invalid command. The proper syntax is RESYNCH CATALOG. See Chapter 13 for more information.
Chapter: 103
43. Which of the following are the main server-side components of Oracle Shared Server? (Choose all that apply.)
A. Dispatchers
B. Listeners
C. Shared servers
D. Database writers
Answer: A, C
The Oracle Shared Server configuration utilizes dispatchers to manage client connections and shared servers to process client requests. See Chapter 4 for more information.
Chapter: 103
44. Which statement best describes the purpose of the CROSSCHECK command?
A. It compares the recovery catalog with the tape media library for backups and the media they are stored on.
B. It compares the RMAN repository information in the control file with the tape media library for the existence of backups and the media they are stored on.
C. It checks the catalog for the existence of backups.
D. It checks the repository for the existence of backups.
Answer: A
The CROSSCHECK command performs comparison activities on the disk/tape media and the recovery catalog contents. See Chapter 12 for more information.
Chapter: 103
45. You are a DBA interested in using the Oracle Shared Server. Which one of these steps would NOT be performed to configure and initiate the Oracle Shared Server?
A. Configure the SHARED_SERVERS parameter in the init.ora file.
B. Stop and restart the Oracle Instance to enable use of the Oracle Shared Server.
C. Configure the DISPATCHERS parameter in the init.ora file.
D. Mount the database and issue the ALTER SYSTEM ENABLE SHARED SERVER command.
Answer: D
There is no need to issue any type of command to initiate the use of the Oracle Shared Server. The init.ora parameters should be set up and the instance can be stopped and restarted to have the changes take effect. See Chapter 4 for more information.
Chapter: 103
46. Which command initiates direct-path export?
A. DIRECT=Y
B. DIRECT=TRUE
C. DIRECT_PATH=Y
D. DIRECT_PATH=TRUE
Answer: A
The DIRECT=Y command will switch the export method from conventional path to direct path. See Chapter 14 for more information.
Chapter: 103
47. You have made a change to the listener.ora file and want to have the change take effect immediately. What is the best way to accomplish this with minimal interruption?
A. Stop and start the listener.
B. Stop and start the Oracle server.
C. Use the lsnrctl refresh command.
D. Use the lsnrctl reload command.
Answer: D
The lsnrctl reload command will reread information in the listener.ora file without bringing down the listener. This would cause the least amount of disruption to clients that are attempting to connect to the Oracle server. See Chapter 2 for more information.
Chapter: 103
48. What is the maximum retention period of the Flashback Query?
A. One day
B. Two days
C. Three days
D. Five days
Answer: D
Flashback query can only query data that is five days old or less regardless of the retention policy. See Chapter 5 for more information.
Chapter: 103
49. Study the following RMAN command. Choose the best answer to describe it.
change datafile '/staging/cold/tst9/data01.dbf' available;
A. Changes the status of a data file to available
B. Changes the status of a control file to available
C. This is an invalid RMAN command.
D. Changes the status of a data file to unavailable
Answer: C
This is an invalid RMAN command. The DATAFILE keyword should be DATAFILECOPY. See Chapter 12 for more information.
Chapter: 103
50. What line in this direct-load insert statement will cause the statement to fail?
ALTER SESSION DISABLE PARALLEL DML;
INSERT /*+PARALLEL (TEST.T1_NEW, 4) / INTO T1_NEW
NOLOGGING
SELECT * FORM T1
COMMIT;
A. The first line
B. The second line
C. The third line
D. The fourth line
E. The fifth line
Answer: A
In order to run direct-load insert, the performing session will need to have parallel DML enabled as opposed to disabled. The correct syntax is ALTER SESSION ENABLE PARALLEL DML;. See Chapter 15 for more information.
Chapter: 103
51. What file must be present on an Oracle client to start the listener process?
A. listener.ora
B. tnsnames.ora
C. sqlnet.ora
D. None of the above
Answer: D
Read the question carefully. There is no file that is required on the client to start the Oracle listener. The listener is a server-side process. See Chapter 2 for more information.
Chapter: 103
52. You have just experienced a media failure on one of the disks that contains one of the databases, four control files, and the temporary tablespace's data file. What are valid options to recover the database? (Choose all that apply.)
A. Restore and recover the control file and tablespace from the backup.
B. Restore and recover the data file from the backup and do nothing with the control file or init.ora reference.
C. Restore and recover the control file from the backup and do nothing with the temporary tablespace data file.
D. Remove the existing temporary tablespace reference from the data dictionary and create a new temporary tablespace. Remove the reference to the impacted control file from the init.ora file.
Answer: A, D
You could restore both the temporary tablespace's data file and the control file from the backup and recover to bring the files current with the rest of the database. Or, you could rebuild the temporary tablespace because it doesn't contain permanent objects-only temporary objects. This could be done by offline dropping the temporary tablespace and the creation of a new one. Since there are four control files, the impacted one is not necessary and could be removed from init.ora parameters, thus leaving three control files-which is adequate redundancy for the database. See Chapter 5 for more information.
Chapter: 103
53. An Oracle dedicated server process could most closely be compared to which one of the following?
A. A waiter who waits on only one person
B. A waiter who waits on many people
C. A cook who prepares meals for every person
D. A waiter who shows an individual to their seat and then helps other patrons to their seats
Answer: A
A dedicated server process is most like a waiter who waits on only one person. The waiter is responsible for serving only the needs of this person until that person leaves. See Chapter 4 for more information.
Chapter: 103
54. Which aspect of the recovery plan is the most often overlooked?
A. Backup process
B. Recovery process
C. The testing of the backup and recovery process
D. Restore process
Answer: C
Testing the backup and recovery process is usually the most overlooked aspect of the plan. At a minimum, certain tests should be performed on a regular basis. See Chapter 5 for more information.
Chapter: 103
55. Which of the following needs to be true of a database before a closed backup can be performed?
A. The database needs to be in NOARCHIVELOG mode.
B. The database needs to be in ARCHIVELOG mode.
C. A hot backup must also be able to be performed.
D. The database must have been shut down.
Answer: D
A closed backup is also called a cold backup, and it can only be performed when the database is shut down. The database can be in either ARCHIVELOG or NOARCHIVELOG mode. Remember to shut the database down cleanly. Do not use SHUTDOWN ABORT because it does not checkpoint the data files and control files. See Chapter 9 for more information.
Chapter: 103
56. Which of the following can you use to monitor instance recovery time estimates?
A. V$INSTANCE_RECOVER
B. V$INSTANCE_RECOVERY
C. V$INSTANCE_RECOVERIES
D. V$INST_RECOVERY
Answer: B
The V$INSTANCE_RECOVERY view can help monitor the estimated time of instance recovery. See Chapter 6 for more information.
Chapter: 103
