Answer Posted / kumaran
A view is a Virtual Table or a Logical representation.
View type :- SimpleView and Complex View.
Simple views are updatable.
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
Can you explain different types of joins?
Can we perform backup restore operation on tempdb?
Describe how to use linked server?
What are the advantages of log shipping?
What is partition in sql server?
What is raid, and how it can influence database performance?
What is the difference between char and varchar2 datatype in sql?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What do you mean by a Composite primary key?
What is the significance of null value and why should we avoid permitting null values?
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
Why use “in” clause in sql server?
What is identity?
What is the maximum rows in sql server table?
What is a trigger in sql server?
