Question

A stored routine is a set of SQL statements stored on the server and takes form as either a procedure or a function. Which statement cannot be used inside stored routines?

a) SELECT
b) UPDATE
c) DELETE
d) COMMIT

Answer 1

A stored routine is a set of SQL statements stored on the server and can take the form of either a procedure or a function. The COMMIT statement cannot be used inside stored routines.

Step-by-step explanation:

A stored routine is a set of SQL statements stored on the server, and it can take the form of either a procedure or a function. Inside a stored routine, you can use SELECT, UPDATE, and DELETE statements to manipulate data in the database. However, the statement that cannot be used inside stored routines is the COMMIT statement.