If a tablespace has a default pctincrease of zer

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

(Continued from previous question...)

If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?

Level: High
Expected answer: The SMON process won?t automatically coalesce its free space fragments.

(Continued on next question...)

Other Job Interview Questions

• Does a Before form trigger fire when the parameter form is suppressed?
• How do you switch to DOS prompt from SQL prompt?
• What is a Text_io Package?
• What are different types of images?
• What command would you use to encrypt a PL/SQL application?
• What is synchronize?
• What are the more common pseudo-columns?
• What are the values that can be specified for OPTIMIZER MODE Parameter?
• Explain the use of table functions.
• How would you determine who has added a row to a table?
• More...