DBMS · Question 18 · Easy
In a relational database, what is a view?
- A physical copy of a table kept for backup
- A virtual table defined by a stored query, whose rows are derived from base tables
- An index that speeds up searches
- A user account with read-only access
Answer and explanation
Answer: B. A virtual table defined by a stored query, whose rows are derived from base tables
Explanation: A view stores only its defining SELECT query. Its rows are computed from the underlying base tables when the view is queried (unless it is a materialized view).
Previous: Which ACID property guarantees that once a transaction has committed, its… · Next: In an ER diagram (Chen notation), how is a multivalued attribute such as a…
Practise dbms
Try a fresh set of dbms questions with an explanation after every answer, free and without signing up: DBMS practice. Or sit a full placement mock test.
More dbms questions
- Relation R(A, B, C) has the functional dependencies AB → C and C → B. Which is…
- A column in the Enrollment table that refers to the primary key of the Student…
- Which ACID property guarantees that once a transaction has committed, its…
- In an ER diagram (Chen notation), how is a multivalued attribute such as a…
- Which data model stores data as tables (relations) made of rows and columns?
- Relation R(A, B, C, D, E) has the functional dependencies A → B, BC → D and D…
- A one-to-many relationship 'works in' links Department (one) to Employee…
- Relation R has 3 attributes and 5 tuples, and relation S has 4 attributes and…
- Relation R(A, B, C, D) has the functional dependencies AB → CD and B → C, and…
- A sparse (non-dense) index has an entry for only some of the search-key…
More technical & programming practice
SQL · Operating Systems · Computer Networks · Software Engineering · Cloud & DevOps · GenAI Basics · Pseudo-code · C Programming
LogicWiz Exams home · All practice topics · Placement mock tests · Daily 10 challenge