Q. The database design that consists of multiple tables that are linked together through matching data stored in each table is called

View solution

Q. The association role defines:

View solution

Q. The purpose of an N-Ary association is:

View solution

Q. Bitmap indices are a specialized type of index designed for easy querying on ___________

View solution

Q. A _______ on the attribute A of relation r consists of one bitmap for each value that A can take.

View solution

Q. SELECT *
FROM r
WHERE gender = ’f’ AND income level = ’L2’;

In this selection, we fetch the bitmaps for gender value f and the bitmap for income level value L2, and perform an ________ of the two bitmaps.

View solution

Q. To identify the deleted records we use the ______________

View solution

Q. Bitmaps can be used as a compressed storage mechanism at the leaf nodes of ________ for those values that occur very frequently.

View solution

Q. Bitmaps can be combined with regular B+-tree indices for relations where a few attribute values are extremely common, and other values also occur, but much less frequently.

View solution

Q. In a B+-tree index ______ for each value we would normally maintain a list of all records with that value for the indexed attribute.

View solution

Q. If an index is _________________ the metadata and statistics continue to exists

View solution