What does the following relational algebra expression do?σamount > 1 – McqOptions

MCQOPTIONS

1.	What does the following relational algebra expression do?σamount > 1200 (loan)
A.	Finds all the tuples in loan
B.	Finds the tuples in loan where the amount is greater than 12000
C.	Finds all the tuples in loan where the amount is greater than 1200
D.	Finds all the amounts in loan where the number of values is greater than 1200
Answer» D. Finds all the amounts in loan where the number of values is greater than 1200

Discussion

No Comment Found

Related MCQs

The collections on which aggregate functions can operate are called as __________
State true or false: There exists a division operator in Relational Algebra
Updating, Deleting and Inserting in relational algebra is done using the ________ operator
Πcustomer_name, loan_number, amount (borrower ⋈loan)What does the above expression perform?
What does the following relational algebra expression do?σamount > 1200 (loan)
What does the following relational operation perform?ρx(A1,A2,A3…) (E)
The project operation’s function in relational algebra is identical to the _______ clause in SQL
The select operation’s function in relational algebra is identical to the _______ clause in SQL
Which of the following is not a relational algebra function?
UPDATING,_DELETING_AND_INSERTING_IN_RELATIONAL_ALGEBRA_IS_DONE_USING_THE__________OPERATOR?$