A2090-560 Exam Questions
119 real A2090-560 exam questions with expert-verified answers and explanations. Page 3 of 3.
- Question #119
Which two statistical data points are automatically updated when performing an INSERT on a table? (Choose two.)
- Question #120
How does the PureData System for Analytics utilize the distribution key to store records on disk?
- Question #121
What should be considered when you are asked to select the distribution key columns for a very large fact table?
- Question #122
What is the host Linux file that must be modified to adjust optimizer settings permanently?
- Question #123
Which statement is true about the groom feature?
- Question #124
Why is generating statistics on a table important to query performance?
- Question #125
Using a date column as a distribution key may distribute rows evenly across dataslices, why is this a poor choice of a distribution key?
- Question #126
Which statement is true?
- Question #127
On which component(s) does the UDX run?
- Question #128
Which procedural logic is NOT supported by NZPLSQL?
- Question #129
Which attribute CANNOT be defined for both users and groups?
- Question #130
Zone Maps provide what information about a table?
- Question #131
What is the maximum number of databases that can be created?
- Question #132
When working with sequences, which statement will always be true?
- Question #133
When creating a table, you can specify a column constraint for each individual column of either "NULL" or "NOT NULL". When column values are later evaluated within a query statemen...
- Question #134
To create a database table, at a minimum, what must be specified?
- Question #136
Which two statements are true about queries on the PureData System for Analytics Appliance? (Choose two.)
- Question #137
Which statement describes administrative privileges?
- Question #138
The query history data collected DOES NOT provide insight to which of the type of performance and behavior questions?