30th
Jan
Stored Procedures MCQ

Stored Procedures MCQ

  • Admin
  • 30th Jan, 2023
  • 608 Followers

Take Stored Procedures MCQ Test to Test Your Knowledge.

Practice here the best Stored Procedures MCQ Questions. This MCQ Test is very helpful & important for the preparation for the Stored Procedures Exam/Interview. These MCQ Questions are taken from the job interviews. so practice these questions to check your final preparation for your upcoming exam. apart from this, you can also download here the Stored Procedures MCQ PDF, completely free.

Stored Procedures MCQ

1) Stored Procedure also termed as ......

  • A. proc
  • B.StoPro
  • C.storp
  • D.All of the above

2) What are the features of Stored Procedures in SQL Server?

  • A. Reduced Traffic
  • B.Easy Maintenance
  • C.Easy Maintenance Reusable & Stronger Security
  • D.All of the above

3) SQL Server categorizes the stored procedures in .........

  • A. 2 types
  • B.4 types
  • C.5 types
  • D.3 types

4) Can we use the EXEC command to call/execute the stored procedures in SQL Server?

  • A. Yes
  • B.No

5) The SQL Server removes the stored procedure using ..........

  • A. T-SQL Query
  • B.SQL Server Management Studio
  • C.Both T-SQL Query & SQL Server Management Studio
  • D.None of the above
Download Free : Stored Procedures MCQ PDF

6) ................. is an extended procedure.

  • A. sp_owner
  • B.xp_change
  • C.xp_logininfo
  • D.None of the above

7) Which of the following stored procedure is used for error messages?

  • A. sp_addmessage
  • B.sp_altermessage
  • C.sp_altermessage
  • D.None of the above

8) Which of the following stored procedure is used to remember the exact number of bytes?

  • A. sp_info
  • B.sp_datatype
  • C.sp_datatype_info
  • D.None of the above

9) Stored Procedure is a ............ set of one or more SQL statements.

  • A. Compiled
  • B.Interpreted
  • C.Pre compiled
  • D.None of the above

10) How many types of stored procedures are present in SQL Server?

  • A. 2
  • B.4
  • C.6
  • D.8

11) System defined Procedure logically appear in sys schema.

  • A. Ture
  • B.False

Leave A Comment :

Valid name is required.

Valid name is required.

Valid email id is required.

Related MCQ/Quiz

01st
Feb
CSS MCQ
01st
Nov
Rdbms MCQ
01st
Jun
Hibernate MCQ
01st
Feb
PL/SQL MCQ
01st
May
Photoshop MCQ