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...

Continue reading

The maximum size for each partition of a partition-by-range table space, with fewer than 255 partitions, is determined by which combination of options? (Choose two.)

The maximum size for each partition of a partition-by-range table space, with fewer than 255 partitions, is determined by which combination of options? (Choose two.)A . DSSIZEB . PRIQTYC . NUMPARTSD . BUFFERPOOLE . MAXPARTITIONS View Answer Answer: AC Explanation: Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/sqlref/src/tpc/ db2z_sql_createtablespace.html...

Continue reading