Multiple choice technology databases

When 'select * from ' is given, oracle server checks for..

  1. control files

  2. redo log files

  3. user_views data dictionary view

  4. base table
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

When selecting from a view, Oracle must verify the view exists and the user has privileges. This metadata is stored in the USER_VIEWS data dictionary view. The server checks this before accessing base tables or executing the query. Control files and redo log files are unrelated to view resolution.

Keep practicing — related questions