Oracle DBA Fundamentals-6

1. What type of incomplete recovery is based on each transaction?
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. See Chapter 11 for more information.
Chapter: 101
2. What 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: 101
3. What files can store load data when SQL*Loader is being used? (Choose all that apply.)
A. General log files
B. Input files
C. Control files
D. Discard log files
Answer: C
The data file or control file both can be used to store load data. The control file should only store small data loads for one-time use or test purposes. See Chapter 15 for more information.
Chapter: 101
4. Which of the following are physical structures of the Oracle database? (Choose all that apply.)
A. Control files
B. Input files
C. Parameter files
D. Alert logs
Answer: A, C
Control files and parameter files make up two of the physical structures of the Oracle database. Data files and redo logs make up the other physical structures. See Chapter 6 for more information.
Chapter: 101
5. Which of the following RMAN commands would you need to execute in order to store information in the recovery catalog and the actual data files that were backed up by OS commands?
A. BACKUP DATAFILE
B. BACKUP
C. DATAFILE COPY
D. CATALOG DATAFILECOPY
Answer: D
The command CATALOG DATAFILECOPY backs up data files that were copied or backed up by OS commands in user-managed backups. See Chapter 12 for more information.
Chapter: 101
6. Which of the following is the correct way(s) to perform control file backups? (Choose all that apply.)
A. Alter the database backup control file to TRACE.
B. Alter the database backup control file to `<controlfile_name>'.
C. Alter the system backup control file to TRACE.
D. Alter the system backup control file to `<controlfile_name>'.
Answer: A, B
The control file can be backed up in two ways: in ASCII format, it can be backed up to a TRACE file, or in binary format, it can be backed up to a new location. The ALTER DATABASE BACKUP CONTROLFILE TO TRACE and ALTER DATABASE BACKUP CONTROLFILE TO `<controlfile_name>' commands perform backups of the control file to ASCII format and to binary format. See Chapter 9 for more information.
Chapter: 101
7. Which of these are roles of Oracle Net in the Oracle network architecture? (Choose all that apply.)
A. Handles communications between the client and server
B. Handles server-to-server communications
C. Used to establish an initial connection to an Oracle server
D. Acts as a messenger, which passes requests between clients and servers
E. All of the above
Answer: E
Oracle Net is responsible for handling client-to-server and server-to-server communications in an Oracle environment. It manages the flow of information in the Oracle network infrastructure. Oracle Net is used to establish the initial connection to the Oracle server and then it acts as the messenger, which passes requests from the client back to the server or between two Oracle servers. See Chapter 1 for more information.
Chapter: 101
8. What are the roles that you must grant the RMAN schema owner of the recovery catalog? (Choose all that apply.)
A. dba
B. connect
C. resource
D. recovery_catalog_owner
Answer: B, C, D
The roles that are required for the RMAN schema that owns the recovery catalog are connect, resource, and recovery_catalog_owner. See Chapter 13 for more information.
Chapter: 101
9. Which of the following are advantages of Shared Server? (Choose all that apply.)
A. Fewer server processes
B. Manages more connections with the same or less memory
C. Better client response time
D. All of the above
Answer: A, B
Oracle Shared Server allows Oracle servers to manage a greater number of connections utilizing the same amount or less memory and process resources. If an Oracle server is constrained by these resources, Oracle Shared Server can be an alternative configuration that can provide relief. See Chapter 4 for more information.
Chapter: 101
10. What type of failure requires an incomplete recovery? (Choose all that apply.)
A. Any media failure involving the system tablespace
B. The loss of inactive or active online redo logs
C. The loss of an archived log since the last current backup
D. The loss of a control file
Answer: B, C
The loss of inactive or active online redo logs will require an incomplete recovery because the backup will not have all the required logs to apply to the database. The loss of an archived log since the last current backup will also not allow a complete recovery for the same reason as a missing redo log. See Chapter 11 for more information.
Chapter: 101
11. Which of the following is true about dispatchers?
A. They listen for client connection requests.
B. They take the place of dedicated servers.
C. They place client requests on a response queue.
D. All of the above.
Answer: B
Dispatchers take the place of the dedicated server processes. The dispatchers are responsible for responding to client requests by placing the requests on a request queue (not a response queue) in the SGA; they also retrieve completed requests that were placed on a response queue by the shared server and pass them back to the client. See Chapter 4 for more information.
Chapter: 101
12. Which command-line option of the Export utility groups commands together in a common file?
A. config.ora
B. PARFILE
C. ifile
D. commandfile
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: 101
13. What type of incomplete recovery requires the DBA to manually stop the recovery at a certain point?
A. Cancel-based
B. Time-based
C. Change-based
D. Sequence-based
Answer: A
Cancel-based recovery requires the DBA to manually cancel the recovery process at the command line. See Chapter 11 for more information.
Chapter: 101
14. What is the new parameter file that has been introduced in Oracle9i?
A. spfile.ora
B. init.ora
C. config.ora
D. ifile.ora
Answer: A
The spfile.ora is new for Oracle9i. This is the binary initialization file that is the default when Oracle is started. This file contains persistent parameters. The init.ora file is searched only if there isn't a spfile.ora initialization file. See Chapter 6 for more information.
Chapter: 101
15. What utility can you use to verify corruption of both backup and online data files?
A. DBMS_REPAIR
B. DBVERIFY
C. ANALYZE
D. DB_CHECKSUM
Answer: B
The DBVERIFY utility can verify both online data files and copies of online data files. See Chapter 9 for more information.
Chapter: 101
16. When you open a database with the ALTER DATABASE OPEN RESETLOGS, you need to perform which command in RMAN to the incarnation of the database?
A. REGISTER
B. UNREGISTER
C. RESET
D. UNSET
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. See Chapter 13 for more information.
Chapter: 101
17. What is the primary configuration file of the localnaming option?
A. sqlnet.ora
B. tnsnames.ora
C. listener.ora
D. names.ora
Answer: B
The main characteristic of the localnaming method is that it uses the tnsnames.ora file to resolve service names. In fact, this method is sometimes called the tnsnames.ora method. The file contains information about the service name and connect descriptors for each service name that a client can contact. See Chapter 3 for more information.
Chapter: 101
18. What is the name of the manual allocation channel method that utilizes tape?
A. ALLOCATE CHANNEL C1 TYPE `SBT_TAPE'
B. ALLOCATE CHANNEL C1 TYPE DLT_TAPE
C. CONFIGURE DEFAULT DEVICE TYPE SBT_TAPE
D. CONFIGURE DEFAULT DEVICE TYPE TAPE
Answer: A
CONFIGURE DEFAULT DEVICE settings configure the allocation channel automatically. ALLOCATE CHANNEL <channel_name> TYPE methods are used to manually configure channels. The type `SBT_TAPE' configures the manual channel for tape. See Chapter 8 for more information.
Chapter: 101
19. What prerequisites are required to implement direct-load insert? (Choose all that apply.)
A. Parallel DML must be enabled.
B. Initialization parameters must be configured for parallel query.
C. The SQL*Loader utility must be configured for parallel processing.
D. There must be hints in DML statements.
E. Multiple SQL*Loader control files and data files must be present.
Answer: A, B, D
The database must be configured for parallel query or it must have the appropriate initialization parameters, such as PARALLEL_MIN_SERVERS and PARALLEL_MAX_SERVERS, set up. The session must be enabled to run parallel DML. And the appropriate hints must be entered in the DML statements to allow direct-load insert. See Chapter 15 for more information.
Chapter: 101
20. What does Dynamic Registration do?
A. Allows a listener to automatically register with an Oracle server
B. Allows an Oracle server to automatically register with a listener
C. Allows clients to automatically register with an Oracle listener
D. None of the above
Answer: B
Dynamic Registration allows an Oracle server to automatically register with a listener. This reduces the amount of maintenance work the DBA has to do to maintain the listener.ora file in a localnaming environment. See Chapter 2 for more information.
Chapter: 101
21. An open backup can be performed when which of the following is true about the database? (Choose all that apply.)
A. It is in NOARCHIVELOG mode.
B. It is in ARCHIVELOG mode.
C. When tablespaces are placed in BACKUP mode with the ALTER TABLESPACE <tablespace_name> BEGIN BACKUP command.
D. The database is shut down.
Answer: B, C
An open backup is also called a hot backup and it can be performed when the database is in ARCHIVELOG mode by executing the ALTER TABLESPACE <tablespace_name> BEGIN BACKUP command. See Chapter 9 for more information.
Chapter: 101
22. Which of the following backup and recovery parameters utilize their operations within the LARGE_POOL memory of the SGA? (Choose all that apply.)
A. DBWR_IO_SLAVES
B. ASYNC_IO_SLAVES
C. BACKUP_TAPE_IO_SLAVES
D. SYNCH_IO_SLAVES
Answer: A, C
The DBWR_IO_SLAVES and BACKUP_TAPE_IO_SLAVES are initialization parameters that can improve the performance of backup and recovery operations. These parameters use the LARGE_POOL memory to perform their operations. See Chapter 6 for more information.
Chapter: 101
23. Which statement best describes incomplete recovery?
A. No data whatsoever is lost.
B. Data is lost after the point of failure.
C. Some data is lost because the recovery is prior to the point failure.
D. Some data is lost because the data file recovery is incomplete.
Answer: C
The statement that accurately describes incomplete recovery is "Some data is lost because the recovery is prior to the point of failure." See Chapter 11 for more information.
Chapter: 101
24. Which of the following best describes network access control?
A. It allows clients and servers using different protocols to communicate.
B. It sets up rules to allow or disallow connections to Oracle servers.
C. It funnels client connections into a single outgoing connection to the Oracle server.
D. None of the above.
Answer: B
Client access control is a feature of Connection Manager that makes Connection Manager function in a manner similar to that of a firewall. Connections can be accepted or rejected on the basis of the client location, the destination server, and the Oracle service that the client is attempting to connect to. This gives the DBA flexibility they need to configure access control to the Oracle environment. See Chapter 1 for more information.
Chapter: 101
25. Resynching the recovery catalog should be performed when you do what to the target database?
A. Undo a database resynch.
B. Remove a database reset.
C. Undo the most recent database resynch only.
D. Make a physical change to the target database.
Answer: D
The resynch command should be used when you make physical changes to the target database, such as adding new data files or control files. See Chapter 13 for more information.
Chapter: 101
26. Which 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. See Chapter 10 for more information.
Chapter: 101
27. The main difference between logging and tracing is
A. Tracing cannot be disabled.
B. Logging cannot be disabled.
C. Logging records only significant events.
D. Tracing records only significant events.
Answer: C
Logging records significant events, such as starting and stopping the listener, along with certain kinds of network errors. Tracing records all events that occur, even when an error does not happen. The trace file provides a great deal of information that logs do not. See Chapter 2 for more information.
Chapter: 101
28. Which of the following parameters ensures the number of successful archive destinations before the redo information can be written over?
A. LOG_ARCHIVE_SUCCESS
B. LOG_ARCHIVE_MIN_SUCCEED_DEST
C. LOG_MIN_SUCCESS
D. LOG_ARCHIVE_SUCCEED
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: 101
29. What is the location of the trace file generated when the Oracle PMON process encounters an error?
A. USER_DUMP_DEST
B. BACKGROUND_DUMP_DEST
C. CORE_DUMP_DEST
D. ARCH_DUMP_DEST
Answer: B
The Oracle PMON process is a background process. All trace files generated from the background process go into the BACKGROUND_DUMP_DEST location. See Chapter 12 for more information.
Chapter: 101
30. Which of the following parameters is used to improve the performance of instance recovery operations?
A. FAST_START_MTTR_TARGET
B. FAST_START
C. CHECKPOINT_INTERVAL
D. CHECKPOINT
Answer: A
The FAST_START_MTTR_TARGET parameter determines the number of seconds that instance recovery will require. This parameter is an integer value between 0 and 3600. See Chapter 6 for more information.
Chapter: 101
31. What utility can be used to check to see if a client can see an Oracle listener?
A. netstat
B. namesctl
C. tnsping
D. lsnrctl
E. None of the above
Answer: C
The tnsping utility can be used to check to see if a client can contact a listener. The command format is tnsping <databasename> <number of tries>. For example, tnsping DBA 3 would attempt to contact the DBA database three times. This utility also provides information on how long it takes to contact the listener. See Chapter 3 for more information.
Chapter: 101
32. Which of the following commands generate reports from the recovery catalog or target database control file? (Choose all that apply.)
A. REPORT
B. LIST
C. SELECT
D. PUTLINE
Answer: A, B
The REPORT and LIST commands generate report outputs in the RMAN utility. See Chapter 13 for more information.
Chapter: 101
33. Which of the following Oracle processes is not mandatory at startup?
A. SMON
B. PMON
C. DBWR
D. ARCH
Answer: D
The ARCH or ARCn process is not a mandatory process. Archive logging can be enabled and disabled. See Chapter 6 for more information.
Chapter: 101
34. Which of the following is a major difference between the RESTORE command in earlier versions of RMAN and in Oracle9i RMAN?
A. Nothing has changed.
B. The decision about whether files need to be restored or not.
C. Only backup sets are restored.
D. Only image copies are restored.
Answer: B
In Oracle9i, the RESTORE command now makes the decision of whether or not files need to be restored. In earlier versions of RMAN, files were restored upon request even if it was unnecessary. See Chapter 10 for more information.
Chapter: 101
35. Which of the following is true about shared servers?
A. They talk to dispatchers.
B. They execute client requests.
C. They talk directly to the listener.
D. They talk directly to a client process.
Answer: B
The shared server processes are responsible for executing the client requests. They retrieve the requests from a request queue and place the completed request in the appropriate dispatcher response queue. See Chapter 4 for more information.
Chapter: 101