Database Systems MCQs (DBMS, SQL) with Answers
Solved Database Systems MCQs with answers — DBMS, SQL, relational, hierarchical, object-oriented, E.F. Codd & ERP. Free quiz + PDF for PPSC, FPSC, NTS, CSS & PMS.
Database Systems — Master Reference for Pakistani Competitive Exams
The chapter Database Systems is a high-frequency Computer Science topic in Pakistan’s PPSC, FPSC, NTS, CSS, PMS, OTS, CTS, BPSC, KPPSC and SPSC One Paper exams — and is heavily tested for Computer Operator, Data Entry Operator, Lecturer (Computer Science), IT Officer and BPS-14 to BPS-17 IT-cadre posts. This page consolidates solved MCQs with answers covering the complete Database Systems syllabus — DBMS basics, flat-file vs relational vs hierarchical vs object-oriented databases, the four types of relationships (1:1, 1:N, M:1, M:N), the role of E. F. Codd as creator of the relational model, SQL (Structured Query Language) as the international standard, IDMS / CODASYL DBTG, XML in modern databases, and the most-asked DBMS products (Microsoft Access, Oracle) plus the ERP example of a multi-user database. For wider context, see the Wikipedia overview of Database and the SQL standard reference standardised by ANSI / ISO.
Database Models — Quick Comparison
| Model | Structure | Key Fact |
|---|---|---|
| Flat File | Plain text file — one record per line | Simplest form; limited relationships. |
| Relational | Multiple tables with rows & columns linked by key fields | Created by E. F. Codd. |
| Hierarchical | Tree structure — like folder architecture | Parent-child relationship. |
| Object-Oriented | Information represented as objects | Different relationship types between two or more objects. |
Four Types of Relationships in a Relational Database
| Relationship | Definition | Example |
|---|---|---|
| One-to-One | One record relates to one record in another table. | One person has one passport. |
| One-to-Many | One record relates to multiple records in another table. | One teacher teaches many students. |
| Many-to-One | Multiple records relate to one record in another table. | Many students belong to one class. |
| Many-to-Many | Multiple records relate to multiple records in another table. | Many students enrolled in many courses. |
Key Facts to Memorise
- Database — Has data and relationships; called self-describing because it contains a description of itself.
- DBMS — Database Management System; software package for creating and managing databases. Acts as an interface between the database application and the enterprise database.
- Two basic forms — Databases typically have one of two basic forms.
- Flat File Database — Stores data in a plain text file; each line typically holds one record.
- Relational Database — Multiple tables with rows & columns related through key fields. Created by E. F. Codd.
- Hierarchical Model — Resembles a tree structure, similar to a folder architecture.
- Object-Oriented Database — Information represented as objects with different relationships between objects.
- IDMS — Implemented the CODASYL DBTG model.
- Prior to 1970 — All data was stored in separate files, mostly on reels of magnetic tape.
- XML — The XML family of standards is very important in database processing today.
- SQL — Structured Query Language; an internationally recognised standard understood by all commercial DBMS products.
- Single-User Database — Only one user accesses the database at a given time.
- Multi-User Database — ERP (Enterprise Resource Planning) is a classic example.
- Microsoft Access — A DBMS that combines a DBMS and an application generator.
- Oracle — The DBMS regarded as the most difficult to use; produced by Oracle Corporation.
- Database Design — May be based on existing data.
Exam tip: Lock six anchors and you cover ~80% of all MCQs from this chapter — DBMS = software for managing databases, E. F. Codd = relational model, SQL = international standard, 4 relationship types (1:1, 1:M, M:1, M:M), ERP = multi-user example, and Self-describing database.
Frequently Asked Questions
DBMS stands for Database Management System — a software package for creating and managing databases. It acts as an interface between the database application and the database of an enterprise-class system.
E. F. Codd created the relational database model. A relational database contains multiple tables of data with rows and columns that relate to each other through special key fields.
SQL stands for Structured Query Language — an internationally recognised standard language understood by all commercial DBMS products.
A database is called self-describing because it contains a description of itself — it stores both the data and the structure (schema) that defines that data.
The four types are One-to-One (one person → one passport), One-to-Many (one teacher → many students), Many-to-One (many students → one class) and Many-to-Many (many students enrolled in many courses).
Microsoft Access is a DBMS that combines a DBMS and an application generator — easy for desktop and small-business use. Oracle is an enterprise-class DBMS by Oracle Corporation, and is regarded as the most difficult DBMS to use because of its scale and configurability.
Yes — essential. Database Systems MCQs are tested in every One Paper, NTS NAT, GAT, OTS, CTS, BPSC, KPPSC, SPSC, PPSC and FPSC exam — and very heavily for Computer Operator, DEO, Lecturer (CS) and IT-cadre posts. Expect 2–4 MCQs in any 100-mark paper, more in IT-specific posts.
Yes. Click the Download PDF button to get all Database Systems MCQs with correct answers as a branded QuizWing PDF for offline revision.