Data Systems Fundamentals Quiz Form
Test your knowledge of data systems fundamentals. Please answer all questions to the best of your ability.
What is the primary purpose of a database management system (DBMS)?
*
To store, organize, and manage data efficiently
To design user interfaces
To write operating systems
To create network protocols
Which of the following is NOT a type of data model?
*
Hierarchical model
Relational model
Network model
Procedural model
Select all components that are typically part of a data system.
*
Hardware
Software
Procedures
Personal computers only
What does SQL stand for?
*
Which statement is used to retrieve data from a database?
*
SELECT
INSERT
UPDATE
DELETE
Explain the difference between structured and unstructured data.
*
Which of the following are examples of unstructured data? (Select all that apply)
*
Emails
Sensor readings
Social media posts
Relational database tables
Match the following terms to their definitions.
*
Rows
Definition
A unique identifier for a record in a table
Primary Key
Foreign Key
Index
Schema
A field that links to the primary key of another table
Primary Key
Foreign Key
Index
Schema
A structure that improves the speed of data retrieval
Primary Key
Foreign Key
Index
Schema
The overall design of a database
Primary Key
Foreign Key
Index
Schema
How confident are you in your knowledge of data systems fundamentals?
*
1
2
3
4
5
Briefly describe a real-world application of a data system.
*
Submit Quiz
Should be Empty: