Stored Procedures Interview Questions | Snaprecruit.com

Stored Procedures Interview Questions | Snaprecruit.com

Stored Procedures interview questions

Stored Procedures interview questions

Take as many assements as you can to improve your validate your skill rating

Total Questions: 10

1. Stored procedure is a __________ set of one or more SQL statements.

Correct Answer is : pre compiled

2. Point out the wrong statement :

Correct Answer is : Stored procedure can returns multiple values using input parameters

3. How many types of stored procedures are present in SQL Server ?

Correct Answer is : 4

4. Which of the following procedures are created by user for own actions ?

Correct Answer is : User Defined Stored Procedure

5. Point out the wrong statement :

Correct Answer is : We can create a Stored Procedure using the Create stor_proc statement

6. Which of the following stored procedure is already defined in Sql Server ?

Correct Answer is : System defined Procedure

7. System defined Procedure logically appear in :

Correct Answer is : sys schema

8. Extended procedures starts with the __________ prefix.

Correct Answer is : sp_

9. Type of procedure that are based on the CLR (Common Language Runtime) is :

Correct Answer is : CLR Stored Procedure

10. Nesting limit OF stored procedure is up to ________level.

Correct Answer is : 32

Similar Interview Questions

    Search for latest jobs

    Icon
    Icon