Top 150+ Solved Advanced Database Management Systems (ADBMS) MCQ Questions Answer
Q. The primary key is selected from the:
a. composite keys.
b. determinants.
c. candidate keys.
d. foreign keys.
Q. In the relational model, relationships between relations or tables are created by using:
a. composite keys.
b. determinants.
c. candidate keys.
d. foreign keys.
Q. A relation is considered a:
a. Column.
b. one-dimensional table.
c. two-dimensional table.
d. three-dimensional table.
Q. For some relations, changing the data can have undesirable consequences called:
a. referential integrity constraints.
b. modification anomalies.
c. normal forms.
d. transitive dependencies.
Q. One solution to the multivalued dependency constraint problem is to: split the relation into two relations, each with a single theme.
a. change the theme.
b. create a new theme.
c. add a composite key.
d. none
Q. When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):
a. transitive dependency.
b. insertion anomaly.
c. referential integrity constraint.
d. normal form.
Q. In a one-to-many relationship, the entity that is on the one side of the relationship is called a(n) ________ entity.
a. Parent
b. Child
c. Instance
d. Subtype
Q. Which of the following is the operation that is used if we are interested in only certainattributes or columns of a table?
a. SELECT
b. PROJECT
c. UNION
d. JOIN
Q. Which of the following is not a procedural language?
a. Relational Algebra
b. SQL
c. Relational calculus
d. None of the above
Q. What is the expansion of QBE?
a. Query by Example
b. Query by Experiment
c. Question before evaluation
d. None of the above
Q. Who developed Structured English Query Language?
a. E.F. Codd
b. D. Chamberlain
c. Chris Date
d. None of the above
Q. Which of the following is the first commercial RDBMS?
a. DB2
b. INGRESS
c. ORACLE
d. None of the above
Q. The ____ is used as a temporary storage area for ORDER BY or GROUP BY operations,as well as for index-creation functions.
a. sort cache
b. SQL cache
c. data cache
d. optimizer mode