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

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’));

View Answer

Answer: C