T- SQL Stored Procedures Interview Questions

T SQL Stored Procedures interview questions

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

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

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

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

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

Correct Answer is : sp_helpdb provides the text of a stored procedure reside in Sql Server

T SQL Stored Procedures interview questions