1.
What is the primary purpose of using Stored Procedures in SQL Server?
2.
Which ADO.NET class is commonly used to execute a Stored Procedure in ASP.NET Core Web API?
3.
Which property of SqlCommand must be set when executing a Stored Procedure?
4.
Which value should be assigned to the CommandType property for executing a Stored Procedure?
5.
Which method is commonly used to pass values to a Stored Procedure securely?
6.
Which method is generally used to execute a Stored Procedure that returns multiple rows?
7.
Which method is commonly used when a Stored Procedure performs INSERT, UPDATE, or DELETE operations?
8.
What is one major security advantage of using parameterized Stored Procedures?
9.
Which HTTP method is typically used to insert new data through a Web API endpoint that calls a Stored Procedure?
10.
Why are Stored Procedures commonly used in production Web API applications?
1 out of 1
