QUESTION: 5

What are two characteristics of an aggregate join index? (Choose two.)

Can be directly referenced by a query
Must contain more than one table reference
Can be created using a Global Temporary table
Automatically reflects changes in the underlying detail data
COUNT is automatically present if SUM is used

Answer(s): D,E

QUESTION: 6

Which four factors are important to consider when deciding whether to calculate summary results on demand or to create a summary table? (Choose four.)

Concurrency of users
Typical rows per value
Response time requirements
Complexity of the calculations
Frequency of summary request
Volatility of the column to summarize

Answer(s): C,D,E,F

Reveal Solution Next Question

QUESTION: 7

Why should you create a view with aggregation? (Choose two.)

To reduce query complexity
To minimize macro executions
To improve query performance
To minimize summary table maintenance

Answer(s): A,D

Reveal Solution Next Question

QUESTION: 8

To ensure you are working with current, consistent data, which lock should you recommend form SELECT queries in a multi-user environment with update activity?

Read
Write
Access
Exclusive

Answer(s): A

Reveal Solution Next Question

Free NR0-016 Exam Braindumps (page: 3)

QUESTION: 5

QUESTION: 6

QUESTION: 7

QUESTION: 8

NR0-016 Discussions & Posts