Correct answer is: AB
A. Virtual columns can be indexed just like regular columns. This is useful when queries frequently filter or sort data based on the virtual column, as indexing improves performance.
B. Virtual columns can be used in the expression of another virtual column. This allows for more complex derived data to be generated from other columns, including other virtual columns.
E is false. Although virtual columns can be used in a WHERE clause of queries to filter data, they cannot be used in the WHERE clause of an UPDATE or DELETE statement because these statements modify data, and virtual columns are not physically stored.
more details about virtual columns: https://www.gpsos.es/2021/03/virtual-columns-in-oracle-use-and-limitations/?lang=en
upvoted 2 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
salander71
3 months, 2 weeks agosalander71
3 months, 2 weeks agolucemqy
1 year, 2 months agoPoke90
1 year, 10 months agoalic_alex
1 year, 10 months ago