Relational Concepts  «Prev  Next»

Database Relational Concepts - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. Which of the following is likely to result from normalizing your data?
Please select the best answer.
  A. More tables are created.
  B. Fewer tables are created.
  C. The same number of tables are created.
  D. Depending on the situation, more or less tables can be created.

2. What does a primary key define?
Please select the best answer.
  A. The relationship of data between two or more tables
  B. The quality of data in a table
  C. The columns that uniquely identify a row in a table
  D. The data that uniquely identifies a single column

3. What kind of key would you use to define which values from the primary key in Table A are valid for a column in Table B?
Please select the best answer.
  A. Primary key
  B. Unique key
  C. Identity flag
  D. Foreign key

4. Which Transact-SQL fragment would you use to test a value in the Address column to see if it is null?
Please select the best answer.
  A. Where Address = NULL
  B. Where Address IS NOT NULL
  C. Where Address IS NULL
  D. Where Address = ''

5. Which of the following is a primary reason to denormalize a database table?
Please select the best answer.
  A. To eliminate redundant data entirely
  B. To improve read performance by reducing the number of joins a query needs
  C. To guarantee referential integrity automatically
  D. To reduce the total disk space the table requires