MCQ of Database Management System (DBMS) – Set 4

Database Management System - DBMS (MCQs)
Google+0
LinkedIn0
Pinterest0

This is new MCQ Questions with Answer on the category of Database Management System (DBMS). In this set you will get 10 Objective Questions with Answer related to DBMS (Database Management System). Four options are given to each question but only one option is the correct one, select your answer and tally with the given correct answer. Correct answer are given below of this Questions Set.

MCQ of Database Management System (DBMS)

Multiple Choice Questions of Database Management System (DBMS)

4-1. which of the following is not an Aggregate function?
A. Min
B. Max
C. Select
D. Avg

4-2. The attribute that can be divided into other attributes is called
A. Simple Attribute
B. Composite Attribute      
C. Multi-valued Attribute
D. Derived Attribute

4-3. In an Entity-Relationship Diagram “Ellipses” represents
A. Attributes
B. Weak entity set
C. Relationship sets
D. Multi-valued attributes

4-4. In an Entity-Relationship Diagram “Diamonds” represents
A. Attributes
B. Multi-valued attributes
C. Weak entity set
D. Relationship sets

4-5. What is ACID properties of Transactions?
A. Atomicity, Consistency, Isolation, Database
B. Atomicity, Consistency, Isolation, Durability
C. Atomicity, Consistency, Inconsistent, Durability
D. Automatically, Concurrency, Isolation, Durability

4-6. If every non-key attribute is functionally dependent on the primary key, the relation will be in
A. First Normal Form
B. Second Normal Form
C. Third Normal Form
D. Fourth Formal Form

4-7. Database locking concept is used to solve the problem of
A. Lost Update
B. Uncommitted Dependency
C. Inconsistent Data
D. All of the above

4-8. UML is stands for
A. Universal Modeling Language
B. Unified Modeling Language
C. United Modeling Language
D. Uni Modeling Language

4-9. Data Manipulation Language (DML) is not to
A. Create information table in the Database
B. Insertion of new information into the Database
C. Deletion of information in the Database
D. Modification of information in the Database

4-10. Which of the following in true regarding Referential Integrity?
A. Every primary-key value must match a primary-key value in an associated table
B. Every primary-key value must match a foreign-key value in an associated table
C. Every foreign-key value must match a primary-key value in an associated table
D. Every foreign-key value must match a foreign-key value in an associated table

 

 
Click Here for Answers

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

Related posts:

Tags: , , , , , , ,

6 Responses to “MCQ of Database Management System (DBMS) – Set 4”

  1. manisha more 15 February 2016 at 10:48 AM

    Good set of questions. but not able to copy or download

    Reply
  2. sakshi 27 May 2016 at 11:53 PM

    sir plz check question no 6……ans must be b

    Reply
  3. Devshree Zeple 11 June 2016 at 9:15 PM

    I want immediately java multiple choice questiones and answers . please I heartly requested you .

    Reply
  4. anjana 13 January 2017 at 1:13 PM

    the ans of 6 que is wrong. it is in second normal form not in third.

    Reply
  5. tushar chauhan 26 January 2017 at 12:05 PM

    6 ka answer B hona chahiye. I think galat ha 2 NF me hoga

    Reply
  6. Ahmed zeliya 30 March 2018 at 12:08 AM

    Good set of questions but no possible answers to it for self assessment

    Reply

Leave a Reply

error: Content is protected !!