QUESTION: 9

Which three factors are considered when choosing a column as a primary index? (Choose three.)

data type
frequency of access
stability of the data values
distribution across the AMPs

Answer(s): B,C,D

Reveal Solution Next Question

QUESTION: 10

Which two factors are considered in Usage Demographics of a column? (Choose two.)

frequency of change
frequency of loading data
frequency of join access in SQL queries
frequency of value access in SQL queries

Answer(s): C,D

Reveal Solution Next Question

QUESTION: 11

When analyzing volatility as a factor for choosing indexes, what are you measuring?

how unique the column values are
how frequently the column value changes
how frequently the column is used for access
the difference between the maximum and minimum values

Answer(s): B

Reveal Solution Next Question

QUESTION: 12

Referential Integrity (RI) is defined on a table WITH CHECK option. An implicit transaction with multiple inserts is submitted against the table.
What happens when one insert violates the RI?

All the rows inserted are rolled back and an abort message is issued.
An error table is created with a copy of offending column(s) that violated RI.
All rows are inserted. An error message informs the user of which row is the problem rowthat needs to be fixed.
All rows except the one violator are inserted. An error message informs the user whichrow did not get inserted.

Answer(s): A

Reveal Solution Next Question

Free NR0-015 Exam Braindumps (page: 4)

QUESTION: 9

QUESTION: 10

QUESTION: 11

QUESTION: 12

NR0-015 Discussions & Posts