ORACLE DBA INTERVIEW QUESTIONS AND ANSWERS
Page – 4
31. Where would you look for
errors from the database engine?
In the alert log
32. What type of index should you
use on a fact table?
A Bitmap index.
33.Explain the difference between
$ORACLE_HOME and $ORACLE_BASE.
ORACLE_BASE is the root directory
for oracle. ORACLE_HOME located beneath ORACLE_BASE is where the oracle
products reside.
34. What is the purpose of the
IMPORT option IGNORE? What is it? What is its
default setting?
The IMPORT IGNORE option tells
import to ignore "already exists" errors. If it is not specified the
tables that already exist will be skipped. If it is specified, the error is
ignored and the tables data will be inserted. The default value is N
35. What is the proper method for
disabling and re-enabling a primary key constraint
You use
the ALTER TABLE command for both. However, for the enable clause you must
specify the USING INDEX and TABLESPACE clause for primary keys
36. How do
you generate file output from SQL
By use of the SPOOL command
37. What is the fastest query
method for a table
Fetch by rowed
38. Where
can you get a list of all initialization parameters for your instance? How
about an indication if they are default settings or have been changed
You can look in the init.ora file
for an indication of manually set parameters. For all parameters, their value
and whether or not the current value is the default value, look in the
v$parameter view
39. If you see contention
for library caches how can you fix it
Increase the size of the
shared pool
40. If you see statistics that deal with
"undo" what are they really talking about
Rollback segments and associated
structures
No comments:
Post a Comment