RelationalDBDesignRelationalDBDesign


Physical Design   «Prev  Next»

Database Physical Design - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 

1. If database users often call on a few columns in a table when they create joins and views, you might be able to improve database performance using what technique?
Please select the best answer.
  A. Clustering
  B. Indexing
  C. Horizontal partitioning
  D. Vertical partitioning

2. What kind of table fields will an RDBMS index automatically?
Please select the best answer.
  A. Foreign key fields
  B. Primary key fields
  C. No fields
  D. All fields

3. Dividing records from a single table into two or more smaller tables is an example of what process?
Please select the best answer.
  A. Horizontal partitioning
  B. Vertical partitioning
  C. Indexing
  D. Clustering

4. Which definition best reflects the role of the data dictionary?
Please select the best answer.
  A. An index of values in a primary key field
  B. An index of values in all primary key fields
  C. A set of tables listing all changes to a database
  D. A set of tables defining the structure of a database

Score =
Correct answers: