Database Administrator (DBA) Question:

Download Job Interview Questions and Answers PDF

Explain what partitioning is and what its benefit is.

Database Administrator (DBA) Interview Question
Database Administrator (DBA) Interview Question

Answer:

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

Download Database Administrator (DBA) Interview Questions And Answers PDF

Previous QuestionNext Question
How can you rebuild an index?You have just compiled a PL/SQL package but got errors, how would you view the errors?