MCQs on Database Management Systems

Which of the following is NOT a characteristic of a database system?

• Data redundancy

• Data consistency

• Data isolation

• Data abstraction

In a database system, the term 'schema' refers to:

• A snapshot of the data at a particular instant

• The physical structure of the database

• The overall logical structure of the database

• The data types used in the database

Which architecture is designed to promote data independence in a DBMS?

• Two-tier architecture

• Three-tier architecture

• Single-tier architecture

• Multi-tier architecture

The three levels of the DBMS architecture are:

• Physical, Conceptual, External

• Physical, Logical, Relational

• Schema, Instance, Data

• Client, Server, Cloud

Which of the following is an example of a logical data model?

• ER model

• Network model

• Relational model

• File system model

What is the main advantage of a DBMS over a file system?

• Easy data entry

• More security features

• No need for backup

• Faster access to data

An entity set is:

• A collection of similar entities

• A set of attributes

• A relationship between entities

• A table with no primary key

Which of the following data independence types refers to immunity of application programs to changes in physical storage structure?

• Logical data independence

• Physical data independence

• Conceptual data independence

• External data independence

In an ER diagram, a relationship set is represented by:

• A rectangle

• A diamond

• An ellipse

• A line

A centralized database architecture means:

• Data is distributed among multiple servers

• Data resides in a single location

• Data is stored on the cloud

• Data is replicated across servers