Physical Design   «Prev  Next»

Database Design Mistakes - Quiz

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

1. Which of the following are common database mistakes associated with table columns?
Please select all the correct answers.
  A. Representing too many attributes of a business object
  B. Creating inappropriate or inaccurate constraints
  C. Including arbitrary values
  D. Duplicating fields from other tables

2. Common mistakes in creating column constraints include:
Please select all the correct answers.
  A. Duplicating constraints from other columns
  B. Attempting to represent every business rule as a column constraint
  C. Allowing duplicate values in a non-key column
  D. Typing the constraint incorrectly

3. What should you do when you name a table column?
Please select the best answer.
  A. Give each column the same name as columns that store similar information in other tables.
  B. Make the name as short as possible to save disk space.
  C. Give each column a descriptive name that briefly conveys the table and column name.
  D. Duplicate column names within a table wherever possible.