QUESTION: 41

Which two statements about USI maintenance are correct? (Choose two.)

A separate Transient Journal entry is required for a changed USI row.
Updating the PI of a base row requires relocating the corresponding USI row.
Updating the USI value of the base row requires relocating the corresponding USI row.
Updating the UPI value of the base row requires relocating the corresponding USI row.

Answer(s): A,C

Reveal Solution Next Question

QUESTION: 42

What is the first stage where you make decisions to take full advantage of Teradata parallelism?

Design of the LDM
Design of the PDM
Design of the OLAP
Design of the ELDM
Design of the application code

Answer(s): B

Reveal Solution Next Question

QUESTION: 43

When creating multiple triggers on the same table, which three conditions must exist so that an ORDER clause can guarantee the correct sequencing of the triggered actions? (Choose three.)

They must have the same trigger type.
They must share the same trigger event.
They must have the same trigger action time.
They must affect the same triggered columns.
They must share the same trigger WHEN condition.

Answer(s): A,B,C

Reveal Solution Next Question

A developer has written several SQL statements. Each statement generates the same report format for different departments and is run at different times. How could the developer simplify this process, retain the efficiency of the SQL, and keep the source secure?

Create a parameterized macro
Create a PP2 program using COBOL
Create a parameterized stored procedure
Create a global temporary table to hold the result

Answer(s): A

Reveal Solution Next Question

Free NR0-016 Exam Braindumps (page: 12)

QUESTION: 41

QUESTION: 42

QUESTION: 43

QUESTION: 44

NR0-016 Discussions & Posts