多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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?()

  • 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.
正确答案:B
答案解析:
进入题库查看解析

微信扫一扫手机做题