view is a virtual table i.e a new table is created using base table. vie

What is a view? is View updatable?

Question Posted / venkat

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

Please Help Members By Posting Answers For Below Questions

Explain the steps to create and execute a user-defined function in the sql server?

1016

Difference Between ORDER BY Clause and GROUP BY Clause in SQL?

1105

Where does the copy job runs in the log shipping primary or secondary? : sql server database administration

1102

Can you use order by when defining a view?

1022

Explain atomicity?

1132

How to replace given values with null using nullif()?

1040

What is shrink log file?

956

Define magic tables in sql server?

1124

What is the difference between push and pull subscription? : sql server replication

1279

What are the triggers in sql?

1171

What is the difference between an index and a unique index?

1048

How to check status of stored procedure in sql server?

1046

What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?

141

What are the requirements to use odbc connections in php scripts?

1161

how you can get the list of largest tables in a database? : Sql server administration

1107