MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 15 Mcqs, each offering curated multiple-choice questions to sharpen your Rdbms knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
What values does the count(*) function ignore? |
| A. | Repetitive values |
| B. | Null values |
| C. | Characters |
| D. | Integers |
| Answer» C. Characters | |
| 2. |
Which keyword is used to rename the resulting attribute after the application of the aggregation function? |
| A. | rename |
| B. | as |
| C. | replace |
| D. | to |
| Answer» C. replace | |
| 3. |
State true or false: We can rename the resulting attribute after the aggregation function has been applied |
| A. | True |
| B. | False |
| Answer» B. False | |
| 4. |
State true or false: Any attribute which is present in the having clause without being aggregated must not be present in the group by clause. |
| A. | True |
| B. | False |
| Answer» C. | |
| 5. |
The _____ aggregation operation adds up all the values of the attribute |
| A. | add |
| B. | avg |
| C. | max |
| D. | sum |
| Answer» E. | |
| 6. |
Choose the correct option regarding the query |
| A. | The having clause checks whether the query result is true or not |
| B. | The having clause does not check for any condition |
| C. | The having clause allows only those tuples that have average balance 10000 |
| D. | None of the mentionedView Answer |
| Answer» D. None of the mentionedView Answer | |
| 7. |
Observe the given SQL query and choose the correct option. |
| A. | The query is syntactically correct but gives the wrong answer |
| B. | The query is syntactically wrong |
| C. | The query is syntactically correct and gives the correct answer |
| D. | The query contains one or more wrongly named clauses.View Answer |
| Answer» C. The query is syntactically correct and gives the correct answer | |
| 8. |
STATE_TRUE_OR_FALSE:_ANY_ATTRIBUTE_WHICH_IS_PRESENT_IN_THE_HAVING_CLAUSE_WITHOUT_BEING_AGGREGATED_MUST_NOT_BE_PRESENT_IN_THE_GROUP_BY_CLAUSE.?$ |
| A. | True |
| B. | False |
| Answer» C. | |
| 9. |
State_true_or_false:_We_can_rename_the_resulting_attribute_after_the_aggregation_function_has_been_applied$ |
| A. | True |
| B. | False |
| Answer» C. | |
| 10. |
The _____ aggregation operation adds up all the values of the attribut? |
| A. | add |
| B. | avg |
| C. | max |
| D. | sum |
| Answer» B. avg | |
| 11. |
The having clause checks whether the query result is true or not |
| A. | The having clause does not check for any condition |
| B. | The having clause allows only those tuples that have average balance 10000 |
| C. | None of the mentioned |
| Answer» C. None of the mentioned | |
| 12. |
We apply the aggregate function to a group of sets of tuples using the _______ clause. |
| A. | group by |
| B. | group |
| C. | group set |
| D. | group attribute |
| Answer» D. group attribute | |
| 13. |
State true or false: SQL does not permit distinct with count(*) |
| A. | True |
| B. | False |
| Answer» B. False | |
| 14. |
The query is syntactically correct but gives the wrong answer |
| A. | The query is syntactically wrong |
| B. | The query is syntactically correct and gives the correct answer |
| C. | The query contains one or more wrongly named clauses. |
| Answer» B. The query is syntactically correct and gives the correct answer | |
| 15. |
Which of the following is not a built in aggregate function in SQL? |
| A. | avg |
| B. | max |
| C. | total |
| D. | count |
| Answer» D. count | |