Database Concepts Quiz

What is the smallest unit of data that a user can access?

• File

• Record

• Field

• Database

Which of the following best defines information?

• Raw facts

• Organized and meaningful data

• Data stored in a database

• A set of unrelated facts

What does DBMS stand for?

• Data Backup Management System

• Database Management System

• Data Block Modeling System

• Database Backup Maintenance System

What is the purpose of a primary key in a database?

• To allow duplicate records

• To uniquely identify each record

• To store large amounts of data

• To improve data redundancy

Which type of database supports only one user at a time?

• Multi-user

• Workgroup

• Enterprise

• Single-user

Which database model represents data in a tree-like structure?

• Relational model

• Hierarchical model

• Object-oriented model

• Network model

What is the function of a data dictionary?

• To store actual database data

• To contain metadata about data files and fields

• To serve as a backup database

• To provide user access control

What does SQL stand for?

• Structured Query Language

• System Query Logic

• Standard Query Logic

• System Query Language

Which of the following is an advantage of using a database over a file processing system?

• Increased data redundancy

• Less secure data storage

• Improved data integrity

• Slower data retrieval

What is data redundancy?

• Data stored in multiple locations unnecessarily

• Data that is missing from a database

• Data that has been validated

• Data that is structured incorrectly