PrepAway - Latest Free Exam Questions & Answers

Which statement should user USER1 execute to create the desired table?

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?

PrepAway - Latest Free Exam Questions & Answers

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:


Leave a Reply