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 VARCHAR(200) FOR BIT DATA)
B.
CREATE TABLE parts (part_no INTEGER, desc CLOB FOR BIT DATA))
C.
CREATE TABLE parts (part_no INTEGER, desc VARCHAR(200))
D.
CREATE TABLE parts (part_no INTEGER, desc CLOB))
FOR BIT DATA
Specifies that the contents of the column are to be treated as bit (binary) data. During data exchange with other systems, code page conversions are not performed. Comparisons are done in binary, irrespective of the database collating sequence.
0
0