【单选题】Given the following DDL for the PARTS table:CREATE TABLE parts (part_no INT(9) NOT NULL, part_name VARCHAR(24), part_remain INT(9));All part numbers entered will be different and all rows should be di...
A.
CREATE UNIQUE INDEX idx_partno ON parts(part_no)
B.
CREATE UNIQUE INDEX idx_partno ON parts(part_name ASC)
C.
CREATE UNIQUE INDEX idx_partno ON parts(part_name, part_no ASC)
D.
CREATE UNIQUE INDEX idx_partno ON parts(part_no, part_name ASC)