Start learning 50% faster. Sign in now
A SQL view is a virtual table that reflects the results of a query in real-time. 1. Dynamic Nature: A view does not store data itself but retrieves data dynamically from the underlying table when queried. 2. Purpose: The high _ salary _ employees view reflects any updates made to the employees table that meet the specified condition (salary > 50000). 3. Real-Time Updates: Changes to the employees table are automatically visible in the view without needing to recreate it. This behavior makes views ideal for abstraction and encapsulation in SQL. Why Other Options Are Incorrect: • A) The view stores a copy of the data in the database: A view is virtual and does not store data physically. • B) The view must be recreated if the employees table is updated: The view dynamically reflects updates to the employees table. • D) The view can be used to perform DML operations directly on employees: Views are read-only unless explicitly defined as updatable. • E) The view is static and cannot be updated: Views are dynamic and reflect real-time data.
Which of the following is NOT a cold ocean current?
Identify the rock that is not of igneous origin.
In which year was the Mahila Samman Savings Certificate (MSSC) scheme launched?
Chandigarh has the famous lake __________?
Kanger Ghati National Park is situated in which state?
Where is India's first Dolphin Research Centre located?
If "DOG" is coded as "EPI", how will "CAT" be coded?
When was the "WHO Global Strategy on Diet, Physical Activity and Health" adopted by the Health Assembly?
When is National Consumer Rights Day celebrated annually in India?
What does the second R denote in the “RAFTAAR” scheme of the government of India?