April 23, 2010, Newsletter Issue #31: Oracle DBA Interview Questions and Answers

Tip of the Week

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

Export-import, CREATE TABLE… AS SELECT, COPY
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.
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.
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.
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.

About LifeTips

Now one of the top on-line publishers in the world, LifeTips offers tips to millions of monthly visitors. Our mission mission is to make your life smarter, better, faster and wiser. Expert writers earn dough for what they know. And exclusive sponsors in each niche topic help us make-it-all happen.

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


Guru Spotlight
Ray Lokar