Top 50+ Solved Basics of DBMS MCQ Questions Answer
Q. Representations such as the in the dept year relation, with one column for each value of an attribute, are called _______ they are widely used in spreadsheets and reports and in data analysis tools.
a. Cross-tabs
b. Snapshot
c. Both Cross-tabs and Snapshot
d. All of the mentioned
Q. Data Model is collection of conceptual tools for describing -
a. Data
b. All of these
c. Data Schema
d. Consistency Constaints
Q. Object based logical model(s) are used to describe data at - [Select Appropriate Option(s)]
a. View Level
b. Logical Level
c. Physical Level
d. None of these
Q. Which of the following is example of Object based logical model ?
a. Relational Model
b. Hierarchical Model
c. Network Model
d. Entity Relationship Model
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