Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. Entity Relationship model consists of collection of basic objects called _________ andrelationship among these objects.
a. functions
b. models
c. None of these
d. entities
Q. Which of the following gives a logical structure of the database graphically?
a. Entity-relationship diagram
b. Entity diagram
c. Database diagram
d. Architectural representation
Q. Consider a directed line(->) from the relationship set advisor to both entity sets instructorand student. This indicates _________ cardinality
a. One to many
b. One to one
c. Many to many
d. Many to one
Q. We indicate roles in E-R diagrams by labeling the lines that connect ___________ to__________
a. Diamond , diamond
b. Rectangle, diamond
c. Rectangle, rectangle
d. Diamond, rectangle
Q. An entity set that does not have sufficient attributes to form a primary key is termed a__________
a. Strong entity set
b. Variant set
c. Weak entity set
d. Variable set
Q. For a weak entity set to be meaningful, it must be associated with another entity set, calledthe
a. Identifying set
b. Owner set
c. Neighbour set
d. Strong entity set
Q. If you were collecting and storing information about your music collection, an albumwould be considered a(n) _____
a. Relation
b. Entity
c. Instance
d. Attribute
Q. What term is used to refer to a specific record in your music database; for instance;information stored about a specific album?
a. Relation
b. Instance
c. Table
d. Column
Q. If a multivalued dependency holds and is not implied by the corresponding functionaldependency, it usually arises from one of the following sources.
a. A many-to-many relationship set
b. A multivalued attribute of an entity set
c. A one-to-many relationship set
d. Both A many-to-many relationship set and A multivalued attribute of an entity set
Q. Relational Algebra is a __________ query language that takes two relations as input andproduces another relation as an output of the query.
a. Relational
b. Structural
c. Procedural
d. Fundamental
Q. For select operation the ________ appear in the subscript and the ___________ argumentappears in the paranthesis after the sigmA:)
a. Predicates, relation
b. Relation, Predicates
c. Operation, Predicates
d. Relation, Operation
Q. In precedence of set operators, the expression is evaluated from
a. Left to left
b. Left to right
c. Right to left
d. From user specification
Q. Which one of the following is a set of one or more attributes taken collectively to uniquelyidentify a record?
a. Candidate key
b. Sub key
c. Super key
d. Foreign key
Q. Consider attributes ID, CITY and NAME. Which one of this can be considered as a superkey?
a. NAME
b. ID
c. CITY
d. CITY, ID
Q. A _____ is a property of the entire relation, rather than of the individual tuples in whicheach tuple is unique.
a. Rows
b. Key
c. Attribute
d. Fields