T- SQL Stored Procedures Interview Questions | Snaprecruit.com
T- SQL Stored Procedures Interview Questions | Snaprecruit.com
JOBSEEKERS
Login
Sign Up
Jobseeker
Employer
Staffing
Enterprises
T SQL Stored Procedures interview questions
T SQL Stored Procedures interview questions
Back
Take as many assements as you can to improve your validate your skill rating
Total Questions: 5
1. How many ways of returning data is present in SQL Server 2000 ?
A. 3
B. 4
C. 5
D. 6
Show Correct Answer
Correct Answer is :
4
2. Point out the correct statement :
A. Stored procedures assist in achieving a consistent implementation of logic across applications
B. A stored procedure is a group of Transact-SQL statements compiled into a single execution plan
C. Stored procedures can also improve performance
D. All of the mentioned
Show Correct Answer
Correct Answer is :
All of the mentioned
3. Data return using output parameter is :
A. Return codes, which are always an integer value
B. A global cursor that can be referenced outside the stored procedure
C. A single cursor that can be referenced inside the stored procedure
D. None of the mentioned
Show Correct Answer
Correct Answer is :
None of the mentioned
4. Which of the following is a system procedure ?
A. sp_changeowner
B. sp_owner
C. sp_change
D. All of the mentioned
Show Correct Answer
Correct Answer is :
sp_changeowner
5. Point out the wrong statement :
A. sp_depends provide the details of all database objects that depends on the specific database object
B. sp_helpdb provides the text of a stored procedure reside in Sql Server
C. Extended procedures provide an interface to external programs for various maintenance activities
D. All of the mentioned
Show Correct Answer
Correct Answer is :
sp_helpdb provides the text of a stored procedure reside in Sql Server
Similar Interview Questions
Search for latest jobs
Find Jobs