The city table has the following structure:
Consider the following statement:
PREPARE CountryBylD FROM ‘SELECT Country FROM City WHERE ID=?
An error will be issued when the above statement is executed because there is no country city table, and the prepared statement will not be successfully defined.
What will occur if a prepared statement named CountryBylD already exists and the above statement is executed?
A.
An error will be issued because a prepared statement with the same name already exists.
B.
An error will be issued because the new prepared statement contains an error, and the old prepared statement definition will remain in effect.
C.
An error will be issued because the new prepared statement contains an error, and no prepared statement named CountryBylD will exist.
Explanation:
It will delete the existing prepared statement before trying to create the new one. This fails so no prepared statement.