Prepare
Practice
Interview
Aptitude
Reasoning
English
GD
Placement papers
HR
Current affairs
Engineering
MCA
MBA
Online test
Login
Online Practice Test
>
Oracle 5
« Previous
Next »
Views are automatically updated when base tables are updated
Options
- True
- False
CORRECT ANSWER : True
Discussion Board
VIEW
In SQL Server a standard view is nothing but a query. As the underlying data changes, when that query gets accessed, it reflects the changes to the data. It''s automatic, but not because some additional action is occurring to refresh the data in the view.
ABHIJIT 08-10-2017 02:41 PM
Views
Views are not automatically gets updated when base tables are changed, but when a query references a view then a stored query on the view is executed which builds the table on the fly and the updated records are shown.
Ajay M V 09-9-2013 02:33 AM
« Previous
Next »
Write your comments
*
*
Email must be in the form someone@domain.com
*
*
Enter the code shown above:
Please enter the code shown above
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
Related Content
Oracle (40)
Oracle (30)
Oracle (49)
Oracle (51)
Oracle (52)
Oracle DBA (29)
Oracle PLSQL (30)
Oracle Replication (20)
Oracle Architecture (20)
Oracle Transaction (20)
PLSQL (22)
PLSQL (24)
PLSQL (50)
Advertisement
▲