MCQ of Database Management System (DBMS) – Set 1

Database is a collection of information organized in such a way that a computer program can quickly select desired pieces of data. In this new series of Multiple Choice Question, you will get MCQ Questions related to the category of Database Management System (DBMS), this is the 1st MCQ Question set of this series.

MCQ of Database Management System (DBMS)

Multiple Choice Questions of Database Management System (DBMS)

1-1. A Database Management System (DBMS) is
A. Collection of interrelated data
B. Collection of programs to access data
C. Collection of data describing one particular enterprise
D. All of the above

1-2. Which of the following is not a level of data abstraction?
A. Physical Level
B. Critical Level      
C. Logical Level
D. View Level

1-3. Disadvantages of File systems to store data is:
A. Data redundancy and inconsistency
B. Difficulty in accessing data
C. Data isolation
D. All of the above

1-4. In an Entity-Relationship Diagram Rectangles represents
A. Entity sets
B. Attributes
C. Database
D. Tables

1-5. Which of the following is not a Storage Manager Component?
A. Transaction Manager
B. Logical Manager
C. Buffer Manager
D. File Manager

1-6. Data Manipulation Language enables users to
A. Retrieval of information stored in database
B. Insertion of new information into the database
C. Deletion of information from the database
D. All of the above

1-7. Which of the following is not an Schema?
A. Database Schema
B. Physical Schema
C. Critical Schema
D. Logical Schema

1-8. Which of the following is Database Language?
A. Data Definition Language
B. Data Manipulation Language
C. Query Language
D. All of the above

1-9. Which of the following in not a function of DBA?
A. Network Maintenance
B. Routine Maintenance
C. Schema Definition
D. Authorization for data access

1-10. Which of the following is a Data Model?
A. Entity-Relationship model
B. Relational data model
C. Object-Based data model
D. All of the above

 


 
Click Here for Answers

1 – D / 2 – B / 3 – D / 4 – A / 5 – B / 6 – D / 7 – C / 8 – D / 9 – A / 10 – D
 

13 Responses to “MCQ of Database Management System (DBMS) – Set 1”

  1. aparna 20 March 2013 at 5:08 PM

    I found this very informative and thank you

  2. alfred 21 April 2013 at 12:05 PM

    quite educative

  3. pushpa 23 October 2013 at 5:55 PM

    very interesting question…………..
    ……………….THANKU……………….

  4. manmohan singh 24 January 2014 at 10:58 AM

    please publish more mcq of dbms

  5. Raghunath Nagraj 20 July 2014 at 12:05 PM

    Its very coo;l

  6. Raghunath Nagraj 20 July 2014 at 12:06 PM

    Its very coollll

  7. Gurpreet 8 December 2014 at 3:23 AM

    Can i get the answers for these mcq’s.

  8. deepjyoti talukdar 26 April 2015 at 8:15 PM

    Really nice collection of questions for ones preparing for competitive exams.
    Thanks a lot to u.Keep it up Ganesh.

  9. hussein 12 August 2015 at 12:32 AM

    thank you all sets are very very good thanks so much

  10. chris 6 October 2015 at 7:36 AM

    very good summary

  11. anik 2 February 2017 at 8:54 PM

    I found this very helpful,as our DBMS lab manual contains same questions

  12. Mehtab 3 February 2017 at 11:35 AM

    very good information and need more these type of mcqs

  13. Afreen 9 September 2018 at 1:22 PM

    Thank you for these mcqs..it helps me a lot


Leave a Reply

error: Content is protected !!