Explain the difference between $ORACLE_HOME and

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

25. 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.

(Continued on next question...)

Other Job Interview Questions

• How can you determine if an index needs to be dropped and rebuilt?
• What are the built-ins used for Getting cell values?
• What are the various methods of performing a calculation in a report?
• If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?
• Explain the relationship among Database, Tablespace and Data file.?
• Any three PL/SQL Exceptions?
• Oracle cursor : Implicit & Explicit cursors
• Explain the difference between a data block, an extent and a segment.
• What is the maximum no of chars the parameter can store?
• What use of command line parameter cmd file?
• More...