Q.1.
Two basic constructs to link one piece of data with another piece of data: sequential storage and pointers.
Q.2.
Some advantages of partitioning include: efficiency, security, and load balancing.
Q.3.
A pointer is a detailed coding scheme recognized by system software for representing organizational data.
Q.4.
Denormalization and clustering can work well to minimize data access time for small records.
Q.5.
Hashing algorithm converts a primary key value into a record address.
Q.6.
Distributing the columns of a table into several separate physical records is known as horizontal partitioning.
Q.7.
The primary goal of physical database design is data processing efficiency.
Q.8.
A bitmap index is an index on columns from two or more tables that come from the same domain of values.
Q.9.
A secondary key is which of the following?
Q.10.
The fastest read/write time and most efficient data storage of any disk array type is:
Q.11.
A rule of thumb for choosing indexes for a relational database includes which of the following?
Q.12.
Sequential retrieval on a primary key for sequential file storage has which of the following features?
Q.13.
A multidimensional database model is used most often in which of the following models?
Q.14.
The blocking factor is:
Q.15.
Which of the following improves a query's processing time?
Q.16.
Which of the following are integrity controls that a DBMS may support?
Q.17.
Which of the following is not a factor to consider when switching from small to large block size?
Q.18.
What is the best data type definition for Oracle when a field is alphanumeric and has a fixed length?
Q.19.
An extent is a contiguous section of disk storage space.
Q.20.
The three newest database architectures in use today are relational, multidimensional and hierarchical.