DBMS MCQs

Test your understanding of Database Management Systems (DBMS) with our comprehensive MCQs. Covering data modeling concepts, RDBMS, SQL queries, normalization, transactions, database security, and more, our MCQs are perfect for students and professionals seeking to enhance their DBMS knowledge. Start practicing now to sharpen your skills 

1.  DBMS stands for -
    A.  Database Management Service
    B.  Database Management System
    C.  Data Backup Management System
    D.  None of these

2.  Which type of data can be stored in database ?
    A.  Image
    B.  Text files
    C.  Data in the form of audio or video
    D.  All of the above

3.  The database schema is written in -
    A.  HLL
    B.  DDL
    C.  DML
    D.  DCL

4.  Realtional calculus is a -
    A.  Procedural language
    B.  Non- procedural language
    C.  Data definition language
    D.  High level language

5.  In an ER diagram, attributes are represented by -
    A.  Rectangle
    B.  Square
    C.  Ellipse
    D.  Triangle

6.  In a hierarchical model records are organized as -
    A.  Graph
    B.  List
    C.  Links
    D.  Tree

7.  Generalization is ........... process.
    A.  Top down
    B.  Bottom up
    C.  Both (A) and (B)
    D.  None of these

8.  Specialization is ........... process.
    A.  Top down
    B.  Bottom up
    C.  Both (A) and (B)
    D.  None of these

9.  Cartesian product in relational algebra is -
    A.  A unary operator
    B.  A binary operator
    C.  A ternary operator
    D.  None of these

10.  Which of the following is not a type of database ?
    A.  Network
    B.  Hierarchical
    C.  Distribued
    D.  All of the above

11.  An entity relationship diagram is tool to represent -
    A.  Data model
    B.  Event model
    C.  Process Model
    D.  None of these

12.  Which of the following is an optimistic concurrency control method?
    A.  Validation based
    B.  Lock based
    C.  Timestamp Ordering
    D.  None of these

13.  ER model uses this symbol to represent weak entity set -
    A.  Dotted rectangle
    B.  Diamond
    C.  Doubly outlined rectangle
    D.  None of these

14.  An entity set that does not have sufficient attributes for form a primary key is a -
    A.  Strong entity set
    B.  Weak entity set
    C.  Simple entity set
    D.  Primary entity set

15.  Which of  the following is not an example of DBMS -

    A.  Microsoft Acess
    B.  MySQL
    C.  PostgreSQL
    D.  Google

16.  Which of the following is not a feature of DBMS -
    A.  Support ACID property
    B.  Single user access only
    C.  Minimum duplication and redundancy of data
    D.  Data backup and recovery

17.  The command to eliminate a table  from a database-
    A.  Drop Table < table name>
    B.  Delete Table < table name>
    C.  Remove Table < table name>
    D.  Update Table < table name>

18.  DBA stands for -
    A.  Database action 
    B.  Database administrator
    C.  Data bank administrator
    D.  None of these

19.  Command used to add records to a table is -
    A.  Insert
    B.  Add
    C.  Update
    D.  Select

20.  Which of the following is not a unary operation -
    A.  Select
    B.  Project
    C.  Rename
    D.  Union

21.  DFD stands for -
    A.  Data file diagram
    B.  Data flow diagram
    C.  Data file Document
    D.  None of these

22.  Who developed the concept of normalization -
    A.  F E Codd
    B.  E F Codd
    C.  R S Codd
    D.  None of these

23.  The full form of BCNF is -
    A.  Boyce codd normal form
    B.  Basic codd normal form
    C.  Binary code normal form
    D.  None of these

24.  The primary key should be -
    A.  Unique
    B.  Not null
    C.  Both (A) and (B)
    D.  None of the above

25.  When a relation is in 2NF and there is ............, it is in 3NF -
    A.  Transitive dependency
    B.  No transitive dependency
    C.  Relational dependency
    D.  No relational dependency

26.  A table is in  ........ , if it is in BCNF and it contains no multi-valued dependencies -
    A.  4NF
    B.  5NF
    C.  DCNF
    D.  RCNF

27.  When a relation is in 2NF and there is ............, it is in 3NF -
    A.  Transitive dependency
    B.  No transitive dependency
    C.  Relational dependency
    D.  No relational dependency

28.  The process of restoring the data to its previous state afer an incident of data failur is known as   -
    A.  Data replication 
    B.  Data validation
    C.  Data recovery
    D.  Data control

29.  What is a 'tuple' -
    A.  Another name for a table in RDBMS 
    B.  A row or record in a database table
    C.  An attribute attached to a record
    D.  All of the above

30.  Attributes refers to -
    A.  The properties of an entity 
    B.  The name of an entity
    C.  Both (A) and (B) are correct
    D.  None of the  above

31.  The Data Control Language (DCL)-
    A.  is used to manage user access to database
    B.  is used to manipulate the contents of daabasei n some form
    C.  Both (A) and (B) 
    D.  None of the  above