Examice

Exam 1z0-071 All QuestionsBrowse all questions from this exam

Go to Exam

Question 106

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

They can be indexed.

They can be referenced in the column expression of another virtual column.

They cannot have a data type explicitly specified.

They can be referenced in the set clause of an update statement as the name of the column to be updated.

They can be referenced in the where clause of an update or delete statement.

Correct Answer: A, E

Virtual columns in a database can be indexed, making them efficient for query performance improvements. Additionally, they can be referenced in the WHERE clause of an UPDATE or DELETE statement, allowing for conditional operations based on the computed values of the virtual columns.

Discussion

Poke90

https://oracle-base.com/articles/11g/virtual-columns-11gr1

alic_alexOptions: AE

more details about virtual columns: https://www.gpsos.es/2021/03/virtual-columns-in-oracle-use-and-limitations/?lang=en

lucemqyOptions: AE

AE They can be indexed and used in where clause of UPDATE and DELETE statements