DBMS Foundations: 32 MCQs with answers

Physical Level

The Physical Level is the lowest level of abstraction and describes how data is actually stored on storage devices, including file organization, indexing, and hashing.

View Level

The View Level shows only part of the database to specific users based on their role, providing customized views and security.

Data Independence

The Three-Schema Architecture provides data independence, allowing changes at one level without affecting other levels.

What data is stored and its relationships

The Logical Level describes what data is stored, including tables, columns, relationships, and constraints.

Ordinary User

Ordinary users never interact with the Physical Level; only DBA, System Programmers, and DBMS Developers use it.

Improved security

The View Level provides security by hiding sensitive data from unauthorized users and simplifies usage by showing only relevant information.

False

The View Level is the highest level of abstraction; the Physical Level is the lowest.

—

This is the fundamental concept of the topic.

—

It's about how data is actually stored on disk.

—

This level is hidden from normal users.

—

Different users see different views based on their role.

—

You can change storage techniques without breaking existing code.

—

You can add or modify tables without breaking user views.

—

It provides data independence and security.

Interprets and executes SQL commands

The Query Processor interprets, optimizes, and executes SQL commands, acting as the brain of the DBMS.

Three-Tier Architecture

Three-Tier Architecture divides the system into three layers: Client, Application Server, and Database Server.

Transfers data between memory and disk

The Buffer Manager transfers data between memory and disk, keeping frequently used data in memory for faster access.

Atomicity

Atomicity ensures all operations in a transaction are performed completely or none are performed.

True

Logical Data Independence is harder because changes to the logical schema can affect user views and applications.

—

The application server acts as a middle layer.

—

They ensure data accuracy and consistency.

—

If any step fails, the whole transaction is cancelled.

—

It includes sub-components like File Manager and Buffer Manager.

—

It improves retrieval speed.

—

It converts user queries into instructions the DBMS can understand.

—

It's the foundation for database design.

—

Schema is like a building plan; instance is like the people living inside.

Physical changes storage, logical changes structure

Physical Data Independence changes storage without affecting logical structure; Logical Data Independence changes logical schema without affecting views.

The whole transaction is cancelled

Atomicity ensures that if any step fails, the whole transaction is cancelled, maintaining data consistency.

Better security

Three-Tier Architecture provides better security because users cannot directly access the database; the application server acts as a barrier.

Manages database transactions and maintains consistency

The Transaction Manager controls database transactions and ensures ACID properties are maintained.

Changing from heap file to B+ tree indexing

Physical Data Independence allows changing storage structures like file organization without affecting the logical schema or applications.