MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 9 Mcqs, each offering curated multiple-choice questions to sharpen your Rdbms knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
The collections on which aggregate functions can operate are called as __________ |
| A. | tMultisets |
| B. | tMultivalues |
| C. | tMulticollections |
| D. | tMultivariables |
| Answer» B. tMultivalues | |
| 2. |
State true or false: There exists a division operator in Relational Algebra |
| A. | tTrue |
| B. | tFalse |
| Answer» B. tFalse | |
| 3. |
Updating, Deleting and Inserting in relational algebra is done using the ________ operator |
| A. | tAssignment |
| B. | tModification |
| C. | tAlteration |
| D. | tInclusion |
| Answer» B. tModification | |
| 4. |
customer_name, loan_number, amount (borrower loan)What does the above expression perform? |
| A. | tIt finds the customer_name, loan_number and amount from borrower |
| B. | tIt finds the customer_name, loan_number and amount from loan |
| C. | tIt finds the customer_name, loan_number and amount from the full outer join of borrower and loan |
| D. | tIt finds the customer_name, loan_number and amount from the natural join of borrower and loan |
| Answer» E. | |
| 5. |
What does the following relational algebra expression do? amount > 1200 (loan) |
| A. | tFinds all the tuples in loan |
| B. | tFinds the tuples in loan where the amount is greater than 12000 |
| C. | tFinds all the tuples in loan where the amount is greater than 1200 |
| D. | tFinds all the amounts in loan where the number of values is greater than 1200 |
| Answer» D. tFinds all the amounts in loan where the number of values is greater than 1200 | |
| 6. |
What does the following relational operation perform? x(A1,A2,A3 ) (E) |
| A. | tIt returns the result of expression E with the previous attribute names |
| B. | tIt returns the result of expression E renaming the attributes as A1, A2, |
| C. | tIt returns the result of the relation E but saves the old attributes |
| D. | tNone of the mentioned |
| Answer» C. tIt returns the result of the relation E but saves the old attributes | |
| 7. |
The project operation s function in relational algebra is identical to the _______ clause in SQL |
| A. | twhere |
| B. | tfrom |
| C. | tselect |
| D. | tnone of the mentioned |
| Answer» D. tnone of the mentioned | |
| 8. |
The select operation s function in relational algebra is identical to the _______ clause in SQL |
| A. | twhere |
| B. | tfrom |
| C. | tselect |
| D. | tnone of the mentioned |
| Answer» B. tfrom | |
| 9. |
Which of the following is not a relational algebra function? |
| A. | tSelect |
| B. | tProject |
| C. | tManipulate |
| D. | tUnion |
| Answer» D. tUnion | |