C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Communities   Interview   Jobs   Projects   Offshore Development    
Silverlight Tutorials | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Revenue Sharing |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...
New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !



Posted By: Ramachandra Prabhu       Member Level: Silver       Posted Date: 08 Apr 2008       Category: SQL Server

Stored Procedure Query Plan

Which stored procedure option regenrates the query plan every time a procedure is exected?
Select Answer:

ENCRYPTION
RECOMPLE
VARYING
EXECUTE AS




      
Your Test Score: 0 / 0



Next Question: Given an employees table as follows: empid name managerid a1 bob NULL b1 jim a1 B2 tom a1 What value will select count(*) from employees return?
Previous Question: Function
Related Questions:
  • Maximum FIle Group In a DATABASE


  • Which one of the following LOCK acquires @ read operations


  • where all deleted rows stored


  • Which constraint prohibits a column or combination of columns from allowing duplicate values.


  • The maximum number of Columns per base Table


    		•

    Categories

    ASP.NET C# VB.NET 
    .NET Framework SQL Server Other 

    Submit Interview/Test Questions with Answers and make money from adsense revenue sharing program

    Want to prepare for an interview? Try our aptitude tests and standard interview questions first.

    dotNet Slackers   BizTalk Adaptors    Web Design

    doors in nj

    Contact Us    Privacy Policy    Terms Of Use