Test: Relational Algebra, Tuple Calculus & SQL- 1
10 Questions MCQ Test GATE Computer Science Engineering(CSE) 2023 Mock Test Series | Test: Relational Algebra, Tuple Calculus & SQL- 1
The relational algebra expression equivalent to the following expression:
is:
is:The expression
can be represented in relational algebra as
It says that select those rows from relation r where A = 10 union where B = 20.
Hence option (b) is correct.
A relation (from the relational database model) consists of a set of tuples, which implies that
Which of the following statements is correct with respect to entity integrity?
According to entity integrity primary key of relation should not contain null values.
Which of the following operations is not part of the five basic set operations in relational algebra?
Five primitive operators of Codd’s algebra are the selection, the projection the Cartesian product, the set union and the set difference.
Which of the following relational algebraic operation is not a commutative operation?
Consider a banking database with the following relation with three attributes loans (br_name, loan_no, amount).
Find the appropriate query for the given statements below:
“Find the loan number for each loan of an amount greater than 20000”
Loans (br_name, loan_no, amount)
For the query “find the loan number for each loan of an amount greater than 20000”.
We have to check for each loan to find a loan number which is greater than 20,000.
Hence (b) is the correct option.
Let R(a, b, c) and S(d, e, f) be two relations in which d is the foreign key of S that refers to the primary key of R. Consider the following four operations R and S
1. Insert into R
2. Insert into S
3. Delete from R
4. Delete from S
Which of the following is true about the referential integrity constraint above?
Referential integrity constraint: In relational model, two relation are related to each other over the basis of attributes, Every value of referencing attribute must be null or be available in the referenced attribute.
Here d is the foreign key of S that refers to the primary key of R.
1. Insert into R will not cause any violation.
2. Insert into S may cause violation because for each entry in ‘S ’ it must be. in ‘R ’ .
3. Delete from R may cause violation because for the deleted entry in R there may be referenced entry in the reIation S.
4. Delete from S will not cause any violation.
Hence (d) is the correct option.
Let r and s be two relations over the relation schemes R and S respectively, and let A be an attribute in R. Then the relational algebra expression 
is always equal to
The relational algebra expression:
Hence (c) is the required option.
Join Selectivity of a relation R in a natural join with a relation S is the _____
Which of the following is wrong?
is not equivalent because θ join is not cumulative hence the entries in 
may not be same. Hence option (d) is correct.
 |
Use Code STAYHOME200 and get INR 200 additional OFF
|
Use Coupon Code |
Recommended Content
 |
|
 |
|
 |
|
 |
|
 |
|
Recommended Tests
 |
|
|
|
|
|
|
|
|
|
Download free EduRev App
Similar Content
 |
|
 |
|
 |
|
 |
|
Related tests
|
|
|
|
|
|
|
|
|
|
|
© EduRev
|
Follow Us
|