Vidyalelo
MySQL · Q23

MySQL

Programming · MySQL · question 23

Q23

To how many of the following does the prepared-statement API apply to? CREATE TABLE, DELETE, DO, INSERT

A.
1
B.
2
Answer
C.
3
D.
4

Answer: Option B

Solution

Answer: Option B
Solution:
The prepared-statement API applies to INSERT and DELETE statements among the given options.
Prepared statements allow for precompilation of SQL statements, providing performance benefits by reducing parsing overhead, and they can be reused with different parameter values.
However, the prepared-statement API does not directly apply to CREATE TABLE or DO statements.
Therefore, it applies to two of the provided statements.