In                                index instead of storing all the columns for a record together, each column is stored separately with all other rows in an index.

Related MCQs

• In a                clustering index, the index record contains the search-key value and a pointer to the first data record with that search-key value and the rest of the records will be in the sequential pointers.
• In a _______ clustering index, the index record contains the search-key value and a pointer to the first data record with that search-key value and the rest of the records will be in the sequential pointers.
• Which of the following consists of a row of column headings, together with zero or more rows of data values?
• Instead of locking index leaf nodes in a two-phase manner, some index concurrency- control schemes use                        on individual key values, allowing other key values to be inserted or deleted from the same leaf.
•                              partitions data and parity among all N+1 disks, instead of storing data in N-disks and parity in one disk.
• A                                    index is the one which satisfies all the columns requested in the query without performing further lookup into the clustered index.
• In the SQL Cursor, which attribute is TRUE when a cursor has some remaining rows to fetch, and FALSE when a cursor has no rows left to fetch?
• What will be the number of columns of CARTESIAN PRODCUT if the participating relations have 5 and 20 rows respectively?
• Which of the following is a structure that provides faster access to the rows of a table based on the values of one or more columns?
• The database design that consists of multiple tables that are linked together through matching data stored in each table is called