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.
HCLTech founder Shiv Nadar and family retained the top spot on the Edelgive Hurun India Philanthropy list 2023 with a donation of ₹2,042 crore for the...
Which of the following is the primary function of the 'e-Sakshya' app launched by Union Home Minister Amit Shah?
The 2nd edition of joint military exercise “The Africa-India Field Training Exercise (AFINDEX-2023)” took place in?
Fill in the blank: Mamta G. Sagar received the World Literary Prize from the World Organization of Writers ( WOW) in a ceremony held in _______.
A transaction banking platform NEO for Business has been launched for the Indian Micro, Small and Medium Enterprises (MSMEs) that will offer features li...
What is the total outlay approved by the Union Cabinet for the Incentive Scheme for BHIM-UPI (P2M) transactions for FY 2024–25?
To promote traditional medicines into the state where the new WHO(World Health Organization) global center is going to be set up?
Which bank's subsidiary recently launched the mobile banking app 'Money2India (Canada)' for seamless 24/7 fund transfers to any Indian bank without the ...
The President of India, Smt Droupadi Murmu inaugurated the 7th India Water Week today (November 1, 2022) at which city?
The $23 million loan agreement signed between India and the Asian Development Bank (ADB) aims to establish an International Fintech Institute (IFI) in: