Top 50+ Solved Basics of DBMS MCQ Questions Answer
Q. An ________ is a set of entities of the same type that share the same properties, orattributes.
a. Entity set
b. Attribute set
c. Relation set
d. Entity model
Q. Entity is a _________
a. Object of relation
b. Present working model
c. Thing in real world
d. Model of relation
Q. The descriptive property possessed by each entity set is _________
a. Entity
b. Attribute
c. Relation
d. Model
Q. The function that an entity plays in a relationship is called that entity’s _____________
a. Participation
b. Position
c. Role
d. Instance
Q. The attribute name could be structured as an attribute consisting of first name, middleinitial, and last name. This type of attribute is called
a. Simple attribute
b. Composite attribute
c. Multivalued attribute
d. Derived attribute
Q. In a relation between the entities the type and condition of the relation should be specified.That is called as______attribute.
a. Desciptive
b. Derived
c. Recursive
d. Relative
Q. _____________ can help us detect poor E-R design.
a. Database Design Process
b. E-R Design Process
c. Relational scheme
d. Functional dependencies
Q. Which of the following has each related entity set has its own schema and there is anadditional schema for the relationship set.
a. A many-to-many relationship set
b. A multivalued attribute of an entity set
c. A one-to-many relationship set
d. All of the mentioned
Q. In which of the following, a separate schema is created consisting of that attribute and theprimary key of the entity set.
a. A many-to-many relationship set
b. A multivalued attribute of an entity set
c. A one-to-many relationship set
d. All of the mentioned
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. Suppose the user finds the usage of room number and phone number in a relationalschema there is confusion.This is reduced by
a. Unique-role assumption
b. Unique-key assignment
c. Role intergral assignment
d. None of the mentioned
Q. Designers use which of the following to tune the performance of systems to support timecritical operations?
a. Denormalization
b. Redundant optimization
c. Optimization
d. Realization
Q. In the schema (dept name, size) we have relations total inst 2007, total inst 200Q:8) Whichdependency have lead to this relation ?
a. Dept name, year->size
b. Year->size
c. Dept name->size
d. Size->year
Q. Thus a _______ of course data gives the values of all attributes, such as title anddepartment, of all courses at a particular point in time.
a. Instance
b. Snapshot
c. Both Instance and Snapshot
d. All of the mentioned