Module 1 Final Quiz: Introduction to DBMS MCQs

1

What is the primary operational defect of traditional file processing systems that DBMS was engineered to eliminate?

A. Inability to print documents on physical paper

B. Data redundancy, data inconsistency, uncoordinated concurrent access, and absence of atomicity/isolation guarantees

C. Lack of internet connectivity

D. Slow CPU processing speed

2

Which tier of the ANSI/SPARC Three-Schema Architecture defines how data is physically laid out on disk blocks, storage tracks, and indices?

A. External Schema (View Level)

B. Conceptual Schema (Logical Level)

C. Internal Schema (Physical Level)

D. Network Schema

3

What is Logical Data Independence in database architecture?

A. The capacity to change the internal physical storage structures without having to modify external views

B. The capacity to modify the conceptual schema (e.g. adding new tables or attributes) without having to alter existing external schemas or rewrite application programs

C. The ability to run queries without a CPU

D. The separation of hardware servers from power grids

4

Which is harder to achieve: Physical Data Independence or Logical Data Independence?

A. Physical Data Independence is much harder

B. Logical Data Independence is much harder, because applications are tightly coupled to the logical structure of the data they query

C. They are identically difficult

D. Neither exists in modern databases

5

What component in a DBMS architecture is responsible for ensuring ACID properties across system crashes?

A. Query Parser and Lexer

B. Transaction Manager and Recovery Manager (using WAL logs)

C. Data Dictionary Catalog

D. Buffer Pool Replacement Policy

6

What is the Data Dictionary (or System Catalog) in a DBMS?

A. A spelling dictionary for SQL error messages

B. A set of internal database tables that stores metadata describing the schemas, tables, columns, constraints, users, and privileges

C. A collection of temporary user tables

D. The binary executable file of the database server

7

What is the primary role of a Database Administrator (DBA)?

A. Writing frontend JavaScript and HTML templates

B. Schema definition, security and authorization management, performance tuning, indexing, and backup & disaster recovery planning

C. Designing physical CPU microcode

D. Manufacturing hard drive platters

8

How does a Declarative query language (like SQL) differ from a Procedural query language (like C or relational algebra)?

A. Declarative specifies HOW to retrieve data; Procedural specifies WHAT data to retrieve

B. Declarative specifies WHAT data to retrieve without dictating the step-by-step physical algorithms; Procedural specifies step-by-step loops and access paths

C. Declarative languages are compiled; Procedural languages are interpreted

D. Declarative languages cannot filter data

9

In the client-server DBMS architecture, what role does ODBC/JDBC play?

A. It acts as a hardware disk controller

B. It provides standardized middleware APIs enabling client application code to connect, submit SQL statements, and retrieve result sets from diverse database engines

C. It encrypts RAM registers

D. It replaces the SQL compiler

10

Which of the following database models organizes data into a hierarchy of tree-like parent-child records?

A. Relational Model

B. Hierarchical Model (e.g. IBM IMS)

C. Network Model (CODASYL)

D. Object-Oriented Model

11

Why does a DBMS buffer manager keep a cache of database pages in RAM instead of reading disk on every query?

A. RAM storage is cheaper than disk storage

B. RAM access latency (~100 nanoseconds) is roughly 100,000 times faster than mechanical or SSD disk I/O (~milliseconds), drastically improving query throughput

C. Disk memory is volatile and loses data on power off

D. CPUs cannot read from disk controllers

Question Palette

Quick Actions

Question Discussion #1

Report Issue · Question #1

Yukti