Oracle
1Z0-882 · Question #99
1Z0-882 Question #99: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-882 to reveal the answer and full explanation for question #99. The question stem and answer options stay visible for context.
Question
You started a MySQL command -Line session with sq1_ mode (empty), and created the person table with the structure: Mysql> DESC person; You issue: INSERT INTO person VALUES (
casper', undefined') What is the effect?Options
- A
Casper' andundefined values are inserted into the `name' and gender' column. - BThe server returns an error indicating that `undefined' cannot be inserted into a column of ENUM
- CThe server returns a warning and the empty string is inserted to the `gender' column.
- DThe server returns a warning and the first specified value ,"male" is inserted to the gender
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.