Loading Consent Dialog

Database Analysis   «Prev  Next»

Database Table Joins - Quiz

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

1. For a table join to produce meaningful information, the tables must be linked by what kind of fields?
Please select the best answer.
  A. Fields of the same name
  B. Fields with the same data domain
  C. Fields with equivalent data
  D. Fields that are both primary-key fields in their respective tables

2. When you link two tables with an outer join, what character does the RDBMS use to fill in empty columns when a record has no matching record in the other table?
Please select the best answer.
  A. Blank
  B. Null
  C. Zero
  D. Question mark

3. A view creates what type of tables for users to manipulate? Please select the best answer.
  A. A joined table
  B. A base table
  C. A virtual table
  D. A linked table

4. A view is stored as what type of database object?
Please select the best answer.
  A. A base table
  B. An SQL query
  C. A virtual table
  D. A relation

Correct answers:

Your Score: 0