1. Define OFA. Level: Low
Expected answer: OFA stands for Optimal Flexible Architecture. It is a method
of placing directories and files in an Oracle system so that you get the
maximum flexibility for future tuning and file placement.
2. How do you set up your tablespace on installation?
Expected answer: The answer here should show an understanding of separation of redo and rollback, data and indexes and isolation os SYSTEM tables from other tables. An example would be to specify that at least 7 disks should be used for an Oracle installation so that you can place SYSTEM tablespace on one, redo logs on two (mirrored redo logs) the TEMPORARY tablespace on another, ROLLBACK tablespace on another and still have two for DATA and INDEXES. They should indicate how they will handle archive logs and exports as well. As long as they have a logical plan for combining or further separation more or less disks can be specified.
Expected answer: The answer here should show an understanding of separation of redo and rollback, data and indexes and isolation os SYSTEM tables from other tables. An example would be to specify that at least 7 disks should be used for an Oracle installation so that you can place SYSTEM tablespace on one, redo logs on two (mirrored redo logs) the TEMPORARY tablespace on another, ROLLBACK tablespace on another and still have two for DATA and INDEXES. They should indicate how they will handle archive logs and exports as well. As long as they have a logical plan for combining or further separation more or less disks can be specified.
3. What should
be done prior to installing Oracle (for the OS and the disks)? Level: Low
Expected Answer: adjust kernel parameters or OS tuning parameters in accordance with installation guide. Be sure enough contiguous disk space is available.
Expected Answer: adjust kernel parameters or OS tuning parameters in accordance with installation guide. Be sure enough contiguous disk space is available.
4. You have
installed Oracle and you are now setting up the actual instance. You have been
waiting an hour for the initialization script to finish, what should you check
first to determine if there is a problem?
Expected Answer: Check to make sure that the archiver isn’t stuck. If archive logging is turned on during install a large number of logs will be created. This can fill up your archive log destination causing Oracle to stop to wait for more space.
Expected Answer: Check to make sure that the archiver isn’t stuck. If archive logging is turned on during install a large number of logs will be created. This can fill up your archive log destination causing Oracle to stop to wait for more space.
5. When configuring SQLNET on the server what files
must be set up? Level: Intermediate
Expected answer: INITIALIZATION file, TNSNAMES.ORA file, SQLNET.ORA file
Expected answer: INITIALIZATION file, TNSNAMES.ORA file, SQLNET.ORA file
6. When
configuring SQLNET on the client what files need to be set up? Level:
Intermediate
Expected answer: SQLNET.ORA, TNSNAMES.ORA
Expected answer: SQLNET.ORA, TNSNAMES.ORA
7. What must be
installed with ODBC on the client in order for it to work with Oracle?
Expected answer: SQLNET and PROTOCOL (for example: TCPIP adapter) layers of the transport programs.
Expected answer: SQLNET and PROTOCOL (for example: TCPIP adapter) layers of the transport programs.
8. You have just started a new instance with a large
SGA on a busy existing server. Performance is terrible, what should you check
for? The
first thing to check with a large SGA is that it isn’t being swapped out.
9. What OS user
should be used for the first part of an Oracle installation (on UNIX)?
Expected answer: You must use root first.
Expected answer: You must use root first.
10. When should
the default values for Oracle initialization parameters be used as is?
Expected answer: Never
Expected answer: Never
11. How many
control files should you have? Where should they be located? Level: Low
Expected answer: At least 2 on separate disk spindles. Be sure they say on separate disks, not just file systems.
Expected answer: At least 2 on separate disk spindles. Be sure they say on separate disks, not just file systems.
12. How many
redo logs should you have and how should they be configured for maximum
recoverability?
Expected answer: You should have at least three groups of two redo logs with the two logs each on a separate disk spindle (mirrored by Oracle). The redo logs should not be on raw devices on UNIX if it can be avoided.
Expected answer: You should have at least three groups of two redo logs with the two logs each on a separate disk spindle (mirrored by Oracle). The redo logs should not be on raw devices on UNIX if it can be avoided.
13. You have a
simple application with no "hot" tables (i.e. uniform IO and access
requirements). How many disks should you have assuming standard layout for
SYSTEM, USER, TEMP and ROLLBACK tablespaces?
Expected answer: At least 7, see disk configuration answer above.
Expected answer: At least 7, see disk configuration answer above.
No comments:
Post a Comment