.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 is the benefit of using the WITH CHECK OPTION option in your view definition?

Posted By :Ravi Ranjan Kumar     Posted Date :July 24, 2011    Points :40   Category :Sql Server 
The option forces modification statements that are executed against the view to adhere to the criteria that is set within the SELECT statement that defines the view.

You can also find related Interview Question to What is the benefit of using the WITH CHECK OPTION option in your view definition?  below: 

What is VDL (View Definition Language)?

  
It specifies user views and their mappings to the conceptual schema. (More...)

What optimizations does the C# compiler perform when you use the /optimize+ compiler option?

  
The following is a response from a developer on the C# compiler team: We get rid of unused locals (i.e., locals that are never read, even if assigned). We get rid of unreachable code. We get rid of try-catch with an empty try. We get rid of try-finally with an empty try. We get rid of try-finally with an empty finally. We optimize branches over branches: gotoif A, lab1 goto lab2: lab1: turns into: gotoif !A, lab2 lab1: We optimize branches to ret, branches to next instruction, and branches to branches. (More...)

Why do we use Option Explicit?

  
Correct answer is - This statement force the declaration of
variables in VB before using them. (More...)

Which option is used to drop constraints specified on the table?

  
DROP option in the ALTER TABLE command is used to drop constraints specified on the table. (More...)

What is the advantage of specifying WITH GRANT OPTION in the GRANT command?

  
The privilege receiver can further grant the privileges he/she has obtained from the owner to any other user. (More...)

Consider the following code:

public class Example extends Thread
{
public void run()
{
System.out.println ("Hello");
}

public static void main (String args[])
{
new Example();
}
}

Select the correct option regarding the preceding code ?

  
1, The code will not compile.
2, The code will compile but will not execute.
3, The code will compile, execute, and display Hello as the output.
4, The code will compile, execute, but will not display anything.

Answer : 4 (More...)

Consider the following two classes:

public class Example1
{
public static int num;
static
{
num=5;
}
}


public class Example2
{
public static void main(String[] args)
{
System.out.println(Example1.num);
}
}

Select the correct option regarding the preceding classes.?

  
1, The Example2 class will execute without any output.
2, The Example2 class will execute with the following output:5

3, The Example2 class will not compile as it does not calls the constructor of the Example 1 class.
4, The Example2 class will not execute as it does not calls the constructor of the Example 1 class.

Answer : 2 (More...)

What is the use of Option explicit?

  
Variable must be compulsorily declared when the Option Explicit is termed as ON. If it is OFF, variables can be used without declaration. (More...)

How to upload a large file using file upload option in asp.net.

  
By default the maximum size that Asp.net allow is just 4 MB. So file having size bigger than 4 MB will not be allowed and after hitting submit button you will get page not found.
So to solve this issue increase the size in web config file using httpruntime as below for 60 MB-





(More...)

What is the use of Option explicit?

  
Variable must be compulsorily declared when the Option Explicit is termed as ON. If it is OFF, variables can be used without declaration (More...)

What is a view?

  
If we have several tables in a db and we want to view only specific columns from specific tables we can go for views. It would also suffice the needs of security some times allowing specfic users to see only specific columns based on the permission that we can configure on the view. Views also reduce the effort that is required for writing queries to access specific columns every time. (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