Multiple choice technology databases

Which of the following are correct for a view

  1. a. View is a named SQL query stored in data dictionary

  2. b. View is a database object which stores data

  3. c. View is used for data hiding

  4. d. Views doesn’t occupy memory
Reveal answer Fill a bubble to check yourself
A,C,D Correct answer
Explanation

Views are virtual tables based on SQL queries stored in the data dictionary (option A correct). They do NOT store data themselves - data remains in underlying tables (option B incorrect). Views provide data hiding by restricting access to specific columns or rows (option C correct). Views don't occupy additional storage memory as they don't duplicate data (option D correct).

Keep practicing — related questions