How do you set up tablespaces during an Oracle i

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

(Continued from previous question...)

How do you set up tablespaces during an Oracle installation?

Level: Low
Expected answer: You should always attempt to use the Oracle Flexible Architecture standard or another partitioning scheme to ensure proper separation of SYSTEM, ROLLBACK, REDO LOG, DATA, TEMPORARY and INDEX segments.

(Continued on next question...)

Other Job Interview Questions

• What is WHEN-Database-record trigger?
• What are the different windows events activated at runtimes?
• What view would you use to look at the size of a data file?
• To execute row from being displayed that still use column in the row which property can be used?
• What is Parallel Server?
• What is an anchoring object and what is its use?
• What are the different default triggers created when Master Deletes Property is set to Cascade?
• What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode?
• You have just compiled a PL/SQL package but got errors, how would you view the errors?
• What is strip sources generate options?
• More...