User USER1 wants to store part numbers and part descriptions in a table named PARTS; user
USER1 also wants to ensure that any comparisons of part descriptions that are made will be done
so in binary, regardless of the database collating sequence used. Which statement should user
USER1 execute to create the desired table?
A.
CREATE TABLE parts
(part_no INTEGER,
desc CLOB))
B.
CREATE TABLE parts
(part_no INTEGER,
desc VARCHAR(200))
C.
CREATE TABLE parts
(part_no INTEGER,
desc CLOB FOR BIT DATA))
D.
CREATE TABLE parts
(part_no INTEGER,
desc VARCHAR(200) FOR BIT DATA)
Explanation: