C - Views can be indexed. FALSE
Only materialised views can be indexed:
https://asktom.oracle.com/pls/apex/asktom.search?tag=indexes-on-view
E - Tables in the defining query of a view must always exist in order to create the view. FALSE:
Usually, you create a new view based on existing tables. However, sometimes, you may want to create a view based on the tables that you will create later or the tables that you don’t have sufficient privileges to access at the time of creating the view. In these cases, you can use the FORCE option.
https://www.oracletutorial.com/oracle-view/oracle-create-view/
upvoted 1 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.
lucemqy
1 month, 3 weeks agoESZ
9 months, 2 weeks agoCMjer
7 months, 4 weeks ago