DA0-001 · Question #558
Which of the following functions would the use of not in a database query be an example of?
The correct answer is D. Logical. NOT is a logical operator that negates a Boolean condition in a query (e.g., WHERE NOT status = 'inactive'). Logical functions - which include AND, OR, and NOT - evaluate true/false conditions to control which records are returned. Date functions (A) manipulate or compare…
Question
Which of the following functions would the use of not in a database query be an example of?
Options
- ADate
- BSystem
- CAggregate
- DLogical
How the community answered
(31 responses)- A6% (2)
- C3% (1)
- D90% (28)
Explanation
NOT is a logical operator that negates a Boolean condition in a query (e.g., WHERE NOT status = 'inactive'). Logical functions - which include AND, OR, and NOT - evaluate true/false conditions to control which records are returned. Date functions (A) manipulate or compare date/time values. System functions (B) return metadata about the database environment. Aggregate functions (C) such as SUM, COUNT, and AVG perform calculations across rows. NOT performs no calculation or date operation; it strictly inverts a logical condition.
Topics
Community Discussion
No community discussion yet for this question.