Multiple choice technology databases

In general, Oracle accepts all forms of expressions in all parts of all SQL statements.

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Oracle has strict context rules for expressions. For example, you cannot use aggregate functions in WHERE clauses (need HAVING), and certain expressions are prohibited in DEFAULT values, CHECK constraints, or some DDL statements. Expression validity depends on the SQL clause context.

Keep practicing — related questions