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: 11)

Page 10 of 28
PDF with 110 Questions

Your application has found the Partitioned Primary Index to be useful for avoiding scans on large tables. It has also found that primary index access (without specifying the partition key) takes substantially longer.
Which option will improve this?

  1. COLLECT STATISTICS on the partitioning column
  2. create a non-unique secondary index on the partitioning key
  3. COLLECT STATISTICS on the primary index columns individually
  4. create a unique secondary index on the columns of the primary index

Answer(s): D



What is a user's MAXSPOOL?

  1. the number of bytes in use for resolving queries
  2. a value used to limit the number of bytes the system will allocate to create spool files for auser
  3. the maximum number of bytes used by a transaction for a user since the value was lastreset by the ClearPeakDisk macro
  4. the maximum number of bytes created in a spool reserve database to ensure all querieshave enough spool space to run efficiently

Answer(s): B



Which three statements are true concerning global temporary tables? (Choose three.)

  1. Global temporary tables provide the user with a place to store interim results.
  2. Global temporary tables can reduce the number of times the user needs to create and droptables.
  3. Global temporary tables require the user to have the necessary permanent space to storedata when the table is materialized.
  4. Global temporary tables have a persistent definition that is stored in the Data Dictionary, but their contents do not persist across sessions.

Answer(s): A,B,D



Which two statements are true about data marts? (Choose two.)

  1. Independent data marts are derived from the enterprise data warehouse.
  2. A data mart is generally a relatively small application-specific subset of the datawarehouse.
  3. Dependent data marts are isolated entities entirely separate from the enterprise datawarehouse.
  4. A logical data mart is a form of dependent data mart that is constructed virtually from thephysical data warehouse.

Answer(s): B,D






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

NR0-015 Discussions & Posts