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)
|
Download Printable PDF. VALID exam to help you PASS. |
 |