可学答题网 > 问答 > 1Z0-047题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

View the Exhibit and&e


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.
参考答案
参考解析:
分类:1Z0-047题库
相关推荐

1、View the Exhibit and&e

View the Exhibit and examine the Flashback SCNs. A user has inserted wrong department data&ensp...

2、View the Exhibit and&e

View the Exhibit and examine the parameters.User A executes the following command to update the...

3、View the Exhibit and&e

View the Exhibit and examine the properties of the TT tablespace. Using Database Control, you&...

4、View the Exhibit and&e

View the Exhibit and examine the structure of the ORDERS table.Which task would require subquer...

5、View the Exhibit and&e

View the Exhibit and examine the attributes of an undo tablespace. In an OLTP system, the&...

6、View the Exhibit and&e

View the Exhibit and examine the data in ORDERS_MASTER and MONTHLYjDRDERS tables.What would be ...