DBA > Job Interview Questions > Sybase Interview Questions and Answers

Does Table Partitioning Require User-Defined Seg

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

(Continued from previous question...)

Does Table Partitioning Require User-Defined Segments in Sybase?

No. By design, each table is intrinsically assigned to one segment, called the default segment. When a table is partitioned, any partitions on that table are distributed among the devices assigned to the default segment.

In the example under "How Do I Create A Partitioned Table That Spans Multiple Devices?", the table sits on a user-defined segment that spans three devices.

(Continued on next question...)

Other Job Interview Questions