26. User-managed backup and recovery best defines which of the following statements?
A. Custom backup and recovery performed with OS commands and database commands
B. Non-automated RMAN-based backups
C. A new type of backup that uses RMAN but is performed by a user
D. Automated RMAN-based backup
Answer: A
User-managed backup is the term used to describe the standard backups that have been used from the inception of Oracle. These backups are usually custom written through the use of OS and database commands. See Chapter 9 for more information.
Chapter: 102
27. You receive an unusual request to restore a copy of the production financial database from the last year to compare financial numbers in some tables currently not available in the existing production database. How can you check if you still have the backup media from that timeframe?
A. Perform a REPORT SCHEMA to check if the database and backup media are available.
B. Perform a LIST BACKUP to check if the database and backup media are available.
C. Perform a CROSSCHECK of the recovery catalog and backup media.
D. Perform a CHANGE of the recovery catalog and the backup media.
Answer: C
The CROSSCHECK command will compare the recovery catalog contents and associated media. If your tape rotation cycle is 30 days, you would have supporting backup media for only 30 days, even if your recovery catalog had data for over a year. See Chapter 12 for more information.
Chapter: 102
28. You have to perform a large DBA maintenance activity involving the partial loading of a temporary table from a very large table containing invoicing information for more than a year. What would be the quickest way to create the temporary table to perform this activity?
A. Conventional load export and import.
B. Create a table using direct-load insert.
C. Conventional path SQL*Loader.
D. Create Table as Select with logging turned on.
Answer: B
Direct-load insert is best used for batch loads of data or maintenance activities, such as rebuilding or unloading tables. This would be quicker to do than all of the other options. The conventional-load export would require you to build an export dump file and then import back into the database while in conventional mode. The SQL*Loader option would require setup to build the input, or data, file and control file, and then reload. The Create Table as Select (CTAS) option would require little setup, but because logging is turned on, the process would slow down. See Chapter 15 for more information.
Chapter: 102
29. All of the following would be network design considerations except:
A. Network complexity
B. Network security
C. Interfacing with new and existing systems
D. Backup and recovery issues for the Oracle server
Answer: D
Backup and recovery would not be considered a network design consideration. This is more of an Oracle server administration issue. See Chapter 1 for more information.
Chapter: 102
30. There was a complete disaster that forced you to rebuild a database environment from yesterday's backup. The most current 20 offline redo logs were lost when the complete disaster occurred. What components would you need to completely rebuild a database to a point as close as possible before the disaster?
A. All data files, all control files, parameter files, and only online redo logs
B. All data files, one control file, parameter files, and all redo logs
C. All data files, one control file, parameter files, and some of the available offline redo logs
D. All data files, parameter files, and all online redo logs
Answer: B
The type of recovery that would restore and recover a database to some point before a failure is best described as an incomplete recovery. Also, the most current 20 offline redo logs (archived logs) are unavailable. This means that you cannot perform a complete recovery. The components required to perform a complete recovery are all the necessary data files, at least one current control file, parameter files, and all of the available offline redo logs (archived logs). The online redo logs will not allow you to roll forward from the backup. Of the archived logs available, you will only be able to roll forward as far as you have archived logs. You will also need at least a control file or a backup control to recover the database. See Chapter 10 for more information.
Chapter: 102
31. Which of the following views can be used to identify cleanup issues after a failed hot or online backup?
A. V$BACKUP
B. ALL_BACKUP
C. USER_BACKUP
D. DBA_BACKUP
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: 102
32. Which Oracle background process has the responsibility of writing committed or uncommitted transactions to redo logs?
A. PMON
B. SMON
C. LGWR
D. DBWR
Answer: C
The LGWR process is responsible for applying all of the committed or uncommitted changes to the online redo logs. See Chapter 6 for more information.
Chapter: 102
33. Which Oracle background process registers information with the listener when you are using Oracle Shared Server?
A. SMON
B. LGWR
C. DBWR
D. PMON
Answer: D
The Process Monitor (PMON) registers information with an Oracle listener. This information is used by the listener when it assigns client connections to dispatchers. See Chapter 4 for more information.
Chapter: 102
34. There is media failure that requires you to get the most recent full and incremental backups of the necessary files. What must you do?
A. Perform an incremental RESTORE.
B. Use data files to perform a full RESTORE.
C. Perform a RESTORE.
D. Use redo logs to perform a complete RECOVER.
Answer: C
The RESTORE command will get the necessary files from full and incremental backups to bring the database to the most complete point. This is handled automatically by the RESTORE command. See Chapter 10 for more information.
Chapter: 102
35. In which of the following files would you find the NAMES.DIRECTORY_PATH parameter?
A. tnsnames.ora
B. listener.ora
C. sqlnet.ora
D. protocol.ora
Answer: C
The NAMES.DIRECTORY_PATH would be located in the sqlnet.ora file. See Chapter 3 for more information.
Chapter: 102
36. Which piece of Oracle software allows you to run RMAN on a client?
A. Remote recovery catalog
B. Media Management Library
C. RMAN in GUI through Enterprise Manager
D. RMAN in command-line mode
Answer: C
The RMAN utility can be run remotely in the Oracle Enterprise Manager tool. See Chapter 8 for more information.
Chapter: 102
37. You wish to set the number of TCP/IP dispatcher processes to 5. Which command would accomplish this?
A. ALTER SYSTEM SET dispatchers="(PRO=TCP)(DIS=5)"
B. ALTER DATABASE SET dispatchers="(PRO=TCP)(DIS=5)"
C. ALTER SESSION SET dispatchers="(PRO=TCP)(DIS=5)"
D. EXECUTE DBMS_SHARED_SERVER.DISPATCHERS( PRO=TCP,DIS=5)
Answer: A
You can use the ALTER SYSTEM command to modify the DISPATCHERS initialization parameter. This change would take affect immediately and last until the next time the Oracle server was restarted. See Chapter 4 for more information.
Chapter: 102
38. How can you monitor instance recovery performance that had parallel DML activity prior to failure?
A. V$FAST_TRANSACTIONS
B. V$FAST_START_TRANSACTIONS
C. V$FAST_START_TRANS
D. V$FAST_START_TRANSACTION
Answer: B
The V$FAST_START_TRANSACTIONS view can help monitor instance recovery of parallel DML activity that occurred before the instance failure. This view monitors parallel transaction rollback process. See Chapter 6 for more information.
Chapter: 102
39. Study the following commands. Choose the best answer to describe what will be the result of their use.
RMAN> allocate channel c1 type disk;
RMAN> crosscheck backup of database;
A. Will perform a crosscheck of the selected target database
B. Will perform a crosscheck of the recovery catalog
C. Will fail because of invalid syntax
D. Will perform a crosscheck of the RMAN repository
Answer: C
The commands will fail because ALLOCATE CHANNEL FOR MAINTENANCE TYPE DISK is not used. This option must be used with the CROSSCHECK command. See Chapter 12 for more information.
Chapter: 102
40. What is the default name of the Oracle listener?
A. lsnrctl
B. LISTENER
C. LISTEN
D. LISTENER_DEFAULT
Answer: B
The default name given to the Oracle listener is LISTENER. You can override this or create multiple listeners with different names. See Chapter 2 for more information.
Chapter: 102
41. Study the RMAN command below. Choose the best answer to describe it.
rman target / catalog rman/rman@rcat
A. This command connects to the target database.
B. This command connects to the recovery catalog only.
C. This command connects to the RMAN repository.
D. This command connects to both the recovery catalog and the target database.
Answer: D
This command sequence will cause a connection to the target database and recovery catalog, which is also known as the RMAN repository. The target database would need to be defined prior to running this command. When connecting to the target database, the control files of the target database will also be accessed. See Chapter 13 for more information.
Chapter: 102
42. Which status determines that the tape is available in the CROSSCHECK comparison?
A. AVAILABLE
B. READY
C. VERIFIED
D. VALID
Answer: A
The backup sets, which are on the media disk/tape but are in the recovery catalog, return a status of AVAILABLE. See Chapter 12 for more information.
Chapter: 102
43. "Responsible for handling client-to-server and server-to-server communication" best describes which of the following?
A. Connection Manager
B. Oracle Shared Server
C. Oracle Internet Directory
D. Oracle Net
Answer: D
Oracle Net provides the "glue" in an Oracle network. It is responsible for all client-to-server and server-to-server communications. See Chapter 1 for more information.
Chapter: 102
44. Which of the following is the correct command to use to create a script called COMPLETE_BAC within the recovery catalog?
A. GENERATE
B. CREATE
C. RUN
D. EXECUTE
Answer: B
The CREATE command is used to create and store the script within the recovery catalog. See Chapter 13 for more information.
Chapter: 102
45. If you wanted to load the same table simultaneously using multiple control files and data files, which of the following types of SQL*Loader method would you use?
A. Parallel conventional load
B. Intersegment concurrency with direct-path load
C. Intrasegment concurrency with direct-path load
D. Parallel direct-path load
Answer: A
The data file and control file specifying the same table can be run for different record groups within the same table. This will perform parallel conventional load on a given table. See Chapter 15 for more information.
Chapter: 102
46. You can override the default search path for names resolution by modifying which parameter?
A. NAMES.DIRECTORY_SERVER
B. NAMES.DIRECTORY_PATH
C. NAMES.SEARCH_PATH
D. NAMES.DEFAULT_PATH
Answer: B
The NAMES.DIRECTORY_PATH parameter in the sqlnet.ora file can override the default search path for names resolution. See Chapter 3 for more information.
Chapter: 102
47. Study the following RMAN command. Choose the best answer to describe it.
backup database keep until time '01-DEC-02' logs;
A. Allows recovery of the database until '01-DEC-02'
B. Allows backup of the database until '01-DEC-02'
C. Makes the backup available until '01-DEC-02'
D. Makes the backup unavailable until '01-DEC-02'
Answer: C
The KEEP command causes a backup to be kept until a certain date. This date is usually greater than the retention policy. See Chapter 12 for more information.
Chapter: 102
48. Which of the following is involved in moving data files to a new location?
A. Database commands
B. OS commands
C. Database commands and OS commands
D. Only database commands
Answer: C
The ALTER DATABASE RENAME '<datafile_name_and_location>' to '<new_datafile_name_and_location>' is the command that allows you to move a data file to a new location. Also, remember that OS commands such as cp in Unix are necessary to copy the file to the new location. The ALTER DATABASE RENAME command just updates the control file and data dictionary. See Chapter 10 for more information.
Chapter: 102
49. What part of the Oracle server environment is affected by configuration of Shared Server?
A. Redo logs
B. Rollback segments
C. Program Global Area (PGA)
D. Database buffer cache
Answer: C
The Program Global Area (PGA) is affected by the implementation of Oracle Shared Server. Memory structures found in the PGA when using a dedicated server environment are moved to the System Global Area (SGA) when using shared servers. See Chapter 4 for more information.
Chapter: 102
50. Why must you check to see if a hot or online backup is successful?
A. Data files can remain in backup status.
B. Tablespaces can remain in backup status.
C. Tables can remain in backup status.
D. Data files take some time to backup.
Answer: A
The V$BACKUP view can be used to identify whether a data file is being actively backed up or not. The V$BACKUP view will show the data file status of ACTIVE when the data file is still available for backup. See Chapter 9 for more information.
Chapter: 102
51. Which layer of the Oracle Net stack is based on the Transparent Network Substrate?
A. The Oracle Call Interface layer
B. The Oracle Net Foundation layer
C. The Two-Task Common layer
D. The Oracle Program Interface layer
Answer: B
The Oracle Net Foundation layer is based on the Transparent Network Substrate. This layer compensates for differences in connectivity issues between machines and underlying protocols. It also handles interrupt messages and passes information directly to the Oracle Protocol Adapters (OPA) layer. See Chapter 1 for more information.
Chapter: 102
52. Which environmental variable in Unix or the Registry setting in Windows NT can be used to override the default location of the Oracle Net configuration files?
A. NET_LOCATION
B. TNS_LOCATION
C. NAMES.DIRECTORY_PATH
D. TNS_ADMIN
Answer: D
The TNS_ADMIN environmental variable can be used to direct Oracle Net to look in a certain location on the client or server for the appropriate network files including sqlnet.ora, tnsnames.ora, and listener.ora. See Chapter 3 for more information.
Chapter: 102
53. Which of the following database activities are caused by the use of the FAST_START_MTTR_TARGET parameter? (Choose all that apply.)
A. The database writer writes dirty buffers faster.
B. The database writer writes dirty buffers at a predefined rate.
C. The redo log writer writes transactions faster.
D. The redo log writer writes transactions at a predefined rate.
Answer: A, B
The FAST_START_MTTR_TARGET parameter determines the number of seconds that instance recovery will require. This parameter causes the database writer (DBW0) to write dirty buffers faster and at a predefined rate. See Chapter 6 for more information.
Chapter: 102
54. What is the wizard-based tool that can be used as an easy way to configure the Oracle network files?
A. Oracle Net Manager
B. Oracle Net Configuration Assistant
C. SQL*PLus
D. Oracle Enterprise Manager
Answer: B
The Oracle Net Configuration Assistant is the wizard-based tool that can be used to configure the Oracle network files. See Chapter 2 for more information.
Chapter: 102
55. What initialization parameter controls the retention policy of the Flashback Query?
A. RETENTION_TIME
B. RETENTION_UNDO
C. UNDO_RETENTION
D. RETENTION_PERIOD
Answer: C
The initialization parameter that controls the retention period of the Flashback Query is called UNDO_RETENTION. This parameter can also be dynamically changed with ALTER SYSTEM SET UNDO_RETENTION = n, where n is the integer number of seconds. See Chapter 5 for more information.
Chapter: 102
56. What parameter would be found in the listener.ora file if you were using the hostnaming method and would not be necessary if you were using the localnaming method?
A. HOST
B. PORT
C. GLOBAL_DBNAME
D. PROTOCOL
Answer: C
The GLOBAL_DBNAME parameter needs to exist in the listener.ora file when you are using the hostnaming method. See Chapter 3 for more information.
Chapter: 102
A. Custom backup and recovery performed with OS commands and database commands
B. Non-automated RMAN-based backups
C. A new type of backup that uses RMAN but is performed by a user
D. Automated RMAN-based backup
Answer: A
User-managed backup is the term used to describe the standard backups that have been used from the inception of Oracle. These backups are usually custom written through the use of OS and database commands. See Chapter 9 for more information.
Chapter: 102
27. You receive an unusual request to restore a copy of the production financial database from the last year to compare financial numbers in some tables currently not available in the existing production database. How can you check if you still have the backup media from that timeframe?
A. Perform a REPORT SCHEMA to check if the database and backup media are available.
B. Perform a LIST BACKUP to check if the database and backup media are available.
C. Perform a CROSSCHECK of the recovery catalog and backup media.
D. Perform a CHANGE of the recovery catalog and the backup media.
Answer: C
The CROSSCHECK command will compare the recovery catalog contents and associated media. If your tape rotation cycle is 30 days, you would have supporting backup media for only 30 days, even if your recovery catalog had data for over a year. See Chapter 12 for more information.
Chapter: 102
28. You have to perform a large DBA maintenance activity involving the partial loading of a temporary table from a very large table containing invoicing information for more than a year. What would be the quickest way to create the temporary table to perform this activity?
A. Conventional load export and import.
B. Create a table using direct-load insert.
C. Conventional path SQL*Loader.
D. Create Table as Select with logging turned on.
Answer: B
Direct-load insert is best used for batch loads of data or maintenance activities, such as rebuilding or unloading tables. This would be quicker to do than all of the other options. The conventional-load export would require you to build an export dump file and then import back into the database while in conventional mode. The SQL*Loader option would require setup to build the input, or data, file and control file, and then reload. The Create Table as Select (CTAS) option would require little setup, but because logging is turned on, the process would slow down. See Chapter 15 for more information.
Chapter: 102
29. All of the following would be network design considerations except:
A. Network complexity
B. Network security
C. Interfacing with new and existing systems
D. Backup and recovery issues for the Oracle server
Answer: D
Backup and recovery would not be considered a network design consideration. This is more of an Oracle server administration issue. See Chapter 1 for more information.
Chapter: 102
30. There was a complete disaster that forced you to rebuild a database environment from yesterday's backup. The most current 20 offline redo logs were lost when the complete disaster occurred. What components would you need to completely rebuild a database to a point as close as possible before the disaster?
A. All data files, all control files, parameter files, and only online redo logs
B. All data files, one control file, parameter files, and all redo logs
C. All data files, one control file, parameter files, and some of the available offline redo logs
D. All data files, parameter files, and all online redo logs
Answer: B
The type of recovery that would restore and recover a database to some point before a failure is best described as an incomplete recovery. Also, the most current 20 offline redo logs (archived logs) are unavailable. This means that you cannot perform a complete recovery. The components required to perform a complete recovery are all the necessary data files, at least one current control file, parameter files, and all of the available offline redo logs (archived logs). The online redo logs will not allow you to roll forward from the backup. Of the archived logs available, you will only be able to roll forward as far as you have archived logs. You will also need at least a control file or a backup control to recover the database. See Chapter 10 for more information.
Chapter: 102
31. Which of the following views can be used to identify cleanup issues after a failed hot or online backup?
A. V$BACKUP
B. ALL_BACKUP
C. USER_BACKUP
D. DBA_BACKUP
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: 102
32. Which Oracle background process has the responsibility of writing committed or uncommitted transactions to redo logs?
A. PMON
B. SMON
C. LGWR
D. DBWR
Answer: C
The LGWR process is responsible for applying all of the committed or uncommitted changes to the online redo logs. See Chapter 6 for more information.
Chapter: 102
33. Which Oracle background process registers information with the listener when you are using Oracle Shared Server?
A. SMON
B. LGWR
C. DBWR
D. PMON
Answer: D
The Process Monitor (PMON) registers information with an Oracle listener. This information is used by the listener when it assigns client connections to dispatchers. See Chapter 4 for more information.
Chapter: 102
34. There is media failure that requires you to get the most recent full and incremental backups of the necessary files. What must you do?
A. Perform an incremental RESTORE.
B. Use data files to perform a full RESTORE.
C. Perform a RESTORE.
D. Use redo logs to perform a complete RECOVER.
Answer: C
The RESTORE command will get the necessary files from full and incremental backups to bring the database to the most complete point. This is handled automatically by the RESTORE command. See Chapter 10 for more information.
Chapter: 102
35. In which of the following files would you find the NAMES.DIRECTORY_PATH parameter?
A. tnsnames.ora
B. listener.ora
C. sqlnet.ora
D. protocol.ora
Answer: C
The NAMES.DIRECTORY_PATH would be located in the sqlnet.ora file. See Chapter 3 for more information.
Chapter: 102
36. Which piece of Oracle software allows you to run RMAN on a client?
A. Remote recovery catalog
B. Media Management Library
C. RMAN in GUI through Enterprise Manager
D. RMAN in command-line mode
Answer: C
The RMAN utility can be run remotely in the Oracle Enterprise Manager tool. See Chapter 8 for more information.
Chapter: 102
37. You wish to set the number of TCP/IP dispatcher processes to 5. Which command would accomplish this?
A. ALTER SYSTEM SET dispatchers="(PRO=TCP)(DIS=5)"
B. ALTER DATABASE SET dispatchers="(PRO=TCP)(DIS=5)"
C. ALTER SESSION SET dispatchers="(PRO=TCP)(DIS=5)"
D. EXECUTE DBMS_SHARED_SERVER.DISPATCHERS( PRO=TCP,DIS=5)
Answer: A
You can use the ALTER SYSTEM command to modify the DISPATCHERS initialization parameter. This change would take affect immediately and last until the next time the Oracle server was restarted. See Chapter 4 for more information.
Chapter: 102
38. How can you monitor instance recovery performance that had parallel DML activity prior to failure?
A. V$FAST_TRANSACTIONS
B. V$FAST_START_TRANSACTIONS
C. V$FAST_START_TRANS
D. V$FAST_START_TRANSACTION
Answer: B
The V$FAST_START_TRANSACTIONS view can help monitor instance recovery of parallel DML activity that occurred before the instance failure. This view monitors parallel transaction rollback process. See Chapter 6 for more information.
Chapter: 102
39. Study the following commands. Choose the best answer to describe what will be the result of their use.
RMAN> allocate channel c1 type disk;
RMAN> crosscheck backup of database;
A. Will perform a crosscheck of the selected target database
B. Will perform a crosscheck of the recovery catalog
C. Will fail because of invalid syntax
D. Will perform a crosscheck of the RMAN repository
Answer: C
The commands will fail because ALLOCATE CHANNEL FOR MAINTENANCE TYPE DISK is not used. This option must be used with the CROSSCHECK command. See Chapter 12 for more information.
Chapter: 102
40. What is the default name of the Oracle listener?
A. lsnrctl
B. LISTENER
C. LISTEN
D. LISTENER_DEFAULT
Answer: B
The default name given to the Oracle listener is LISTENER. You can override this or create multiple listeners with different names. See Chapter 2 for more information.
Chapter: 102
41. Study the RMAN command below. Choose the best answer to describe it.
rman target / catalog rman/rman@rcat
A. This command connects to the target database.
B. This command connects to the recovery catalog only.
C. This command connects to the RMAN repository.
D. This command connects to both the recovery catalog and the target database.
Answer: D
This command sequence will cause a connection to the target database and recovery catalog, which is also known as the RMAN repository. The target database would need to be defined prior to running this command. When connecting to the target database, the control files of the target database will also be accessed. See Chapter 13 for more information.
Chapter: 102
42. Which status determines that the tape is available in the CROSSCHECK comparison?
A. AVAILABLE
B. READY
C. VERIFIED
D. VALID
Answer: A
The backup sets, which are on the media disk/tape but are in the recovery catalog, return a status of AVAILABLE. See Chapter 12 for more information.
Chapter: 102
43. "Responsible for handling client-to-server and server-to-server communication" best describes which of the following?
A. Connection Manager
B. Oracle Shared Server
C. Oracle Internet Directory
D. Oracle Net
Answer: D
Oracle Net provides the "glue" in an Oracle network. It is responsible for all client-to-server and server-to-server communications. See Chapter 1 for more information.
Chapter: 102
44. Which of the following is the correct command to use to create a script called COMPLETE_BAC within the recovery catalog?
A. GENERATE
B. CREATE
C. RUN
D. EXECUTE
Answer: B
The CREATE command is used to create and store the script within the recovery catalog. See Chapter 13 for more information.
Chapter: 102
45. If you wanted to load the same table simultaneously using multiple control files and data files, which of the following types of SQL*Loader method would you use?
A. Parallel conventional load
B. Intersegment concurrency with direct-path load
C. Intrasegment concurrency with direct-path load
D. Parallel direct-path load
Answer: A
The data file and control file specifying the same table can be run for different record groups within the same table. This will perform parallel conventional load on a given table. See Chapter 15 for more information.
Chapter: 102
46. You can override the default search path for names resolution by modifying which parameter?
A. NAMES.DIRECTORY_SERVER
B. NAMES.DIRECTORY_PATH
C. NAMES.SEARCH_PATH
D. NAMES.DEFAULT_PATH
Answer: B
The NAMES.DIRECTORY_PATH parameter in the sqlnet.ora file can override the default search path for names resolution. See Chapter 3 for more information.
Chapter: 102
47. Study the following RMAN command. Choose the best answer to describe it.
backup database keep until time '01-DEC-02' logs;
A. Allows recovery of the database until '01-DEC-02'
B. Allows backup of the database until '01-DEC-02'
C. Makes the backup available until '01-DEC-02'
D. Makes the backup unavailable until '01-DEC-02'
Answer: C
The KEEP command causes a backup to be kept until a certain date. This date is usually greater than the retention policy. See Chapter 12 for more information.
Chapter: 102
48. Which of the following is involved in moving data files to a new location?
A. Database commands
B. OS commands
C. Database commands and OS commands
D. Only database commands
Answer: C
The ALTER DATABASE RENAME '<datafile_name_and_location>' to '<new_datafile_name_and_location>' is the command that allows you to move a data file to a new location. Also, remember that OS commands such as cp in Unix are necessary to copy the file to the new location. The ALTER DATABASE RENAME command just updates the control file and data dictionary. See Chapter 10 for more information.
Chapter: 102
49. What part of the Oracle server environment is affected by configuration of Shared Server?
A. Redo logs
B. Rollback segments
C. Program Global Area (PGA)
D. Database buffer cache
Answer: C
The Program Global Area (PGA) is affected by the implementation of Oracle Shared Server. Memory structures found in the PGA when using a dedicated server environment are moved to the System Global Area (SGA) when using shared servers. See Chapter 4 for more information.
Chapter: 102
50. Why must you check to see if a hot or online backup is successful?
A. Data files can remain in backup status.
B. Tablespaces can remain in backup status.
C. Tables can remain in backup status.
D. Data files take some time to backup.
Answer: A
The V$BACKUP view can be used to identify whether a data file is being actively backed up or not. The V$BACKUP view will show the data file status of ACTIVE when the data file is still available for backup. See Chapter 9 for more information.
Chapter: 102
51. Which layer of the Oracle Net stack is based on the Transparent Network Substrate?
A. The Oracle Call Interface layer
B. The Oracle Net Foundation layer
C. The Two-Task Common layer
D. The Oracle Program Interface layer
Answer: B
The Oracle Net Foundation layer is based on the Transparent Network Substrate. This layer compensates for differences in connectivity issues between machines and underlying protocols. It also handles interrupt messages and passes information directly to the Oracle Protocol Adapters (OPA) layer. See Chapter 1 for more information.
Chapter: 102
52. Which environmental variable in Unix or the Registry setting in Windows NT can be used to override the default location of the Oracle Net configuration files?
A. NET_LOCATION
B. TNS_LOCATION
C. NAMES.DIRECTORY_PATH
D. TNS_ADMIN
Answer: D
The TNS_ADMIN environmental variable can be used to direct Oracle Net to look in a certain location on the client or server for the appropriate network files including sqlnet.ora, tnsnames.ora, and listener.ora. See Chapter 3 for more information.
Chapter: 102
53. Which of the following database activities are caused by the use of the FAST_START_MTTR_TARGET parameter? (Choose all that apply.)
A. The database writer writes dirty buffers faster.
B. The database writer writes dirty buffers at a predefined rate.
C. The redo log writer writes transactions faster.
D. The redo log writer writes transactions at a predefined rate.
Answer: A, B
The FAST_START_MTTR_TARGET parameter determines the number of seconds that instance recovery will require. This parameter causes the database writer (DBW0) to write dirty buffers faster and at a predefined rate. See Chapter 6 for more information.
Chapter: 102
54. What is the wizard-based tool that can be used as an easy way to configure the Oracle network files?
A. Oracle Net Manager
B. Oracle Net Configuration Assistant
C. SQL*PLus
D. Oracle Enterprise Manager
Answer: B
The Oracle Net Configuration Assistant is the wizard-based tool that can be used to configure the Oracle network files. See Chapter 2 for more information.
Chapter: 102
55. What initialization parameter controls the retention policy of the Flashback Query?
A. RETENTION_TIME
B. RETENTION_UNDO
C. UNDO_RETENTION
D. RETENTION_PERIOD
Answer: C
The initialization parameter that controls the retention period of the Flashback Query is called UNDO_RETENTION. This parameter can also be dynamically changed with ALTER SYSTEM SET UNDO_RETENTION = n, where n is the integer number of seconds. See Chapter 5 for more information.
Chapter: 102
56. What parameter would be found in the listener.ora file if you were using the hostnaming method and would not be necessary if you were using the localnaming method?
A. HOST
B. PORT
C. GLOBAL_DBNAME
D. PROTOCOL
Answer: C
The GLOBAL_DBNAME parameter needs to exist in the listener.ora file when you are using the hostnaming method. See Chapter 3 for more information.
Chapter: 102
