00:59:56
Question 7
In SQL, which of the following statements about the stored procedures subroutine are correct
1. Stored procedures are executable server-side routines
2. Stored procedures can be used as a security layer
3. Stored procedures cannot be used to perform input validation
4. Stored procedures save CPU resources by re-using previously cached execution plans
Answers
Answered by
2
Stored procedures save CPU resources by re-using previously cached execution plans.
Option (4) is correct.
Explanation:
- SQL stands for Structured Query Language.
- By using this language, one can access and manipulate the data.
- CU resources can use the SQL language procedures and also allows you to access the resources.
- In computer programs, it is used to elicit the data information from databases.
- In simple words, it is also known as a computer programming language or query language.
Similar questions