Database Management System Flashcard

Front

What is the main purpose of a database system?

Back

To eliminate data redundancy and ensure data integrity

Front

Which of the following is a component of a DBMS? Query Processor, Compiler, Internet Browser, Operating System

Back

Query Processor

Front

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

Back

Three-Tier Architecture

Front

What is Data Independence in DBMS?

Back

The ability to modify data without affecting programs

Front

Which of the following is NOT a data model? Hierarchical Model, Network Model, Object-Oriented Model, Java Model

Back

Java Model

Front

The relational model represents data in the form of: Trees, Graphs, Tables, Files

Back

Tables

Front

What is a constraint in a database?

Back

A rule that restricts data

Front

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

Back

Unique Constraint

Front

Which of the following is NOT a type of data independence?
Logical Data Independence,
Physical Data Independence,
Procedural Data Independence,
Functional Data Independence

Back

Functional Data Independence

Front

The term "schema" in a database refers to:

Back

The design and structure of a database