Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. A lock that allows concurrent transactions to access different rows of the same table is known as a
a. field-level lock
b. row-level lock
c. table-level lock
d. database-level lock
Q. A type of query that is placed within a WHERE or HAVING clause of another query is called
a. super query
b. sub query
c. master query
d. multi-query
Q. For each attribute of a relation, there is a set of permitted values, called the of that attribute.
a. domain
b. relation
c. set
d. schema
Q. Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?
a. candidate key
b. sub key
c. super key
d. foreign key
Q. Consider attributes ID, CITY and NAME. Which one of this can be considered as a super key?
a. name
b. id
c. city
d. city, id
Q. A is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.
a. rows
b. key
c. attribute
d. fields
Q. An attribute in a relation is a foreign key if the key from one relation is used as an attribute in that relation.
a. candidate
b. primary
c. super
d. sub
Q. The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as a primary key is called
a. referential relation
b. referencing relation
c. referenced relation
d. referred relation
Q. The is the one in which the primary key of one relation is used as a normal attribute in another relation.
a. referential relation
b. referencing relation
c. referenced relation
d. referred relation
Q. The operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.
a. select
b. join
c. union
d. intersection
Q. The operation performs a set union of two “similarly structured” tables
a. union
b. join
c. product
d. intersect
Q. The most commonly used operation in relational algebra for projecting a set of tuple from a relation is
a. join
b. projection
c. select
d. union