下列关于CREATE UNIQUE INDEX IDX1 ON T(C1，C2)语句作用的说法，正确的是（）。..

第1题

[] 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?（）

A、A.CREATE UNIQUE INDEX idx_partno ON parts(part_no) B、B.CREATE UNIQUE INDEX idx_partno ON parts(part_name ASC) C、C.CREATE UNIQUE INDEX idx_partno ON parts(part_name, part_no ASC) D、D.CREATE UNIQUE INDEX idx_partno ON parts(part_no, part_name ASC)

点击查看答案

第2题

[单选题] Given the following requirements:Create a table named TESTTAB, which has an identity column named ACTIVITYNO. Define the identity column to generate the values for the column by default. Start the values at 10 and increment by 10. Make the identity column unique. Which of the following CREATE statements will successfully create this table?（）

A、CREATE TABLE TESTTAB (ACTIVITYNO SMALLINT NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 10 INCREMENT BY 10), ACTKWD CHAR(6) NOT NULL, ACTDESC VARCHAR(20) NOT NULL, UNIQUE(ACTIVITYNO)) B、CREATE TABLE TESTTAB (ACTIVITYNO SMALLINT NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 10), ACTKWD CHAR(6) NOT NULL, ACTDESC VARCHAR(20) NOT NULL, UNIQUE(ACTNO)) C、CREATE TABLE TESTTAB (ACTIVITYNO SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 10 INCREMENT BY 1), ACTKWD CHAR(6) NOT NULL, ACTDESC VARCHAR(20) NOT NULL, UNIQUE(ACTIVITYNO)) D、CREATE TABLE TESTTAB (ACTIVITYNO SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 10 INCREMENT BY 10), ACTKWD CHAR(6) NOT NULL, ACTDESC VARCHAR(20) NOT NULL, UNIQUE(ACTIVITYNO))

点击查看答案

第3题

[单选题] Table TAB1 was created using the following statement: CREATE TABLE tab1 (c1 INT, c2 INT, c3 INT, c4 INT, c5 INT); If column C1 is unique and queries typically access columns C1 and C2 together, which statement(s) will create index(es) that will provide optimal query performance? （）

A、 CREATE UNIQUE INDEX xtab1 ON tab1 (c1) include (c2) B、 CREATE UNIQUE INDEX xtab1 ON tab1 (c1); CREATE INDEX xtab2 ON tab1 (c3) INCLUDE (c2) C、 CREATE UNIQUE INDEX xtab1 ON tab1 (c2, c1) D、 CREATE UNIQUE INDEX xtab1 ON tab1 (c2) INCLUDE (c1）

点击查看答案

第4题

[多选题] You administer a network with Windows-based endpoints that have custom software images. You want to use Host Checker to require that endpoints are running the custom software image.Which two Host Checker policy rules would be used to enforce this requirement?（）

A、Isolate a file name unique to the custom image and create a custom rule-type of "File" which matches on the file. Select the "Required" option under the custom rule. B、Identify the MAC address unique to network cards installed in PCs with the custom image and create a custom rule-type of "MAC Address" which matches on the appropriate MAC address. C、Select the "Required" option under the custom rule Identify the IP address unique to the network cards installed in PCs with the custom image and create a custom rule-type of "IP Address" which matches on the appropriate IP address. Select the "Required" option under the custom rule. D、Isolate or create a unique Windows registry key for the custom image and create a custom rule- type of "Registry Setting" which matches on the name of the registry key.

点击查看答案

第5题

[单选题] Table TAB1 was created using the following statement: CREATE TABLE tab1 (c1 INT, c2 INT, c3 INT, c4 INT, c5 INT); If column C1 is unique and queries typically access columns C1, C2 and C3 together, which statement(s) will createindex(es) that will provide optimal query performance?（）

A、CREATE UNIQUE INDEX xtab1 ON tab1 (c1); CREATE INDEX xtab2 ON tab1 (c2) INCLUDE (c3) B、CREATE UNIQUE INDEX xtab1 ON tab1 (c1) INCLUDE (c2, c3) C、CREATE UNIQUE INDEX xtab1 ON tab1 (c3, c2, c1) D、CREATE UNIQUE INDEX xtab1 ON tab1 (c2) INCLUDE (c1, c3)

点击查看答案

第6题

[多选题] For which two constraints does the Oracle Server implicitly create a unique index? （）

A、NOT NULL B、PRIMARY KEY C、FOREIGN KEY D、CHECK E、UNIQUE

点击查看答案

第7题

[多选题] For which two constraints does the Oracle Server implicitly create a unique index? （）

A、NOT NULL B、PRIMARY KEY C、FOREIGN KEY D、CHECK E、UNIQUE

点击查看答案

第8题

[多选题] Which two statements are true about constraints? （）

A、The UNIQUE constraint does not permit a null value for the column. B、A UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints. C、The PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index. D、The NOT NULL constraint ensures that null values are not permitted for the column.

点击查看答案

第9题

[多选题] Which two statements are true about constraints? （）

A、The UNIQUE constraint does not permit a null value for the column. B、A UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints. C、The PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index. D、The NOT NULL constraint ensures that null values are not permitted for the column.

点击查看答案

第10题

[多选题] Which two statements are true about constraints? （）

A、The UNIQUE constraint does not permit a null value for the column. B、A UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints. C、The PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index. D、The NOT NULL constraint ensures that null values are not permitted for the column.

点击查看答案

下列关于CREATE UNIQUE INDEX IDX1 ON T(C1，C2)语句作用的说法，正确的是（）。

请使用微信扫码支付