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
What are different types of statements that are supported by sql?
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
Relational calculus is what type of language?
Do you know what is blocking?
What are the properties of the relational tables?
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?
What is the size of transaction log file?
What is resource db in sql server?
What is a performance monitor?
What is the ‘fillfactor’?
What is linked report?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
What are the recovery models in sql server 2000?
when would you go for denormalization? : Sql server database administration
What is difference between rownum and row_number?