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

What are two effects of adding columns to an index? (Choose two.)

  1. The index selectivity does not change.
  2. Usually there will be more base table rows per index entry.
  3. Usually there will be fewer base table rows per index entry.
  4. SQL not referencing the added columns will not use the index.

Answer(s): C,D



Why would you add a join index to a set of tables?

  1. to enforce data uniqueness
  2. to ensure same distribution of both tables
  3. to enforce Referential Integrity across tables
  4. to decrease response time on well known queries

Answer(s): D



You should consider using value-ordered NUSIs when you have a high number of _____.

  1. updated rows
  2. joins in queries
  3. concurrent queries
  4. range constraint queries

Answer(s): D



When would a query benefit from a fully covering join index?

  1. when the base table is small enough to fit in cache
  2. when there is an unpredictable selection of columns from the base table
  3. when the result set is produced through either join or selection criteria on the base tables'primary index(es)
  4. when relatively few columns are in the result and join or selection criteria includes valuesother than the base tables' primary index(es)

Answer(s): D






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

NR0-015 Discussions & Posts