More DBA job interview questions and answers at
http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...)
You have a large table that you wish to partition to improve performance...
You have a large table that you wish to partition to improve performance. The table contains many columns of data about customers and you decide that basic information about each customer will remain in the current table. Extended information, such as shipping instructions, secretaries' names, etc. will be moved to a new table along with the PK. What type of partitioning is this?
Answer
Vertical partitioning
Explanation
If you are moving some columns from one table to a new table, this is vertical partitioning.
(Continued on next question...)