Oracle Interview Questions & FAQs

Question :: (On UNIX) When should more than one DB writer process be used? How many should be used?

View Answer

Question :: What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?

View Answer

Question :: What is the proper method for disabling and re-enabling a primary key constraint?

View Answer

Question :: What happens if a tablespace clause is left off of a primary key constraint clause?

View Answer

Question :: What happens if the constraint name is left out of a constraint clause?

View Answer

Question :: What are some of the Oracle provided packages that DBAs should be aware of?

View Answer

Question :: If the DEFAULT and TEMPORARY tablespace clauses are left out of a CREATE USER command what happens? Is this bad or good? Why?

View Answer

Question :: You have a rollback segment in a version 7.2 database that has expanded beyond optimal, how can it be restored to optimal?

View Answer

Question :: What is the purpose of the IMPORT option IGNORE? What is it?s default setting?

View Answer

Question :: Give one method for transferring a table from one schema to another.

View Answer

Question :: What are the types of triggers?

View Answer

Question :: How can you generate debugging output from PL/SQL?

View Answer

Question :: How can you find within a PL/SQL block, if a cursor is open?

View Answer

Question :: What are SQLCODE and SQLERRM and why are they important for PL/SQL developers?

View Answer

Question :: In what order should a open/fetch/loop set of commands in a PL/SQL block be implemented if you use the %NOTFOUND cursor variable in the exit when statement? Why?

View Answer

Question :: When is a declare statement needed ?

View Answer

Question :: Describe the use of PL/SQL tables

View Answer

Question :: What packages (if any) has Oracle provided for use by developers?

View Answer

Question :: Describe the use of %ROWTYPE and %TYPE in PL/SQL

View Answer

Question :: What is a mutating table error and how can you get around it?

View Answer

Question :: Where in the Oracle directory tree structure are audit traces placed?

View Answer

Question :: Name three advisory statistics you can collect.

View Answer

Question :: Explain the use of table functions.

View Answer

Question :: Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

View Answer

Question :: What command would you use to encrypt a PL/SQL application?

View Answer

Question :: Explain the use of setting GLOBAL_NAMES equal to TRUE.

View Answer

Question :: How would you determine the time zone under which a database was operating?

View Answer

Question :: Explain an ORA-01555

View Answer

Question :: How would you go about increasing the buffer cache hit ratio?

View Answer

Question :: How would you go about generating an EXPLAIN plan?

View Answer