Oracle
1Z0-882 · Question #99
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…
The correct answer is C. The server returns a warning and the empty string is inserted to the `gender' column. See the full explanation below for the reasoning.
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
How the community answered
(44 responses)- A2% (1)
- B7% (3)
- C77% (34)
- D14% (6)
Community Discussion
No community discussion yet for this question.