MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 4 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
The ____ connective tests for set membership, where the set is a collection of values produced by a select clause. The ____ connective tests for the absence of set membership? |
| A. | Or, in |
| B. | Not in, in |
| C. | In, not in |
| D. | In, or |
| Answer» E. | |
| 2. |
A Boolean data type that can take values true, false, and________ |
| A. | 1 |
| B. | 0 |
| C. | Null |
| D. | Unknown |
| Answer» B. 0 | |
| 3. |
All aggregate functions except _____ ignore null values in their input collection. |
| A. | Count(attribute) |
| B. | Count(*) |
| C. | Avg |
| D. | Sum |
| Answer» D. Sum | |
| 4. |
Aggregate functions are functions that take a ___________ as input and return a single value. |
| A. | Collection of values |
| B. | Single value |
| C. | Aggregate value |
| D. | Both Collection of values & Single value |
| Answer» B. Single value | |