ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question 
What's the purpose of Stored Procedure?
 Question Submitted By :: DevaRajS
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What's the purpose of Stored Procedure?
Answer
# 1		 
It will reduce the network traffic between client and 
server so that the number of calls between client and 
server are reduced.
It's an performance issue.
 
Is This Answer Correct ?    5 Yes 0 No
Koti Khammam
 
  Re: What's the purpose of Stored Procedure?
Answer
# 2		 
Stored Procedure Accept input Parameter,So a single stored 
procedure can use Over the Network by several Clients by 
Passing several Input values
 
Is This Answer Correct ?    2 Yes 0 No
Suresh
 
 
 
  Re: What's the purpose of Stored Procedure?
Answer
# 3		 
Stored Procedures has some advantages thats y we are using 
SP..
some advantages are..
(1)Stored Proc is a Pre Compiled statement..so its reduces 
Network Traffic.
(2). We can execute SP inside SP.
(3). Through it we can protect from SQL Injection.
 
Is This Answer Correct ?    4 Yes 1 No
Dharmendra K. Dixit
 
  Re: What's the purpose of Stored Procedure?
Answer
# 4		 
Stored procedured are precompiled and preoptimized sql stmts
so it takes less processing time,means executes much faster.
Can be shared between multiple user,so more reusable.
Much easier to manage it,since it resides in DB
more secure,flexible
 
Is This Answer Correct ?    2 Yes 0 No
Manisha
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
hi i gone though satyam interview. what is Acid Properties? Satyam2
What is an Index? Yardi-Software3
can any one answer this query,thank you in advance Table 1 has 2 columns: EmployeeId, T shirtsize(values can be 1,2,3) Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region which has the largest number of people with Tshirt size=3 Google10
can you any body tell me suppose database is suspect mode. how can take to normal? Teledata1
Hi..here i would like to know the Backup and Restore models? HCL2
What is an execution plan? When would you use it? How would you view the execution plan?  1
How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))????? SAP-Labs2
WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX L&T2
How to find out name of all employees who has salary less than 200 Rs.?  7
how will u create "n" possible tables in sql... Oracle1
How many index keys possible for a table  6
What is the use of MOVE keyword in restore command IBM2
Wht is the difference between stored procedure and trigger TCS4
What are the type of joins? When do we use Outer and Self joins?  3
when inserting to a table how many rows will be effected using triggers  1
I am Having tables T1 and T2 both having same data how to check (or) compare the data in both table are same?  2
How to find the last update record in SQL Server?  3
How do SQL server 2000 and XML linked?  2
What is Files and Filegroups in SQL Server & it's implementation. Zenith1
how to change column into row in sql ESS2
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com