If the DEFAULT and TEMPORARY tablespace clauses

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

(Continued from previous question...)

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

Level: Low
Expected answer: The user is assigned the SYSTEM tablespace as a default and temporary tablespace. This is bad because it causes user objects and temporary segments to be placed into the SYSTEM tablespace resulting in fragmentation and improper table placement (only data dictionary objects and the system rollback segment should be in SYSTEM).

(Continued on next question...)

Other Job Interview Questions

• What are the built-ins that are used for setting the LOV properties at runtime?
• What is the remove on exit property?
• What are the database administrators utilities available?
• When a form is invoked with call_form, Does oracle forms issues a save point?
• How do you reference a parameter indirectly?
• What is user Account in Oracle database?
• What is Object Auditing?
• What is schema?
• What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?
• Explain iostat, vmstat and netstat.
• More...