What is a view? is View updatable?

Answer Posted / amit upadhyay

VIEW :- VIEW IS VIRTUAL TABLE. WHICH GIVE ACCESS TO SUBSET
OF COLUMN OF THE TABLES.

VIEW CAN BE UPDATED THAT GET EFFECTED THE TABLE ALSO.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is database isolation in sql server? : sql server database administration

570


Can the “if update (colname)” statement be used in a delete trigger?

559


What do you understand by user-defined function in the sql server?

490


Why we use the openxml clause?

547


What is normalization? Describe its different types.

586






How to find the login name linked to a given user name?

534


Can we use having clause without group by?

556


Can group by be used without aggregate functions?

483


What are parameterized reports? What are cascading parameters in ssrs reports?

100


what stored procedure would you use to view lock information? : Sql server administration

586


How to verify a login name with sqlcmd tool?

597


What does nvl stand for?

560


How to attach adventureworkslt physical files to the server?

635


Do you know data definition language, data control language and data manipulation language?

630


Explain system rowset functions?

560