Oracle DBA Interview Questions and Answers

Read this tip to make your life smarter, better, faster and wiser. LifeTips is the place to go when you need to know about Interviewing Tips for ERP Consultants and other ERP Jobs topics.

What types of Oracle DBA questions will I be asked during an interview?

Oracle DBA Interview Questions and Answers

  1. Explain a method for transferring a table from one schema to another.

    Export-import, CREATE TABLE… AS SELECT, COPY

  2. If there is a rollback segment in a version 7.2 database that expanded beyond optimal, how do you restore it to optimal?

    You should use the ALTER TABLESAPCE… SHRINK command.

  3. What happens when you leave the DEFAULT and TEMPORARY tablespace clauses out of a CREATE USER command?

    The user will be assigned the SYSTEM tablespace as a default and temporary tablespace. This is not good, as it causes user objects and temporary segments to be placed in the SYSTEM tablespace. This results in fragmentation and improper table placement.

  4. What Oracle provided packages should DBAs be aware of?

    DBMS_SHARED_POOL, DBMS_UTILITY, DBMS_SQL, DBMS_DDL, DBMS_SESSION, DBMS_OUTPUT and DBMS_SNAPSHOT.

  5. What happens if a tablespace clause is left off of a primary key constraint clause?

    The index that is automatically generated will be placed in the users default tablespace. This is usually the same tablespace that the table is being created in and will cause serous performance issues.

   

Comments

Nobody has commented on this tip yet. Be the first.



Name:


URL: (optional)


Comment:


Not finding the advice and tips you need on this ERP Jobs Tip Site? Request a Tip Now!


Guru Spotlight
Linda Handiak