Free NR0-014 Exam Braindumps (page: 8)

Page 7 of 26

Which DBSControl parameter controls the maximum size of a datablock in a table?

  1. DBSize
  2. MaxDBSize
  3. PermDBSize
  4. PermDBAllocUnit

Answer(s): C



What is the effect of setting the FreeSpacePercent parameter of the DBSControl utility to 15%?

  1. Each user is limited to 15% of memory for their active work space.
  2. Cylinders are loaded to 85% of their capacity during load operations.
  3. Spool files are not created when there is less than 15% free space on an AMP.
  4. Table blocks are written with 15% of the space left in the block for more rows to be inserted.

Answer(s): B



Which three functions can be performed using the Teradata Administrator tool? (Choose three.)

  1. clone users
  2. abort a user session
  3. grant MONITOR privileges to a user
  4. copy DDL from one system to another
  5. copy table data from one system to another

Answer(s): A,C,D



What is input to the Teradata Visual Explain utility?

  1. Visual Explain Table (VET)
  2. Query Capture Table (QCT)
  3. Visual Explain Database (VED)
  4. Query Capture Database (QCD)

Answer(s): D






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

NR0-014 Discussions & Posts