QUESTION: 33

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

All rows with the same NUPI value always end up in the same datablock.
Adding a second column to the NUPI generally reduces the number of rows per primary index value.
A large table with fewer unique NUPI values than there are AMPs in the system can still have an even distribution.
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?

Full scan on a single AMP
Hash lookup on each AMP
Value lookup on every AMP
Single partition scan on every AMP
Single partition scan on a single AMP

Answer(s): D

Reveal Solution Next Question

QUESTION: 35

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

When a Partitioned Primary Index (PPI) is desired for the table
When a foreign key is desired for the table
When a primary key is desired for the table
When a primary index is desired for the table
When a unique secondary index is desired for the table

Answer(s): C,D,E

Reveal Solution Next Question

QUESTION: 36

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

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

Answer(s): A,B

Reveal Solution Next Question

Free NR0-016 Exam Braindumps

QUESTION: 33

QUESTION: 34

QUESTION: 35

QUESTION: 36

NR0-016 Discussions & Posts