Which of the following statements will successfully insert data into the table?

exams C2090-320 C2090-320 exam 0 Comments

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?
A . INSERT INTO… (COL1) VALUES(HEX(‘12345’));
B . INSERT INTO… (COL1) VALUES(BLOB(‘12345’));
C . INSERT INTO… (COL1) VALUES(CHAR(‘12345’));
D . INSERT INTO… (COL1) VALUES(BINARY(‘123456’));

Answer: C