MCQ of Database Management System (DBMS) – Set 6

This is new Objective Questions with Answer on the Category of DBMS (Database Management System). In this Question set you will get 10 Multiple Choice Questions (MCQ Questions) with Answer related to Database Management System (DBMS). Four options are given to the each question and only one options is the correct one. Select your option and check with given correct answer. Correct answer are given the below of this questions set.

MCQ of Database Management System (DBMS)

Multiple Choice Questions of Database Management System (DBMS)

6-1. The minimal set of super key is called
A. Primary key
B. Secondary key
C. Candidate key
D. Foreign key

6-2. A relation that has no partial dependencies is in which normal form
A. First
B. Second
C. Third
D. BCNF

6-3. A functional dependency between two or more non-key attributes is called
A. Transitive dependency
B. Partial transitive dependency
C. Functional dependency
D. Partial functional dependency

6-4. A logical description of some portion of database that is required by a user to perform task is called as
A. System View
B. User View
C. Logical View
D. Data View

6-5. ______________ is a classical approach to database design?
A. Left – Right approach
B. Right – Left approach
C. Top – Down approach
D. Bottom – Up approach

6-6. _____________ refers to the correctness and completeness of the data in a database?
A. Data security
B. Data integrity
C. Data constraint
D. Data independence

6-7. A table that displays data redundancies yields ____________ anomalies
A. Insertion
B. Deletion
C. Update
D. All of the above

6-8. A lock that allows concurrent transactions to access different rows of the same table is known as a
A. Field-level lock
B. Row-level lock
C. Table-level lock
D. Database-level lock

6-9. A type of query that is placed within a WHERE or HAVING clause of another query is called
A. Super query
B. Sub query
C. Master query
D. Multi-query

6-10. A transaction completes its execution is said to be
A. Saved
B. Loaded
C. Rolled
D. Committed

 


 
Click Here for Answers

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

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

  1. Narayan 23 December 2014 at 7:40 PM

    Its nice collection

  2. sanket gupta 29 September 2015 at 12:43 PM

    sir it is very helpful for me in my exam
    try tro upload these type of question
    thank you sir

  3. irfan 19 January 2016 at 10:38 PM

    very nice . Thank You sir

  4. very helpful package 14 February 2016 at 7:11 PM

    The collection is very good preparatory material for students who wants to write exam

  5. jojo miranda 2 March 2016 at 11:03 PM

    These are nice sets of questions indeed. Thank you and more power!

  6. jojo miranda 2 March 2016 at 11:03 PM

    These are nice sets of questions indeed. Thank you and more power!

  7. Devshree Zeple 11 June 2016 at 9:36 PM

    I want and needed Java Multiple Choice Questions And Answer . please I am requested you .

  8. azaim 2 August 2016 at 1:50 PM

    great efforts
    thanks bro

  9. Khansa Qurysh 25 January 2017 at 12:46 AM

    This helps greatly!!
    #satisfied

  10. wisal ahmad 25 August 2017 at 11:10 PM

    it is very helpful but sir it is not copy to the ms office

  11. hussain 5 May 2018 at 5:15 PM

    Hi sir, material is good but one thing i need to inform you that 8th question is row-level not field-level. I searched in one more website. if you add some more words to question it is right.
    please see the below question

    The ____ lock allows concurrent transactions to access the same row as long as they require the use of different fields within that row.
    a) Table-level
    b) Page-level
    c) Row-level
    d) Field-level
    View Answer

    Answer: d
    Explanation: Lock is limited to the attributes of the relation.

    A lock that allows concurrent transactions to access different rows of the same table is known as a
    a) Database-level lock
    b) Table-level lock
    c) Page-level lock
    d) Row-level lock
    View Answer

    Answer: d
    Explanation: Locks are used to maintain database consistency.

  12. Own Muhammad 8 June 2020 at 12:21 AM

    Good collection đź‘Ť very helpful McQ

  13. ahmed 10 May 2021 at 1:28 PM

    Hi

  14. Amit 6 September 2021 at 12:26 PM

    It is really easy, and nice to navigate

  15. Deepa 6 September 2021 at 12:28 PM

    Very impressive


Leave a Reply

error: Content is protected !!