MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 24 Mcqs, each offering curated multiple-choice questions to sharpen your Rdbms knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Which of the following correctly describes the between predicate in the where clause? |
| A. | It is used to check whether a value is in between two specified values |
| B. | It is used to check whether a value is exactly in the center of the relation alphabetically |
| C. | It is used to check whether a value is in between any two other values in the database |
| D. | None of the mentioned |
| Answer» B. It is used to check whether a value is exactly in the center of the relation alphabetically | |
| 2. |
What will be the result of the following query? |
| A. | All the values of the studentid for which section is c and roll < 10 |
| B. | All the values of the studentid for which section is c and roll > 10 |
| C. | All the values of the studentid for which section not c and roll < 10 |
| D. | All the values of the studentid for which section not c and roll > 10View Answer |
| Answer» C. All the values of the studentid for which section not c and roll < 10 | |
| 3. |
Observe the following query and choose the correct option |
| A. | The query is syntactically wrong |
| B. | The query gives all the possible student names where a finite value exists for ID |
| C. | The query gives the names of the students that have a null ID and it also excludes identical names |
| D. | The query gives the student names where a finite value exists for ID and it excludes identical namesView Answer |
| Answer» E. | |
| 4. |
What is the function of the except operation? |
| A. | It excludes all the results present in both the queries |
| B. | It includes the results of the second query but excludes the results of the first query |
| C. | It includes the results of the first query but excludes the results of the second query |
| D. | It includes all the results of both queries but removes duplicates |
| Answer» D. It includes all the results of both queries but removes duplicates | |
| 5. |
THE_BIT_STRINGS_FOR_THE_SETS_ARE_1111100000_AND_1010101010._THE_UNION_OF_THESE_SETS_IS____________?$ |
| A. | 1010100000 |
| B. | 1010101101 |
| C. | 1111111100 |
| D. | 1111101010 |
| Answer» E. | |
| 6. |
THE_NUMBER_OF_ATTRIBUTES_IN_RELATION_IS_CALLED_AS_ITS?$ |
| A. | Cardinality |
| B. | Degree |
| C. | Tuples |
| D. | Entity |
| Answer» C. Tuples | |
| 7. |
The set difference of the set A with null set is __________$ |
| A. | A |
| B. | null |
| C. | U |
| D. | B |
| Answer» B. null | |
| 8. |
______clause_is_an_additional_filter_that_is_applied_to_the_result.$ |
| A. | Select |
| B. | Group-by |
| C. | Having |
| D. | Order by |
| Answer» B. Group-by | |
| 9. |
Let Ai = {i, i+1, i+2, …..}. Then set {n, n+1, n+2, n+3, …..} is the _________ of the set Ai?# |
| A. | Union |
| B. | Intersection |
| C. | Set Difference |
| D. | Disjoint |
| Answer» C. Set Difference | |
| 10. |
i-onl? |
| A. | ii-only |
| B. | i & ii |
| C. | None of the mentioned |
| Answer» D. | |
| 11. |
The bit string for the set {2, 4, 6, 8, 10} (with universal set of natural numbers less than or equal to 10) is ____________________ |
| A. | 0101010101 |
| B. | 1010101010 |
| C. | 1010010101 |
| D. | 0010010101 |
| Answer» B. 1010101010 | |
| 12. |
The query is syntactically wrong |
| A. | The query gives all the possible student names where a finite value exists for ID |
| B. | The query gives the names of the students that have a null ID and it also excludes identical names |
| C. | The query gives the student names where a finite value exists for ID and it excludes identical names |
| Answer» C. The query gives the student names where a finite value exists for ID and it excludes identical names | |
| 13. |
The complement of the set A is _____________ |
| A. | A – B |
| B. | U – A |
| C. | A – U |
| D. | B – A |
| Answer» C. A ‚Äö√Ñ√∂‚àö√ë‚àö¬® U | |
| 14. |
The difference of {1, 2, 3} and {1, 2, 5} is the set ____________ |
| A. | {1} |
| B. | {5} |
| C. | {3} |
| D. | {2} |
| Answer» D. {2} | |
| 15. |
Using the _______ clause retains only one copy of identical tuples |
| A. | distinct |
| B. | is not null |
| C. | no repeat |
| D. | from |
| Answer» B. is not null | |
| 16. |
Which of the following two sets are disjoint? |
| A. | {1, 3, 5} and {1, 3, 6} |
| B. | {1, 2, 3} and {1, 2, 3} |
| C. | {1, 3, 5} and {2, 3, 4} |
| D. | {1, 3, 5} and {2, 4, 6} |
| Answer» E. | |
| 17. |
If we want to retain all duplicates, we must write ________ in place of union. |
| A. | Union all |
| B. | Union some |
| C. | Intersect all |
| D. | Intersect some |
| Answer» B. Union some | |
| 18. |
When does the predicate is null succeed? |
| A. | If the value on which it is applied is finite |
| B. | If the value on which it is applied is invalid |
| C. | If the value on which it is applied is blank |
| D. | If the value on which it is applied is more than the allowed limit |
| Answer» D. If the value on which it is applied is more than the allowed limit | |
| 19. |
Two sets are called disjoint if there _____________ is the empty set. |
| A. | Union |
| B. | Difference |
| C. | Intersection |
| D. | Complement |
| Answer» D. Complement | |
| 20. |
The union operation automatically __________ unlike the select clause. |
| A. | Adds tuples |
| B. | Eliminates unique tuples |
| C. | Adds common tuples |
| D. | Eliminates duplicate |
| Answer» E. | |
| 21. |
The intersection of the sets {1, 2, 5} and {1, 2, 6} is the set _____________ |
| A. | {1, 2} |
| B. | {5, 6} |
| C. | {2, 5} |
| D. | {1, 6} |
| Answer» B. {5, 6} | |
| 22. |
The intersection operator is used to get the _____ tuples. |
| A. | Different |
| B. | Common |
| C. | All |
| D. | Repeating |
| Answer» C. All | |
| 23. |
What is the function of the intersect operation? |
| A. | It returns the intersection of the results of the results of any two different queries |
| B. | It returns the intersection of the results of two different queries which have the same set of attributes in the select clause |
| C. | It returns the intersection of the results of two different queries which have the same condition in the where clause |
| D. | None of the mentioned |
| Answer» C. It returns the intersection of the results of two different queries which have the same condition in the where clause | |
| 24. |
What is the function of the union operation? |
| A. | It combines the results of any two different queries |
| B. | It combines the results of two different queries which have the same set of attributes in the select clause |
| C. | It combines the results of two different queries which have the same condition in the where clause |
| D. | It gives the Cartesian product of the results of any 2 queries |
| Answer» C. It combines the results of two different queries which have the same condition in the where clause | |