What is a view? is View updatable?

Answer Posted / venkat

view is a virtual table i.e a new table is created using
base table.
view can be updated based on some restrictions

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does normalization do to data?

536


How important do you consider cursors or while loops for a transactional database?

525


How many categories of data types used by sql server?

589


what is the main function of a query parameter?

111


What is multilevel indexing?

527






how would you store your query in an SSRS report or a Database server?

116


How to display a past time in days, hours and minutes?

565


How to create “dependant” parameter “make, model, year”

87


What is the guest user account in sql server? What login is it mapped to it? : sql server security

578


What is the federation in sql azure?

79


What is sql server schema compare? How we can compare two database schemas?

555


Explain error and transaction handling in sql server?

495


Can you explain what is the use of custom fields in report?

597


What are the commands used in DCL?

553


What is the difference between ‘having’ clause and a ‘where’ clause?

543