Question
CREATE OR REPLACE VIEW high _ salary _ employees AS
SELECT employee _ id, salary FROM employees WHERE salary > 50000; Which statement about the view high _ salary _ employees is true?Solution
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 entity has approved changes to mutual fund regulations to prevent potential market abuses, including frontrunning?
Deposit Insurance and Credit Guarantee Corporation (DICGC) provide funds up to Rs 5 lakh to an account holder within the Period of ________days.
Which of the following is/are advantages of Foreign Direct Investment:
Which of the following is NOT one of the four priorities on which the budget proposal of 2022-23 rests ?
Bank of ______ has prolonged about Rs 800 crore to ReNew Power, within the first native undertaking financing deal by the lender within the renewable en...
RBI announced to lower net worth requirement from 100 crore to ____ for operating the units in Bharat Bill Payment Systems.
A manager who utilizes the Achievement-Oriented leadership style will likely _____
In August 2022, RBI increased the limit of ECB that eligible borrower can raise per financial year under the automatic route to _______. This relaxation...
Which program did SBI Life Insurance launch to engage B-School students to innovate in the life insurance sector?
Department of Telecom (DoT) announced to use infrastructure owned by the power sector distributors for deployment of _____.