.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Interview Question >> Sql Server >> Post New Question Subscribe to Interview Questions

What are some considerations to remember when you use views?

Posted By :Ravi Ranjan Kumar     Posted Date :July 24, 2011    Points :40   Category :Sql Server 
Objects that are referenced in a view are verified when a view is created. Views can be altered so that permissions that are assigned to the view are maintained. Dropping or altering an underlying table affects the view. If the view is not created by a sysadmin, the user name should be specified as part of the view name. The same owner should own all objects upon which a view depends in order to avoid broken ownership chains. Hidden complexity can make it difficult to determine the source of performance problems.


You can also find related Interview Question to What are some considerations to remember when you use views?  below: 

What are the different types of views?

  
There are two different types of views:
-----------------------------------------------------

Simple View: For Single table

Complex view: For multiple tables

(More...)

What is catalog views in Sql server 2008?

  
Catalog views return info
Views are the most general interface to the catalog metadata and provide the most efficient way to obtain, transform, and present customized forms of this information. All user-available catalog metadata is exposed through catalog views.Catalog views return info
Views are the most general interface to the catalog metadata and provide the most efficient way to obtain, transform, and present customized forms of this information. All user-available catalog metadata is exposed through catalog views. (More...)

what is catalog views in sql server?

  
Catalog views return information that is used by sql server database engine.Catalog Views are the most general interface to the catalog metadata and provide the most efficient way to obtain, transform, and present customized forms of this information. All user-available catalog metadata is exposed through catalog views. (More...)

What are the Important points to remember on indexers

  
Indexers are always created with this keyword.

· Parameterized property are called indexer.

· Indexers are implemented through get and set accessors for the [ ] operator.

· ref and out parameter modifiers are not permitted in indexer.

· Indexer is an instance member so can't be static but property can be static.

· Indexers are used on group of elements.

· Indexer can be overloaded.
(More...)

What are the benefits of views?

  
Users focus only on data that they need; user manipulation of data is simplified; database and query complexity is hidden from users, allowing users to see friendly names; and views provide a security mechanism by allowing users access to data through views only.
(More...)

Database: state whether function and Views are similar in some respect?

  
Yes, Function take parameters and can be used in joins and other row set operations. (More...)

List How to copy tables,schema and views from one server to another?

  
-Detach database from one server and then attach database to another server
-Create Script of all objects and then run on another server
-User SSMS wizard (More...)

Could remember some of the new features included in C#3.0 Version?

  
C# 3.0 has following good features and these features works with Visual studio 2008.

Object and Collection Initializers
Implicitly Typed Local Variables
Implicitly Typed Arrays
Extension Methods
Lambda Expressions
Anonymous Types
Query Expressions(LINQ)
Automatically Implemented Properties


(More...)

Quick Links For Interview Questions Categories:
ASP.Net Windows Application   .NET Framework   C#   VB.Net   ADO.Net  
Sql Server   SharePoint   Silverlight   OOPs   JQuery   JavaScript/VBScript
Biztalk Patten/Practices .IIS WCF WPF WWF
Networking Aptitude Others   All      

Find questions, FAQ's and their answers related to .NET, C#, Vb.Net, Sql Server and many more.

 
Now you can find lots of .NET, C#, Vb.Net, SQL Server,Windows, ASP.Net related Questions and their Answers here at www.dotnetspark.com. Our aim is to help you pass your certification Exams (MCP, MCSD, MCAD etc.,) with flying scores and get good name in your company.

So, Start looking our Interview Question section daily and improve your .NET Skills. You can also help others by posting Interview Questions and their Answers in this section.


Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend