DA0-001 · Question #380
Which of the following is the best reason to use database views instead of tables?
The correct answer is A. Views reduce the need for repetitive, complex data joins.. Views reduce the need for repetitive, complex data joins. Rationale: Views can encapsulate complex JOIN operations and present the result as a single table. This abstraction allows users to retrieve the necessary data without repeatedly writing intricate SQL queries, promoting ef
Question
Which of the following is the best reason to use database views instead of tables?
Options
- AViews reduce the need for repetitive, complex data joins.
- BViews allow for the storage of temporary data, whereas tables do not.
- CViews allow for the joining of multiple data sources, whereas tables do not.
- DViews can be used to restrict anonymous sensitive information.
How the community answered
(54 responses)- A94% (51)
- B4% (2)
- D2% (1)
Explanation
Views reduce the need for repetitive, complex data joins. Rationale: Views can encapsulate complex JOIN operations and present the result as a single table. This abstraction allows users to retrieve the necessary data without repeatedly writing intricate SQL queries, promoting efficiency and reducing the potential for errors.
Topics
Community Discussion
No community discussion yet for this question.