Database Fundamentals Quiz

Test your knowledge of basic database concepts including fields, records, keys, and database management systems.

5 Questions Published

Questions

Question 1 Multiple Choice (Single Answer)

Where is a single element of data stored?

  1. Field
  2. Record
  3. Table
  4. Both a and b.
  5. All of the above.
Question 2 Multiple Choice (Single Answer)

Where is a collection of related data elements stored?

  1. Field
  2. Record
  3. Table
  4. Both a and b.
  5. All of the above.
Question 3 Multiple Choice (Single Answer)

Which is true about the primary key?

  1. Every table should have a primary key.
  2. A primary key exclusively identifies each row in a table.
  3. A primary key can be made of multiple fields.
  4. Both a and b.
  5. All of the above.
Question 4 Multiple Choice (Single Answer)

A foreign key:

  1. has nothing to do with the primary key.
  2. has different values than the primary key.
  3. is found in tables that don’t have a primary key.
  4. is related to the primary key of a different table.
  5. is a unique record in a table.
Question 5 Multiple Choice (Single Answer)

Which is not a program that can create a database?

  1. Access
  2. MySQL
  3. Oracle
  4. SQL Server
  5. All of the above can be used to create a database.