DBMS MCQs Test 10

This Test will cover complete DBMS with very important questions, starting off from basics to advanced level.

Q. Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?
Q. The subset of super key is a candidate key under what condition?
Q. A __________ is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.
Q. For each attribute of a relation, there is a set of permitted values, called the __________ of that attribute.

Q. Relational Algebra is a __________ query language that takes two relation as input and produces another relation as output of the query.
Q. Which of the following is a fundamental operation in relational algebra?
Q. Which of the following is used to denote the selection operation in relational algebra?
Q. For select operation the __________ appear in the subscript and the __________ argument appears in the parenthesis after the sigma.
Q. Which one of the following cannot be taken as a Primary key?

Q. An attribute in a relation is a foreign key if the __________ key from one relation is used as an attribute in that relation.
Q. The relation with the attribute which is the Primary key is referenced in another relation. The relation which has the attribute as Primary key is called __________.
Q. A __________ integrity constraint, requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation.
Q. A Domain is atomic if elements of the domain are considered to be __________ units.
Q. Which of the following is a Unary operation?
Q. Which of the JOIN condition contains an equality operator?