Oracle Database SQL — Question 98

Which two are true about virtual columns? (Choose two.)

Answer options

• A. They can be indexed.
• B. They can be referenced in the column expression of another virtual column.
• C. They cannot have a data type explicitly specified.
• D. They can be referenced in the set clause of an update statement as the name of the column to be updated.
• E. They can be referenced in the where clause of an update or delete statement.

Correct answer: A, E

Explanation

Option A is correct because virtual columns can indeed be indexed to improve query performance. Option E is also correct as virtual columns can be used in the where clause of update or delete statements. Options B, C, and D are incorrect; virtual columns can have specific data types, cannot be referenced in expressions for other virtual columns, and cannot be used in the set clause of an update statement.