MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 6 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
A Boolean data type that can take values true, false, and ____________ |
| A. | 1 |
| B. | 0 |
| C. | Null |
| D. | Unknown |
| Answer» E. | |
| 2. |
All aggregate functions except __________ ignore null values in their input collection. |
| A. | Count(attribute) |
| B. | Count(*) |
| C. | Avg |
| D. | Sum |
| Answer» B. Count(*) | |
| 3. |
If we do want to eliminate duplicates, we use the keyword __________in the aggregate expression. |
| A. | Distinct |
| B. | Count |
| C. | Avg |
| D. | Primary key |
| Answer» B. Count | |
| 4. |
Which of the following is not a aggregate function ? |
| A. | Avg |
| B. | Sum |
| C. | With |
| D. | Min |
| Answer» D. Min | |
| 5. |
The ________ keyword is used to access attributes of preceding tables or subqueries in the from clause. |
| A. | In |
| B. | Lateral |
| C. | Having |
| D. | With |
| Answer» C. Having | |
| 6. |
SQL applies predicates in the _______ clause after groups have been formed, so aggregate functions may be used. |
| A. | Group by |
| B. | With |
| C. | Where |
| D. | Having |
| Answer» C. Where | |