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.
0 h : 0 m : 1 s