Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
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. 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
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