What happens if a tablespace clause is left off

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

(Continued from previous question...)

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

Level: Low
Expected answer: This results in the index that is automatically generated being placed in then users default tablespace. Since this will usually be the same tablespace as the table is being created in, this can cause serious performance problems.

(Continued on next question...)

Other Job Interview Questions

• What is the difference among “dropping a table”, “truncating a table” and “deleting all records” from a table.
• How can you enable automatic archiving?
• What is a Database instance?
• What is snapshots?
• How do I eliminate the duplicate rows ?
• What are the master-detail triggers?
• Describe two phases of Two-phase commit?
• What use of command line parameter cmd file?
• What is the maximum number of triggers, can apply to a single table?
• What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command?
• More...