1z1-882 Real Exam Prep DEMO

Question 1: The city table has the following structure:
Consider the statement with an incorrect field name:
PREPARE countryBYID FROM 'SELECT country FROM city WHERE ID=?,
What happens if a prepared statement named countryByID already exists when the above statement
is executed?
A. A duplicate name error will result because a prepared statement with the same name already
exists.
B. An unknown column error will result and the old prepared statement definition will remain in
effect.
C. An unknown column error will result and no prepared statement named countryByID will exist.
D. A warning will result and the old prepared statement definition will remain in effect.
Correct Answer: C