Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up

What is the main advantage of a prepared statement?

  1. A It runs faster on the first execution
  2. B It separates SQL structure from data, preventing SQL injection
  3. C It automatically creates indexes
  4. D It compresses the result set
Answer

It separates SQL structure from data, preventing SQL injection

Because values are sent separately from the query text, user input can never be parsed as SQL. Repeated execution of the same statement is also more efficient.

All MySQL MCQs

Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up as