Database Management System Quiz

What is the main purpose of a database system?

• To store data in tables

• To eliminate data redundancy and ensure data integrity

• To execute programs faster

• To replace operating systems

Which of the following is a component of a DBMS?

• Query Processor

• Compiler

• Internet Browser

• Operating System

The DBMS architecture that separates data into three levels is called the:

• One-Tier Architecture

• Two-Tier Architecture

• Three-Tier Architecture

• Relational Architecture

What is Data Independence in DBMS?

• The ability to modify data without affecting programs

• Storing data in multiple formats

• Restricting unauthorized access

• Data stored in RAM instead of a hard drive

Which of the following is NOT a data model?

• Hierarchical Model

• Network Model

• Object-Oriented Model

• Java Model

The relational model represents data in the form of:

• Trees

• Graphs

• Tables

• Files

What is a constraint in a database?

• A rule that restricts data

• A backup strategy

• A security algorithm

• A type of table

Which constraint ensures that each record in a table has a unique value in a column?

• Foreign Key

• Unique Constraint

• NOT NULL Constraint

• Check Constraint

Which of the following is NOT a type of data independence?

• Logical Data Independence

• Physical Data Independence

• Procedural Data Independence

• Functional Data Independence

The term "schema" in a database refers to:

• The design and structure of a database

• The actual data stored in a database

• A backup of the database

• The programming language used