Database Systems Quiz

What is the primary purpose of a database?

• To store and manage data efficiently

• To create websites

• To run operating systems

• To write documents

Which of the following is NOT a type of database model?

• Relational

• Hierarchical

• Circular

• Network

What does DBMS stand for?

• Data Backup and Management System

• Database Management System

• Data-Based Management Software

• Digital Backup and Maintenance Software

In a relational database, what is a primary key?

• A unique identifier for a record

• A duplicate entry in a table

• A link between two different tables

• A non-essential attribute

What does SQL stand for?

• Structured Query Language

• Sequential Query Logic

• Standard Question Language

• Software Query List

What is the purpose of normalization in databases?

• To reduce redundancy

• To slow down queries

• To create more tables

• To duplicate data

What does ACID stand for in database transactions?

• Atomicity, Consistency, Isolation, Durability

• Automation, Control, Integrity, Data

• Allocation, Computation, Indexing, Dependency

• Access, Calculation, Integration, Deletion

Which of the following is a NoSQL database type?

• Document-based

• Relational

• Hierarchical

• Network

Which of the following is NOT a function of DBMS?

• Data storage

• Query processing

• Word processing

• Data security

What is an index in a database?

• A unique identifier

• A structure that improves search performance

• A duplicate data entry

• A foreign key constraint