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.

相关问题推荐

• During cluster fallover testing，the administrator determines that additional work is required to stop existing test applications on the standby node，prior to starting the production applications on the surviving node.  To manage this type of requirement，which step should be performed first？（）  

  A、 Create a custom pre/post event.

  B、 Add a custom user defined event.

  C、 Define custom error notification.

  D、 Modify the test application server.

  查看答案

• Which two statements describe the criteria bandwidth detection uses to dynamically alter bandwidth allocation?（）(Choose two.)

  A

  Throughput is raised as latency decreases.

  B

  Throughput is based on available bandwidth.

  C

  Throughput is lowered as latency decreases.

  D

  Latency is measured by SYNs returned for each metapacket

  查看答案

• Which three circumstances would prevent traceroute from displaying the WAN IP addresses? （）(Choose three)

  A

  The WAN link is down.

  B

  IPSec is enabled on the WX.

  C

  Traceroute is enabled for compression.

  D

  The network is configured using static routes.

  E

  The local and remote cables are accidentally swapped.

  查看答案

• According to Ohm’s Law， which of the following is correct？（）

  A、As voltage increases， resistance decreases

  B、As amperage decreases， resistance decreases

  C、As resistance decreases， amperage increases

  D、As resistance increases， voltage increases

  查看答案

• A cluster administrator has defined a custom error notification method that will email and  administrator when a temp error is detected on an individual hdisk. What method should be used to test this functionality？（）  

  A、 sendmail -bi

  B、 yes >/dev/kmem

  C、 emulate errlog entry

  D、 reducevg vgname hdisk#

  查看答案