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.
In each of the questions given below a sentence is given with three words in bold. Choose the option which gives the correct sequence of these words to...
Which of the following will be the THIRD sentence after the rearrangement?
In each sentence below four words have been printed in bold which are numbered (1), (2), (3) and (4) One of these words may be misspelt or inappropriat...
Which should be the last sentence after rearrangement?
1. There was a boy named Pappu.
P. So the mother asked him to find work.
Q. They were very poor.
<...
The astronauts need time to properly hand on (1) their responsibilities and prepare for the return journey (2) , which includes physical conditioni...
Given that 1 is the first sentence, which of the following will be the SECOND sentence after rearrangement?
1. Every Saturday night the Clover Leaf Social Club gave a hop in the hall of the Give and Take Athletic Association on the East Side.
P. Still, ...
1. Joe was painting in the class of the great Magister, you know his fame.
P. Delia was studying under Rosenstock - you know his repute as a dist...