## MCQs

Total Questions : 18 | Page 1 of 2 pages
Question 1. Which one of the following is a procedural language ?
1.    Domain relational calculus
2.    Tuple relational calculus
3.    Relational algebra
4.    Query language
Answer: Option C. -> Relational algebra

Relational algebraDomain and Tuple relational calculus are non-procedural language.Query language is a method through which the database entries can be accessed.

Question 2. The _______operation performs a set union of two "similarly structured tables
1.    Union
2.    Join
3.    Product
4.    Intersect

UnionUnion just combines all the values of relations of same attributes.

Question 3. The most commonly used operation in relational algebra for projecting a set of tuple from a relation is
1.    Join
2.    Projection
3.    Select
4.    Union

SelectSelect is used to view the tuples of the relation with or without some constraints.

Question 4. The result which operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match.
1.    Join
2.    Cartesian product
3.    Intersection
4.    Set difference
Answer: Option B. -> Cartesian product

Cartesian productCartesian product is the multiplication of all the values in the attributes.

Question 5. The_____ operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.
1.    Select
2.    Join
3.    Union
4.    Intersection

JoinJoin finds the common tuple in the relations and combines it.

Question 6. A ________ in a table represents a relationship among a set of values.
1.    Column
2.    Key
3.    Row
4.    Entry

Column has only one set of values.Keys are constraints and row is one whole set of attributes.Entry is just a piece of data.

Question 7. A relational database consists of a collection of
1.    Tables
2.    Fields
3.    Records
4.    Keys

Fields are the column of the relation or tables.Records are each row in relation.Keys are the constraints in a relation .

Question 8. The term _______ is used to refer to a row.
1.    Attribute
2.    Tuple
3.    Field
4.    Instance

TupleTuple is one entry of the relation with several attributes which are fields.

Question 9. For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.
1.    Domain
2.    Relation
3.    Set
4.    Schema

The values of the attribute should be present in the domain.Domain is a set of values permitted .

Question 10. The term attribute refers to a ___________ of a table.
1.    Record
2.    Column
3.    Tuple
4.    Key