1. You are the production and development DBA for a financial database and application. You have multiple development and testing environments to support your production database environment. One of the development environments is no longer necessary. How can you remove the incarnation of the database from recovery catalog?
A. Perform a RESET on the development database incarnation.
B. Perform a RESYNCH on the development database incarnation.
C. Run the execute dbms_rcvcat.unregisterdatabase procedure for development database incarnation.
D. Deleting the database from the filesystem is all that is necessary.
Answer: C
The stored procedure execute dbms_rcvcat.unregisterdatabase will unregister a target database in the recovery catalog. This should be run as the recovery catalog owner for any database that you want to remove from the recovery catalog. See Chapter 13 for more information.
Chapter: 102
2. A client attempting to connect to an Oracle server received the following error:
ORA-12198 "TNS: could not find path to destination"
Which of the following explains why this error was received?
A. The user entered an invalid user ID.
B. The user entered an invalid net service name.
C. The client found an entry for the service in the tnsnames.ora file but the service specified was not found.
D. The Oracle listener process was not started.
Answer: C
This error could be caused by a situation in which the service name in the tnsnames.ora file was invalid. See Chapter 3 for more information.
Chapter: 102
3. Study the RMAN script below. Choose the best answer to describe its function.
RMAN> create script complete_bac{
2> allocate channel c1 type disk;
3> allocate channel c2 type disk;
4> backup database;
5> backup archivelog all;
6> }
A. This will create a RMAN script called complete_bac.
B. This will create and store a RMAN script called complete_bac.
C. This will create and execute a RMAN script called complete_bac.
D. This will store a RMAN script called complete_bac.
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: 102
4. What type of failure scenarios is automatically performed by Oracle?
A. User process
B. Media failure
C. Instance failure
D. Statement failure
Answer: C
Instance failure is automatically recovered by Oracle when the database instance is halted abruptly, such as it is during a power outage. Oracle handles this when the database gets started by reading the current online redo log and reapplying all the transactions in the redo log. This is sometimes known as the roll forward and rollback process because all the transactions are applied committed or uncommitted. Only the committed changes remain and the database is consistent from before the instance failure. See Chapter 5 for more information.
Chapter: 102
5. The Virtual Interface (VI) protocol support provided by Oracle Net is used specifically for which of the following?
A. Wide area networks
B. Local area networks
C. System areas networks
D. None of the above
Answer: C
The VI protocol is designed to support system area networks (SANs). SANs are configurations of multiple servers with high-speed interconnects between them. See Chapter 1 for more information.
Chapter: 102
6. What type of user-managed incomplete recovery might require the following query?
select sequence#,first_change#,next_change#,first_time
from v$log_history;
A. Time-based
B. Change-based
C. Cancel-based
D. Stop-based
Answer: B
Change-based recovery is based upon a unique SCN number that each transaction uniquely contains. This could require you to determine which SCN ranges are in a redo log file. See Chapter 11 for more information.
Chapter: 102
7. When you first use a target database with RMAN, which command do you need to execute first to store information about the target database?
A. REGISTER
B. UNREGISTER
C. RESET
D. UNSET
Answer: A
The REGISTER command stores information about the target database. This command is run the first time a target database will be used within RMAN. See Chapter 13 for more information.
Chapter: 102
8. Which of the following memory structures temporarily stores the committed and uncommitted transactions before they are all written to disk?
A. Data block buffers
B. Redo log buffer
C. Shared Pool
D. Large Pool
Answer: B
The committed or uncommitted transactions, which consist of all transactions, are stored in the redo log buffers before they are written to the redo logs. See Chapter 6 for more information.
Chapter: 102
9. You have stopped the listener process on the Oracle Server. Which one of the following statements would be TRUE because the listener is no longer running?
A. Connections established prior to the listener being stopped will be disconnected.
B. Only bequeath connections will no longer be possible, but Shared Server connections will be possible.
C. You will not be able to stop or start the Oracle server until the listener is restarted.
D. If a client issued the following statement "sqlplus system/manager@prod," the command may fail with a "ORA-12541: TNS:no listener" error.
Answer: D
The command issued from the client would need to contact the listener in order to establish a connection to the Oracle Server. The client would contact the server and discover that the listener is not active. See Chapter 2 for more information.
Chapter: 102
10. Which of the following processes can be performed when the database is in NOARCHIVELOG mode?
A. Only incomplete recovery
B. Only complete recovery
C. Only partial recovery
D. Complete recovery and incomplete recovery
Answer: A
When the database is in NOARCHIVELOG mode, only incomplete recovery can be performed. However, there is one exception to this rule-if the online redo logs have not been written over since the last backup. See Chapter 7 for more information.
Chapter: 102
11. What action does the PL/SQL procedure sys.dbms_logmnr_d.build perform?
A. Builds an external data dictionary
B. Builds a data extraction library
C. Builds database procedures for LogMiner
D. Builds database libraries for LogMiner
Answer: A
The sys.dbms_logmnr_d.build procedure builds the external data dictionary for LogMiner. See Chapter 5 for more information.
Chapter: 102
12. You must perform a complete database restore and then recover appropriately for the circumstances. The only thing you know about the recovery is that there is a bad transaction, which corrupted the database. What type of recovery should you perform?
A. Time-based at the time just after the corrupt transaction
B. Change-based just prior to a certain SCN that contained the corrupt transaction
C. Cancel-based at a determined point in time
D. Complete recovery because not enough information is known
Answer: B
Change-based recovery is based upon a unique SCN number that each transaction contains. If you know there is a bad transaction that corrupted the database, you could identify the approximate SCN numbers and recover prior to the SCN of the bad transaction. See Chapter 11 for more information.
Chapter: 102
13. You are a DBA that has clients connecting from a Windows NT environment. You are using the localnaming method for names resolution. You want to place the Oracle Net client files in a non-default location. Which of the following would you do?
A. Update the TNS_ADMIN entry in the Windows NT Registry to point to the new location of the Oracle Net files.
B. Update the TNS_ADMIN entry in the tnsnames.ora file to point to the new location of the Oracle Net files.
C. Update the NAMES.DIRECTORY_PATH in the sqlnet.ora file to point to the location of the Oracle Net files.
D. Because you are using the localnaming method, there would be no Oracle Net files necessary on the client
Answer: A
The TNS_ADMIN entry would have to be updated in the Windows NT Registry to point to the location of the files. Oracle will check for the existence of this entry when it is searching for the client-side Oracle Net files. See Chapter 3 for more information.
Chapter: 102
14. Which of the following actions modifies the RMAN repository so that it can store more information?
A. Increasing the value of the CONTROL_FILE_RECORD_KEEP_TIME parameter
B. Increasing the size of the default tablespace of RMAN schema owner
C. Increasing the size of the recovery catalog
D. The RMAN repository cannot be increased.
Answer: A
The RMAN repository is the control file of the target database when the recovery catalog is not being used. The size of the control file can be increased by increasing the value of the CONTROL_FILE_RECORD_KEEP_TIME parameter. This value can be anywhere from 1 to 365. See Chapter 8 for more information.
Chapter: 102
15. What type of connection is possible when the underlying operating system supports inheritance of endpoints?
A. Shared server
B. Bequeath connection
C. Redirect connection
D. Dedicated server
E. None of the above
Answer: B
Bequeath connections are possible when the underlying operating system supports inheritance of endpoints. Otherwise, the system must perform a redirect. This requires additional communication between the client and listener. See Chapter 2 for more information.
Chapter: 102
16. When you are performing a backup, which of the following should be included?
A. A copy of the data files only
B. A copy of the data files and archived logs
C. A copy of the data files, the archived logs, and the control files
D. A copy of the data files, the archived logs, the control files, and the parameter files
Answer: D
When you copy the data files, archived logs, control files, and parameter files, you are performing a whole or complete database backup. This is always a good idea if possible because it allows the whole database to be restored if necessary. See Chapter 9 for more information.
Chapter: 102
17. How many more log archive destinations does the LOG_ARCHIVE_DEST_n parameter support in Oracle9i than were previously supported in Oracle8i?
A. 1
B. 3
C. 5
D. 10
Answer: C
LOG_ARCHIVE_DEST_n (n being an integer value) is responsible for 10 archive locations in Oracle9i. In Oracle8i, only a maximum of 5 locations was supported. See Chapter 7 for more information.
Chapter: 102
18. Which of the following commands move data files in the RMAN recovery process? (Choose all that apply.)
A. SET NEWFILE
B. SET RENAME
C. SET NEWNAME
D. SWITCH
Answer: C, D
The SET NEWNAME and SWITCH commands work together to restore RMAN backups to new locations. The SET NEWFILE and SET NEWNAME are not valid command syntax. See Chapter 10 for more information.
Chapter: 102
19. Oracle Connection Manager provides all of the following except:
A. Centralized naming
B. Multiplexing
C. Network access control
D. Cross-protocol connectivity
Answer: A
Connection Manager provides multiplexing, network access control, and cross-protocol connectivity. It does not provide a centralized naming solution. Centralized naming is provided by Oracle Internet Directory, or in previous version of Oracle, Oracle Names Server. See Chapter 1 for more information.
Chapter: 102
20. You are the DBA of a production database that does not run in ARCHIVELOG mode. The database cycles through all of the redo logs about two times a day. The backups for the database occur every Sunday. You experience a media failure on Wednesday. What is the best recovery you can perform?
A. Complete recovery, if all of the redo logs are available.
B. Incomplete recovery, losing all transactions that occurred after the backup.
C. Complete recovery, losing all transactions that occurred after the backup.
D. Incomplete recovery, only losing the redo logs after the time-based recovery.
Answer: C
You can completely recover everything from the last full backup, but cannot apply transaction logs. Incomplete recovery in the Oracle world means UNTIL CANCEL, UNTIL TIME, or SCN. See Chapter 10 for more information.
Chapter: 102
21. Which statement best describes the recovery catalog?
A. A mandatory feature of RMAN
B. An optional feature of RMAN that stores metadata about the backups
C. A mandatory feature of RMAN that stores metadata about the backups
D. An optional feature of RMAN
Answer: B
The recovery catalog is an optional feature of RMAN. Though Oracle recommends that you use it, it isn't required. One major benefit of the recovery catalog is that it stores metadata about backups in a database that can be reported or queried. See Chapter 8 for more information.
Chapter: 102
22. What SQL*Loader command does not overwrite existing data?
A. REPLACE
B. APPEND
C. REUSE
D. NEW
Answer: B
The APPEND command does not delete or overwrite existing table data. See Chapter 15 for more information.
Chapter: 102
23. Which of the following is another name for a bequeath connection?
A. Indirect connection
B. Redirect connection
C. Direct hand-off connection
D. Shared connection
Answer: C
Bequeath connections are also called direct hand-off connections because they pass control directly to a shared server or to a dedicated server process. See Chapter 2 for more information.
Chapter: 102
24. Which RMAN command would you use to make a backup set available?
A. CHANGE
B. MAKE
C. FORCE
D. EXPIRE
Answer: A
The CHANGE command makes the backup set either available or unavailable in the recovery catalog. The other commands are invalid. See Chapter 12 for more information.
Chapter: 102
25. Which RMAN command will show the availability status of a DATAFILECOPY command?
A. LIST COPY OF DATABASE
B. LIST COPY OF DATAFILE
C. DATAFILE COPY
D. CATALOG DATAFILE
Answer: A
The LIST COPY OF DATABASE will show the status of data file copies for a particular database. See Chapter 15 for more information.
Chapter: 102
A. Perform a RESET on the development database incarnation.
B. Perform a RESYNCH on the development database incarnation.
C. Run the execute dbms_rcvcat.unregisterdatabase procedure for development database incarnation.
D. Deleting the database from the filesystem is all that is necessary.
Answer: C
The stored procedure execute dbms_rcvcat.unregisterdatabase will unregister a target database in the recovery catalog. This should be run as the recovery catalog owner for any database that you want to remove from the recovery catalog. See Chapter 13 for more information.
Chapter: 102
2. A client attempting to connect to an Oracle server received the following error:
ORA-12198 "TNS: could not find path to destination"
Which of the following explains why this error was received?
A. The user entered an invalid user ID.
B. The user entered an invalid net service name.
C. The client found an entry for the service in the tnsnames.ora file but the service specified was not found.
D. The Oracle listener process was not started.
Answer: C
This error could be caused by a situation in which the service name in the tnsnames.ora file was invalid. See Chapter 3 for more information.
Chapter: 102
3. Study the RMAN script below. Choose the best answer to describe its function.
RMAN> create script complete_bac{
2> allocate channel c1 type disk;
3> allocate channel c2 type disk;
4> backup database;
5> backup archivelog all;
6> }
A. This will create a RMAN script called complete_bac.
B. This will create and store a RMAN script called complete_bac.
C. This will create and execute a RMAN script called complete_bac.
D. This will store a RMAN script called complete_bac.
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: 102
4. What type of failure scenarios is automatically performed by Oracle?
A. User process
B. Media failure
C. Instance failure
D. Statement failure
Answer: C
Instance failure is automatically recovered by Oracle when the database instance is halted abruptly, such as it is during a power outage. Oracle handles this when the database gets started by reading the current online redo log and reapplying all the transactions in the redo log. This is sometimes known as the roll forward and rollback process because all the transactions are applied committed or uncommitted. Only the committed changes remain and the database is consistent from before the instance failure. See Chapter 5 for more information.
Chapter: 102
5. The Virtual Interface (VI) protocol support provided by Oracle Net is used specifically for which of the following?
A. Wide area networks
B. Local area networks
C. System areas networks
D. None of the above
Answer: C
The VI protocol is designed to support system area networks (SANs). SANs are configurations of multiple servers with high-speed interconnects between them. See Chapter 1 for more information.
Chapter: 102
6. What type of user-managed incomplete recovery might require the following query?
select sequence#,first_change#,next_change#,first_time
from v$log_history;
A. Time-based
B. Change-based
C. Cancel-based
D. Stop-based
Answer: B
Change-based recovery is based upon a unique SCN number that each transaction uniquely contains. This could require you to determine which SCN ranges are in a redo log file. See Chapter 11 for more information.
Chapter: 102
7. When you first use a target database with RMAN, which command do you need to execute first to store information about the target database?
A. REGISTER
B. UNREGISTER
C. RESET
D. UNSET
Answer: A
The REGISTER command stores information about the target database. This command is run the first time a target database will be used within RMAN. See Chapter 13 for more information.
Chapter: 102
8. Which of the following memory structures temporarily stores the committed and uncommitted transactions before they are all written to disk?
A. Data block buffers
B. Redo log buffer
C. Shared Pool
D. Large Pool
Answer: B
The committed or uncommitted transactions, which consist of all transactions, are stored in the redo log buffers before they are written to the redo logs. See Chapter 6 for more information.
Chapter: 102
9. You have stopped the listener process on the Oracle Server. Which one of the following statements would be TRUE because the listener is no longer running?
A. Connections established prior to the listener being stopped will be disconnected.
B. Only bequeath connections will no longer be possible, but Shared Server connections will be possible.
C. You will not be able to stop or start the Oracle server until the listener is restarted.
D. If a client issued the following statement "sqlplus system/manager@prod," the command may fail with a "ORA-12541: TNS:no listener" error.
Answer: D
The command issued from the client would need to contact the listener in order to establish a connection to the Oracle Server. The client would contact the server and discover that the listener is not active. See Chapter 2 for more information.
Chapter: 102
10. Which of the following processes can be performed when the database is in NOARCHIVELOG mode?
A. Only incomplete recovery
B. Only complete recovery
C. Only partial recovery
D. Complete recovery and incomplete recovery
Answer: A
When the database is in NOARCHIVELOG mode, only incomplete recovery can be performed. However, there is one exception to this rule-if the online redo logs have not been written over since the last backup. See Chapter 7 for more information.
Chapter: 102
11. What action does the PL/SQL procedure sys.dbms_logmnr_d.build perform?
A. Builds an external data dictionary
B. Builds a data extraction library
C. Builds database procedures for LogMiner
D. Builds database libraries for LogMiner
Answer: A
The sys.dbms_logmnr_d.build procedure builds the external data dictionary for LogMiner. See Chapter 5 for more information.
Chapter: 102
12. You must perform a complete database restore and then recover appropriately for the circumstances. The only thing you know about the recovery is that there is a bad transaction, which corrupted the database. What type of recovery should you perform?
A. Time-based at the time just after the corrupt transaction
B. Change-based just prior to a certain SCN that contained the corrupt transaction
C. Cancel-based at a determined point in time
D. Complete recovery because not enough information is known
Answer: B
Change-based recovery is based upon a unique SCN number that each transaction contains. If you know there is a bad transaction that corrupted the database, you could identify the approximate SCN numbers and recover prior to the SCN of the bad transaction. See Chapter 11 for more information.
Chapter: 102
13. You are a DBA that has clients connecting from a Windows NT environment. You are using the localnaming method for names resolution. You want to place the Oracle Net client files in a non-default location. Which of the following would you do?
A. Update the TNS_ADMIN entry in the Windows NT Registry to point to the new location of the Oracle Net files.
B. Update the TNS_ADMIN entry in the tnsnames.ora file to point to the new location of the Oracle Net files.
C. Update the NAMES.DIRECTORY_PATH in the sqlnet.ora file to point to the location of the Oracle Net files.
D. Because you are using the localnaming method, there would be no Oracle Net files necessary on the client
Answer: A
The TNS_ADMIN entry would have to be updated in the Windows NT Registry to point to the location of the files. Oracle will check for the existence of this entry when it is searching for the client-side Oracle Net files. See Chapter 3 for more information.
Chapter: 102
14. Which of the following actions modifies the RMAN repository so that it can store more information?
A. Increasing the value of the CONTROL_FILE_RECORD_KEEP_TIME parameter
B. Increasing the size of the default tablespace of RMAN schema owner
C. Increasing the size of the recovery catalog
D. The RMAN repository cannot be increased.
Answer: A
The RMAN repository is the control file of the target database when the recovery catalog is not being used. The size of the control file can be increased by increasing the value of the CONTROL_FILE_RECORD_KEEP_TIME parameter. This value can be anywhere from 1 to 365. See Chapter 8 for more information.
Chapter: 102
15. What type of connection is possible when the underlying operating system supports inheritance of endpoints?
A. Shared server
B. Bequeath connection
C. Redirect connection
D. Dedicated server
E. None of the above
Answer: B
Bequeath connections are possible when the underlying operating system supports inheritance of endpoints. Otherwise, the system must perform a redirect. This requires additional communication between the client and listener. See Chapter 2 for more information.
Chapter: 102
16. When you are performing a backup, which of the following should be included?
A. A copy of the data files only
B. A copy of the data files and archived logs
C. A copy of the data files, the archived logs, and the control files
D. A copy of the data files, the archived logs, the control files, and the parameter files
Answer: D
When you copy the data files, archived logs, control files, and parameter files, you are performing a whole or complete database backup. This is always a good idea if possible because it allows the whole database to be restored if necessary. See Chapter 9 for more information.
Chapter: 102
17. How many more log archive destinations does the LOG_ARCHIVE_DEST_n parameter support in Oracle9i than were previously supported in Oracle8i?
A. 1
B. 3
C. 5
D. 10
Answer: C
LOG_ARCHIVE_DEST_n (n being an integer value) is responsible for 10 archive locations in Oracle9i. In Oracle8i, only a maximum of 5 locations was supported. See Chapter 7 for more information.
Chapter: 102
18. Which of the following commands move data files in the RMAN recovery process? (Choose all that apply.)
A. SET NEWFILE
B. SET RENAME
C. SET NEWNAME
D. SWITCH
Answer: C, D
The SET NEWNAME and SWITCH commands work together to restore RMAN backups to new locations. The SET NEWFILE and SET NEWNAME are not valid command syntax. See Chapter 10 for more information.
Chapter: 102
19. Oracle Connection Manager provides all of the following except:
A. Centralized naming
B. Multiplexing
C. Network access control
D. Cross-protocol connectivity
Answer: A
Connection Manager provides multiplexing, network access control, and cross-protocol connectivity. It does not provide a centralized naming solution. Centralized naming is provided by Oracle Internet Directory, or in previous version of Oracle, Oracle Names Server. See Chapter 1 for more information.
Chapter: 102
20. You are the DBA of a production database that does not run in ARCHIVELOG mode. The database cycles through all of the redo logs about two times a day. The backups for the database occur every Sunday. You experience a media failure on Wednesday. What is the best recovery you can perform?
A. Complete recovery, if all of the redo logs are available.
B. Incomplete recovery, losing all transactions that occurred after the backup.
C. Complete recovery, losing all transactions that occurred after the backup.
D. Incomplete recovery, only losing the redo logs after the time-based recovery.
Answer: C
You can completely recover everything from the last full backup, but cannot apply transaction logs. Incomplete recovery in the Oracle world means UNTIL CANCEL, UNTIL TIME, or SCN. See Chapter 10 for more information.
Chapter: 102
21. Which statement best describes the recovery catalog?
A. A mandatory feature of RMAN
B. An optional feature of RMAN that stores metadata about the backups
C. A mandatory feature of RMAN that stores metadata about the backups
D. An optional feature of RMAN
Answer: B
The recovery catalog is an optional feature of RMAN. Though Oracle recommends that you use it, it isn't required. One major benefit of the recovery catalog is that it stores metadata about backups in a database that can be reported or queried. See Chapter 8 for more information.
Chapter: 102
22. What SQL*Loader command does not overwrite existing data?
A. REPLACE
B. APPEND
C. REUSE
D. NEW
Answer: B
The APPEND command does not delete or overwrite existing table data. See Chapter 15 for more information.
Chapter: 102
23. Which of the following is another name for a bequeath connection?
A. Indirect connection
B. Redirect connection
C. Direct hand-off connection
D. Shared connection
Answer: C
Bequeath connections are also called direct hand-off connections because they pass control directly to a shared server or to a dedicated server process. See Chapter 2 for more information.
Chapter: 102
24. Which RMAN command would you use to make a backup set available?
A. CHANGE
B. MAKE
C. FORCE
D. EXPIRE
Answer: A
The CHANGE command makes the backup set either available or unavailable in the recovery catalog. The other commands are invalid. See Chapter 12 for more information.
Chapter: 102
25. Which RMAN command will show the availability status of a DATAFILECOPY command?
A. LIST COPY OF DATABASE
B. LIST COPY OF DATAFILE
C. DATAFILE COPY
D. CATALOG DATAFILE
Answer: A
The LIST COPY OF DATABASE will show the status of data file copies for a particular database. See Chapter 15 for more information.
Chapter: 102
