Oracle DBA Interview Preparation Guide
Download PDF
Add New Question

Oracle DBA Interview Questions and Answers will guide us now that the Oracle Database commonly referred to as Oracle RDBMS or simply Oracle is a relational database management system (RDBMS) produced and marketed by Oracle Corporation. As of 2009, Oracle remains a major presence in database computing. So get preparation of Oracle DBA Jobs with this Oracle DBA Interview Questions with Answers guide

48 Oracle DBA Questions and Answers:

1 :: When using Oracle export/import what character set concerns might come up? How do you handle them?

Be sure to set NLS_LANG for example to "AMERCIAN_AMERICA.WE8ISO8859P1". If your source database is US7ASCII, beware of 8-bit characters. Also be wary of multi-byte characters sets as those may require extra attention. Also watch export/import for messages about any "character set conversions" which may occur.
Post Your Answer

2 :: How do you use automatic PGA memory management with Oracle 9i and above?

Set the WORKAREA_SIZE_POLICY parameter to AUTO and set PGA_AGGREGATE_TARGET
Post Your Answer

3 :: Explain two easy SQL optimizations.

a. EXISTS can be better than IN under various conditions
b. UNION ALL is faster than UNION (not sorting)
Post Your Answer

4 :: Name three SQL operations that perform a SORT.

a. CREATE INDEX
b. DISTINCT
c. GROUP BY
d. ORDER BY
f. INTERSECT
g. MINUS
h. UNION
i. UNINDEXED TABLE JOIN
Post Your Answer

5 :: What is your favorite tool for day-to-day Oracle operation?

Hopefully we hear some use of command line as the answer!
Post Your Answer
Add New Question