To how many of the following does the prepared-statement API apply to?

CREATE TABLE, DELETE, DO, INSERT

A. 1

B. 2

C. 3

D. 4

Answer: Option B

Solution(By Examveda Team)

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.