Question 1
Marks : +2 | -2
Pass Ratio : 100%
What is the method of specifying a primary key in a schema description?
Explanation: We can specify a primary key in schema description by underlining the respective attribute with a bold line.
Question 2
Marks : +2 | -2
Pass Ratio : 100%
Choose the option that correctly explains in words, the function of the following relational algebra expression
Explanation: The condition under the select statement represents the condition that must be satisfied by the tuples and the symbol ⋈ represents natural join between the two relations on either side of the operator.
Question 4
Marks : +2 | -2
Pass Ratio : 100%
What does the “x†operator do in relational algebra?
Explanation: The “x†operator outputs all pairs of rows from the two input relations (regardless of whether or not they have the same values on common attributes). This operation is called as the Cartesian product operation and is similar to the Cartesian product of sets.
Question 5
Marks : +2 | -2
Pass Ratio : 100%
Explanation: A foreign key is an attribute of a relation that is initially a primary key of another relation. A foreign key usage preserves referential integrity.
Question 7
Marks : +2 | -2
Pass Ratio : 100%
Statement 1: A tuple is a row in a relation
Explanation: A tuple is a row is a relation. There can exist multiple foreign keys in the same relation because there can exist multiple attributes in the relation that are primary keys in two or more other relations.
Question 8
Marks : +2 | -2
Pass Ratio : 100%
What action does ⋈ operator perform in relational algebra
Explanation: ⋈ Outputs specified attributes from all rows of the input relation. Remove duplicate tuples from the output. The operation is called the join operation.
Question 9
Marks : +2 | -2
Pass Ratio : 100%
What is an Instance of a Database?
Explanation: The state of the database system at any given point of time is called as an Instance of the database.
Question 10
Marks : +2 | -2
Pass Ratio : 100%
Choose the correct statement regarding superkeys
Explanation: A superkey is an attribute or a set of multiple attributes that can uniquely identify a tuple. It is used to differentiate between tuples.