Free NR0-016 Exam Braindumps (page: 2)

Page 1 of 28

Which two types of journals can be defined for a table? (Choose two.)

  1. Transient LOCAL AFTER JOURNAL
  2. Transient UPDATE ONLY JOURNAL
  3. Permanent UPDATE ONLY JOURNAL
  4. Permanent LOCAL AFTER JOURNAL
  5. Permanent DUAL BEFORE JOURNAL

Answer(s): D,E



Which type of processing workload is least likely to justify the cost of upgrading a system?

  1. Executive report
  2. Daily sales report
  3. Quarter end report
  4. Nightly batch process

Answer(s): C



How are Volatile tables similar to Derived tables? (Choose three.)

  1. Are local to the query
  2. Table definition kept in memory
  3. Are designed for optimal performance
  4. Have no Data Dictionary access or transaction locks

Answer(s): B,C,D



Which two utilities can you use to export data for a report using RECORD mode rom the Teradata database? (Choose two.)

  1. BTEQ
  2. TPump
  3. FastExport
  4. Teradata SQL Assistant

Answer(s): A,C






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

NR0-016 Discussions & Posts