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 displayed in order of increasing part numbers whenever the table is queried. Which of the following create index statements will meet this criteria and require the least amount of storage for the index object?（） -题库考试答案搜索网

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 displayed in order of increasing part numbers whenever the table is queried. Which of the following create index statements will meet this criteria and require the least amount of storage for the index object?（）

单选题

2021-12-31 19:31

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)

查看答案

正确答案

试题解析

标签： IBM(000-730)

感兴趣题目

An administrator must assign static IP addresses to the servers in a network.For network 192.168.20.24/29, the router is assigned the first usable host address while the sales server is given the last usable host address. Which of the following should be entered into the IP propertied box for the sales server?（）

Given the host IP address of 192.168.100.60 and a network mask of 255.255.255.224 (or /27), which address represents the correct network address for the referenced host?（）

“Full speed ahead” and “Full speed astern” are（）given by the officers or the pilots.

Which of the following might be the best title for the passage?

（）is the budgeted amount for the work actually completed on the schedule activity or WBS component during a given time period.

is the budgeted amount for the work actually completed on the schedule activity or WBS component during a given time period．

is the budgeted amount for the work actually completed on the schedule acticity or WBS comonent during a given period。

（）, or drum is used for hauling in or letting out the wires or ropes which will fasten the ship to the shore.

The （） is used for hauling in or letting out the wires or ropes.

The man page for command shows the following syntax: The man page for command shows the following syntax: command [ -a | -b ] Which of the following statements is true regarding this entry?（）

No（）payable for loss resulting from delay or delivery unless a notice has been given in writing to the carrier within 60 consecutive days after the day the goods were handed over to the consignee.