adspace


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


Please Help Members By Posting Answers For Below Questions

What is acid mean in sql server?

1244


What is in place upgrade in sql server?

1125


What are the different types of subquery?

1233


explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1132


Why use identity in sql server?

1196


What is a coalesce function?

1282


How to connect php with different port numbers?

1186


Is it possible to have clustered index on separate drive from original table location?

1039


How efficient you are in oracle and SQL server?

1255


List out the different types of locks available in sql server?

1049


How to convert character strings into numeric values?

1189


How to remove duplicate rows from table except one?

1087


What is standby servers? Explain types of standby servers.

1078


Can we shrink data file in sql server?

1126


What are the different subsets of sql?

1649