Database Fundamentals Quiz
Test your knowledge of basic database concepts including fields, records, keys, and database management systems.
Questions
Question 1 Multiple Choice (Single Answer)
Where is a single element of data stored?
- Field
- Record
- Table
- Both a and b.
- All of the above.
Question 2 Multiple Choice (Single Answer)
Where is a collection of related data elements stored?
- Field
- Record
- Table
- Both a and b.
- All of the above.
Question 3 Multiple Choice (Single Answer)
Which is true about the primary key?
- Every table should have a primary key.
- A primary key exclusively identifies each row in a table.
- A primary key can be made of multiple fields.
- Both a and b.
- All of the above.
Question 4 Multiple Choice (Single Answer)
A foreign key:
- has nothing to do with the primary key.
- has different values than the primary key.
- is found in tables that don’t have a primary key.
- is related to the primary key of a different table.
- is a unique record in a table.
Question 5 Multiple Choice (Single Answer)
Which is not a program that can create a database?
- Access
- MySQL
- Oracle
- SQL Server
- All of the above can be used to create a database.