More DBA job interview questions and answers at
http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...)
You want to partition these past orders columns into a new table. What type of partitioning is this?
You have a large table for your customers that contains the name, address, contact data, and past orders in columns. There are 24 past orders columns listed as PastOrder1, PasterOrder2, ..., PastOrder24. You want to partition these past orders columns into a new table. What type of partitioning is this?
Answer: Vertical partitioning.
Explanation: This is an example of vertical partitioning of a table. You are moving columns to a new table, which is like making a vertical slice through the table data. Both table contain the same number of rows, but different columns.
(Continued on next question...)