Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. An abstraction concept for building composite object from their component object is called:
a. Specialization
b. Normalization
c. Generalization
d. Aggregation
Q. A set of objects that share a common structure and a common behavior is called:
a. Object
b. Class
c. Entity
d. None of these
Q. Every weak entity set can be converted into a strong entity set by:
a. using generalization
b. adding appropriate attributes
c. using aggregation
d. none of the above
Q. The number of entities to which another entity can be associated via a relationship set is expressed as:
a. Entity
b. Cardinality
c. Schema
d. Attributes
Q. The view of total database content is
a. Conceptual view.
b. Internal view.
c. External view
d. Physical view
Q. The file organization that provides very fast access to any arbitrary record of a file is:
a. Ordered file
b. Unordered file
c. Hashed file
d. B-tree
Q. What is not true about a view?
a. It is a definition of a restricted portion of the database
b. It is a security mechanism
c. It is always updatable like any other table
d. All are true
Q. Which of the following is Database Language?
a. data definition language
b. data manipulation language
c. query language
d. all of the above
Q. Which of the following in not a function of DBA?
a. network maintenance
b. routine maintenance
c. schema definition
d. authorization for data access
Q. Which of the following represents a relationship among a set of values.
a. a row
b. a table
c. a field
d. a column
Q. A Relation is a
a. subset of a cartesian product of a list of attributes
b. subset of a cartesian product of a list of domains
c. subset of a cartesian product of a list of tuple
d. subset of a cartesian product of a list of relations