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                      
tip   To Refer this Site to Your Friends   Click 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 ?    2 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 ?    3 Yes 1 No
Dharmendra K. Dixit
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
Can we use Truncate command on a table which is referenced by FOREIGN KEY?  1
What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance.... Siemens6
Create Index myIndex On myTable(myColumn) What type of Index will get created after executing the above statement  2
What is the difference between views and stored procedures? Can we have input parameters for views?  3
Difference between Function and Procedure-in general?  2
1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks  2
how to delete duplicate rows from table CSC2
What are the different types of backup avaible in SQL SErver Emphasis3
I have a website that allows customers to browse and place orders for certain products. I have 2 tables; Customers and Orders. The Customers table holds the customer records and the Orders table holds the orders placed by the customer. Both tables are tied based on the field Cust_ID. Example of the data is shown below: Cust_ID Cust_Name Cust_ID Product Amount Order_Date 1001 John Tan 1001 P-5211 $120.00 2/13/2006 1002 Michael Wong 1001 K-1428 $88.90 1/11/2006 1003 Mary Cheong 1003 C-0923 $82.50 1/27/2006 1004 Ahmad Suffian 1003 K-1428 $88.90 2/2/2006 Write a single SQL statement that extracts all purchase records with the following criteria: 1. Customer names starting with “M” only. 2. Orders placed within the current month only. 3. Amount does not exceed $100.00 The list must be sorted by order date with the latest order showing on top. Techno-Solutions3
What's the purpose of Stored Procedure? Wipro3
How To delete duplicate record from a particular table? eXensys8
What is the difference between SSAS 2000 and SSAS 2005? APX1
When do you use SQL Profiler?  2
how to find number of columns in a table in sql server 2000 and 2005 also Virtusa6
How do you use DBCC statements to monitor various aspects of a SQL server installation?  1
what is meant by sql injection with example and one more question how to catch the errors in sqlserver  1
How do you know which index a table is using?  4
What is the difference between Userdefined function and stored procedure? Explain and give the example also  2
How many index keys possible for a table  6
is there more the two primary key in a single table? Systematix19
 
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