Explain what partitioning is and what its benefi

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

(Continued from previous question...)

50. Explain what partitioning is and what its benefit is.

Partitioning is a method of taking large tables and indexes and splitting them into smaller, more manageable pieces.

(Continued on next question...)

Other Job Interview Questions

• Explicit Cursor attributes
• Can you pass data parameters to forms?
• Give two examples of how you might determine the structure of the table DEPT.
• What are the different Levels of Auditing?
• What is strip sources generate options?
• Implicit Cursor attributes
• What is a library?
• A user is getting an ORA-00942 error yet you know you have granted them permission on the table, what else should you check?
• Give two UNIX kernel parameters that effect an Oracle install
• What is an user exit used for?
• More...