MCQ of Database Management System (DBMS) – Set 7


This is new Multiple Choice Questions (MCQ Questions) with Answer on the Category of Database Management System (DBMS). In this Question set you will get 10 Objective Questions with Answer related to DBMS (Database Management System). 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)

7-1. An attribute that is not part of any candidate key is known as
B. sub-prime attribute
A. non-prime attribute
D. sub-candidate key
C. non-candidate key

7-2. Which of the follow is not the degree of relationship?
A. Single
B. Binary
C. Ternary
D. n-ary

7-3. The degree of the relationship is
A. number of Tables in a relationship
B. number of entities in a relationship
C. number of Row & Columns in a relationship
D. number of participating entities in a relationship

7-4. How many rules in “CODD’S RULES” of Relational Model of database systems?
A. 11
B. 12
C. 13
D. 14

7-5. Every attribute has some predefined value scope that is called
A. Tuple
B. Tables
C. Attribute domain
D. Relation schema

7-6. An attribute of a table cannot hold multiple values is the property of
A. First normal form (1NF)
B. Second normal form (2NF)
C. Third normal form (3NF)
D. Fourth normal form (4NF)

7-7. A key that consists of more than one attribute to uniquely identify rows in a table is called
A. Composite key
B. Candidate key
C. Primary key
D. Foreign key

7-8. In hierarchical model, data is organized into
A. logical structure
B. physical structure
C. tree like structure
D. none of them

7-9. The key selected from the sets of candidate keys by database designer is called
A. Primary key
B. Secondary Key
C. Foreign key
D. Super key

7-10. In an Entity-Relationship diagram “Double Rectangles” represents
A. Relationship Set
B. Weak Entity Sets
C. Derived Attributes
D. Multi-valued Attributes

 


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




Incoming search terms:

  • objective questions for dbms
  • DBMS multiple choices question and answers
  • DBMS ONE WORD question and answers
  • dbms que and ans
  • basic dbms question answers in pdf multiple choice
  • questions related to dbms
  • techinical quiz for dbms
  • mcq for the dbms
  • data management in detail in mcqs
  • some very important objective question of DBMS

Leave a Reply