1Z0-082 practice question 14 of 25
Which three statements are true regarding single row subqueries?
Full set: 142 questionsSingle-row subqueries are versatile components in SQL. They can be used in the WHERE clause to filter rows based on a single value returned by the subquery. They are also permitted in the HAVING clause to filter grouped results. Furthermore, a single SQL statement is not limited to one subquery; multiple single-row subqueries can be used in various clauses of the same statement to implement complex logic.
A. A subquery can be on either side of a comparison operator, so stating it must be on the right is incorrect.
B. A subquery can be on either side of a comparison operator, so stating it must be on the left is incorrect.
E. If a single-row subquery returns no rows, its result is NULL. This does not cause an error; the comparison condition simply evaluates to unknown.
Oracle Database SQL Language Reference
19c
"Subqueries". This section explicitly shows examples of subqueries in WHERE and HAVING clauses. It states
"A single-row subquery returns zero or one row...".
Oracle Database Concepts
19c
Chapter 19
"SQL". The section "Subqueries" describes their use in filtering conditions. The documentation does not impose a limit of one subquery per statement.
Keep practicing
Take the free 1Z0-082 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-082 practice questions
- Question 1Which three statements are true about using SQL*Plus?
- Question 2Which three statements are true about advanced connection options supported by Oracle Net…
- Question 3Which statement is true about the INTERSECT operator used in compound queries?
- Question 5Which two statements are true about the ORDER BY clause when used with a SQL statement co…
- Question 6Which three statements are true about the tools used to configure Oracle Net Services? (C…
- Question 7In your data center, Oracle Managed Files (OMF) is used for all databases. All tablespace…
