Free NR0-016 Exam Braindumps

Which two statements regarding rows per NUPI value are true? (Choose two.)

  1. All rows with the same NUPI value always end up in the same datablock.
  2. Adding a second column to the NUPI generally reduces the number of rows per primary index value.
  3. A large table with fewer unique NUPI values than there are AMPs in the system can still have an even distribution.
  4. A SET table with many rows for each NUPI value has much worse insert performance than a MULTISET table with many rows for each NUPI value.

Answer(s): B,D



Consider the table t1 created as follows:
CREATE TABLE t1 (
ainteger, ddate,
vvarchar(100))
PRIMARY INDEX (a)
PARTITION BY RANGE_N(d BETWEEN
DATE '2002-01-01' AND DATE '2007-12-31' EACH '1' YEAR); andthe query:
SELECT v FROM t1 WHERE d = DATE '2003-08-17';
Which plan will the Optimizer use to find qualifying rows?

  1. Full scan on a single AMP
  2. Hash lookup on each AMP
  3. Value lookup on every AMP
  4. Single partition scan on every AMP
  5. Single partition scan on a single AMP

Answer(s): D



When can an identity column be useful in a table definition? (Choose three.)

  1. When a Partitioned Primary Index (PPI) is desired for the table
  2. When a foreign key is desired for the table
  3. When a primary key is desired for the table
  4. When a primary index is desired for the table
  5. When a unique secondary index is desired for the table

Answer(s): C,D,E



Consider the following identity column definition:
Col1 INTEGER GENERATED ALWAYS AS IDENTITY (MAXVALUE 100) Which two statements are true about Col1? (Choose two.)

  1. The first inserted row will have a value of 1.
  2. The table cannot have more than 100 rows.
  3. Deleted rows may be replaced in the sequence.
  4. By explicitly specifying values in the insert, it is possible to skip numbers in the sequence.

Answer(s): A,B






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

NR0-016 Discussions & Posts