Free 510-702 Exam Braindumps (page: 9)

Page 8 of 30

Which of the following indexes can be created UNIQUE?

  1. CMP
  2. HG
  3. HNG
  4. FP

Answer(s): B



Which type of index should be declared on all key/join columns, regardless of cardinality?

  1. CMP
  2. HG
  3. HNG
  4. LF

Answer(s): B



What indexes will be created on the column COUNTRY_ID when the following statement is run?
(Choose 2) CREATE TABLE T_COUNTRY (COUNTRY_ID integer IQ UNIQUE(500), COUNTRY_NAME varchar(100) IQ UNIQUE(500), primary key(COUNTRY_ID))

  1. FP(1)
  2. FP(2)
  3. FP(3)
  4. Unique LF
  5. Unique HG

Answer(s): B,E



Which index consists of a B-tree with a G-Array (group array)?

  1. FP
  2. LF
  3. HG
  4. HNG

Answer(s): C






Post your Comments and Discuss Sybase 510-702 exam with other Community members:

510-702 Exam Discussions & Posts