Stored Procedures Interview Questions | Snaprecruit.com
Stored Procedures Interview Questions | Snaprecruit.com
JOBSEEKERS
Login
Sign Up
Jobseeker
Employer
Staffing
Enterprises
Stored Procedures interview questions
Stored Procedures interview questions
Back
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.
A. interpreted
B. compiled
C. pre compiled
D. none of the mentioned
Show Correct Answer
Correct Answer is :
pre compiled
2. Point out the wrong statement :
A. Stored procedure can accepts input and output parameters
B. Stored procedure can returns multiple values using input parameters
C. Using stored procedure, we can Select,Insert,Update,Delete data in database
D. None of the mentioned
Show Correct Answer
Correct Answer is :
Stored procedure can returns multiple values using input parameters
3. How many types of stored procedures are present in SQL Server ?
A. 3
B. 4
C. 5
D. 8
Show Correct Answer
Correct Answer is :
4
4. Which of the following procedures are created by user for own actions ?
A. User Defined Stored Procedure
B. Extended Procedure
C. CLR Stored Procedure
D. All of the mentioned
Show Correct Answer
Correct Answer is :
User Defined Stored Procedure
5. Point out the wrong statement :
A. A stored procedure is nothing more than prepared SQL code
B. We can create a Stored Procedure using the Create proc statement
C. We can create a Stored Procedure using the Create stor_proc statement
D. All of the mentioned
Show Correct Answer
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 ?
A. User Defined Stored Procedure
B. Extended Procedure
C. CLR Stored Procedure
D. System defined Procedure
Show Correct Answer
Correct Answer is :
System defined Procedure
7. System defined Procedure logically appear in :
A. sys schema
B. stor schema
C. proc schema
D. all of the mentioned
Show Correct Answer
Correct Answer is :
sys schema
8. Extended procedures starts with the __________ prefix.
A. sp_
B. xp_
C. clr_
D. all of the mentioned
Show Correct Answer
Correct Answer is :
sp_
9. Type of procedure that are based on the CLR (Common Language Runtime) is :
A. User Defined Stored Procedure
B. Extended Procedure
C. CLR Stored Procedure
D. System defined Procedure
Show Correct Answer
Correct Answer is :
CLR Stored Procedure
10. Nesting limit OF stored procedure is up to ________level.
A. 30
B. 32
C. 34
D. 36
Show Correct Answer
Correct Answer is :
32
Similar Interview Questions
Search for latest jobs
Find Jobs