Oracle
1Z0-882 · Question #14
1Z0-882 Question #14: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-882 to reveal the answer and full explanation for question #14. The question stem and answer options stay visible for context.
Question
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?
Exhibit
Options
- AA duplicate name error will result because a prepared statement with the same name already
- BAn unknown column error will result and the old prepared statement definition will remain in
- CAn unknown column error will result and no prepared statement named countryByID will exist.
- DA warning will result and the old prepared statement definition will remain in effect.
Unlock 1Z0-882 to see the answer
You've previewed enough free 1Z0-882 questions. Unlock 1Z0-882 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.