what is the purpose of creating view is sql server 2000
Answer Posted / veena
Views can reduce the complexity of database schema
Veiw can provide column level and row level security
By using views present aggregated data and hide detailed data
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Mention the different types of triggers?
What are the different types of collation sensitivity in sql server?
Why use stored procedures in sql server?
Your table has a large character field there are queries that use this field in their search clause what should you do?
Do you know what are pages and extents? : SQL Server Architecture
Why we use functions in sql server?
Name the different type of indexes in sql?
Can the query output be sorted by multiple columns in ms sql server?
What is raid, and how it can influence database performance?
Explain what is row_number function?
Explain the Ways to improve the performance of a sql azure database?
What stored by the master?
How can sql injection be stopped? : sql server security
List out what other servers you can use with ssrs?
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? : Sql server administration