You create ____ tables when a table contains a lot of records,and you want to store the data across multiple datafiles to improve database performance.
A)segmented
B)extended
C)automatic
D)partitioned

Question

Quizplus · Accepted Answer

Partitioning a table allows you to split it into smaller, more manageable pieces called partitions. This can greatly improve query performance because it enables the database to access only the information it needs. Additionally, partitioning can be used to spread the table over many physical disks, which can improve I/O performance.

You Create ____ Tables When a Table Contains a Lot