Oracle
1Z0-071 · Question #415
Which three are true about scalar subquery expressions? (Choose three.)
The correct answer is A. They can be nested. D. They can be used as default values for columns in a CREATE TABLE statement. E. A scalar subquery expression that returns zero rows evaluates to NULL. https://docs.oracle.com/cd/B12037_01/server.101/b10759/expressions010.htm
Retrieving Data Using Subqueries
Question
Which three are true about scalar subquery expressions? (Choose three.)
Options
- AThey can be nested.
- BThey cannot be used in the VALUES clause of an INSERT statement.
- CA scalar subquery expression that returns zero rows evaluates to zero.
- DThey can be used as default values for columns in a CREATE TABLE statement.
- EA scalar subquery expression that returns zero rows evaluates to NULL.
- FThey cannot be used in GROUP BY clauses.
How the community answered
(43 responses)- A81% (35)
- B2% (1)
- C9% (4)
- F7% (3)
Explanation
https://docs.oracle.com/cd/B12037_01/server.101/b10759/expressions010.htm
Topics
#scalar subqueries#NULL handling#INSERT VALUES clause#GROUP BY restrictions
Community Discussion
No community discussion yet for this question.