CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. TeraData
  5. NR0-015

Free NR0-015 Exam Braindumps (page: 6)

Page 5 of 28
PDF with 110 Questions

Which two statements are true for primary keys as compared to primary indexes? (Choose two.)

  1. The data values may not be null.
  2. The data values may change over time.
  3. The first objective is to control row distribution.
  4. They are logical constructs which ensure uniqueness.

Answer(s): A,D



What are two reasons for the primary index columns to be different from the primary key columns? (Choose two.)

  1. join performance
  2. to increase volatility
  3. known access paths
  4. to enforce uniqueness

Answer(s): A,C



What are two characteristics of highly non-unique primary index values? (Choose two.)

  1. maximize parallel processing
  2. cause efficient distribution among AMPs
  3. cause multiple data blocks to be used and incur multiple I/Os
  4. cause database full condition on AMPs where excessive number of rows are stored

Answer(s): C,D



What are three criteria in choosing a primary index? (Choose three.)

  1. must be primary key
  2. volatility of data values
  3. reasonable distribution
  4. must ensure row uniqueness
  5. most frequently accessed column(s)

Answer(s): B,C,E






Post your Comments and Discuss TeraData NR0-015 exam with other Community members:

NR0-015 Discussions & Posts