移动端

  • 题王微信公众号

    题王微信公众号

    微信搜“题王网”真题密题、最新资讯、考试攻略、轻松拿下考试

单选题

View the Exhibit and examine the structure of the EMP table. You executed the following command to add a primary key to the EMP table:   ALTER TABLE emp   ADD CONSTRAINT emp_id_pk  PRIMARY KEY (emp_id)   USING INDEX emp_id_idx;   Which statement is true regarding the effect of the command?()

发布日期:2022-07-17

View the Exhibit and examine the structure of the ...
A

The PRIMARY KEY is created along with a new index.

B

The PRIMARY KEY is created and it would use an existing unique index.

C

The PRIMARY KEY would be created in a disabled state because it is using an existing index.

D

The statement produces an error because the USING clause is permitted only in the CREATE TABLE command.

标签: "暂无标签"

题王网让考试变得更简单

扫码关注题王,更多免费功能准备上线!