IBM
C2090-320 · Question #84
The following definition for COL1 is given by this statement: CREATE TABLE... (COL1 BINARY (05)) Which of the following statements will successfully insert data into the table?
The correct answer is C. INSERT INTO... (COL1) VALUES(CHAR(`12345')). See the full explanation below for the reasoning.
Question
The following definition for COL1 is given by this statement:
CREATE TABLE... (COL1 BINARY (05)) Which of the following statements will successfully insert data into the table?
Options
- AINSERT INTO... (COL1) VALUES(HEX(`12345'));
- BINSERT INTO... (COL1) VALUES(BLOB(`12345'));
- CINSERT INTO... (COL1) VALUES(CHAR(`12345'));
- DINSERT INTO... (COL1) VALUES(BINARY(`123456'));
How the community answered
(32 responses)- A16% (5)
- B3% (1)
- C75% (24)
- D6% (2)
Community Discussion
No community discussion yet for this question.