Database Management Systems – Multiple Choice Questions (MCQs)

1. 1. What does DBMS stand for?

   • A. Data Base Management System
   • B. Database Machine System
   • C. Data Backup Management System
   • D. Digital Base Management System

2. 2. Which of the following is a core component of a DBMS?

   • A. Hardware
   • B. Software
   • C. Data
   • D. Users

3. 3. What is a database?

   • A. An organized collection of related data
   • B. A collection of programs
   • C. A set of instructions
   • D. A computer network

4. 4. What is a relational database?

   • A. A database that stores data in tables with rows and columns
   • B. A database that stores data in a hierarchical structure
   • C. A database that stores data as key-value pairs
   • D. A database that stores data in a network structure

5. 5. What is a table in a relational database?

   • A. A collection of related records
   • B. A single piece of data
   • C. A set of queries
   • D. A database schema

6. 6. What is a row (tuple) in a table?

   • A. A single attribute of an entity
   • B. A collection of related attributes representing one instance of an entity
   • C. A constraint on the data
   • D. A relationship between tables

7. 7. What is a column (attribute) in a table?

   • A. A single piece of data
   • B. A characteristic or property of an entity
   • C. A relationship between tables
   • D. A constraint on the data

8. 8. What is a primary key?

   • A. A column or set of columns that uniquely identifies each row in a table
   • B. A foreign key
   • C. A candidate key that is not chosen as the primary key
   • D. A column used for sorting data

9. 9. What is a foreign key?

   • A. A primary key from another table used to establish a relationship between the two tables
   • B. A primary key within the same table
   • C. A column that allows null values
   • D. A column used for indexing

10. 10. What is a candidate key?

    • A. A column or set of columns that can uniquely identify each row in a table
    • B. A primary key
    • C. A foreign key
    • D. A super key that does not contain any redundant attributes

11. 11. What is a super key?

    • A. A column or set of columns that uniquely identifies each row in a table
    • B. A candidate key
    • C. A primary key
    • D. Any set of attributes that uniquely identifies each tuple

12. 12. What is a composite key?

    • A. A primary key that consists of more than one attribute
    • B. A foreign key that consists of more than one attribute
    • C. A candidate key that consists of a single attribute
    • D. A super key with no redundant attributes