A(n)____ table is a relational table with a primary key,in which the rows are stored physically in order of the primary key.
A) relational
B) index-organized
C) heap-organized
D) LOB

Question

Quizplus · Accepted Answer

An index-organized table (IOT) is a relational table with a primary key, in which the rows are stored physically in the order of the primary key. This means that IOTs are optimized for accessing data based on the primary key value, allowing for fast and efficient queries. Relational tables (option A) do not necessarily have any specific physical storage order, while heap-organized tables (option C) store rows in no particular order. LOB (option D) tables are used to store large objects, such as text and multimedia files, and are not necessarily related to primary keys or physical storage order.

A(n)____ Table Is a Relational Table with a Primary Key,in