P2090-050 Exam Questions
125 real P2090-050 exam questions with expert-verified answers and explanations. Page 3 of 3.
- Question #107
On which component(s) does the UDX run?
- Question #108
Which procedural logic is NOT supported by NZPLSQL?
- Question #109
Which attribute CANNOT be defined for both users and groups?
- Question #110
Zone Maps provide what information about a table?
- Question #111
What is the maximum number of databases that can be created?
- Question #112
When working with sequences, which statement will always be true?
- Question #113
What is a characteristic of a column that is based on the TIMESTAMP datatype?
- Question #114
Which will result in support for zonemaps on the LastName column?
- Question #115
What is the maximum number of columns you can choose as organizing keys for clustered base table?
- Question #116
Which clause CANNOT be used with a CREATE VIEW statement?
- Question #117
Which command is used to abort a user's SQL transaction?
- Question #118
Which command allows you to show information about the database hardware as well as take actions such as activate or deactivate components, locate components, or delete them from t...
- Question #119
What is the only predefined database user, which is able to access all objects and perform all tasks against the database?
- Question #120
What operating system runs on a PureData System for Analytics host?
- Question #121
What PureData System for Analytics component is responsible for controlling table storage?
- Question #122
OLE-DB based applications requires which PureData System for Analytics software?
- Question #123
Which statement is NOT true regarding the nzload utility?
- Question #124
When unloading data via an external table, where can the SQL be submitted?
- Question #125
Which file format is NOT supported by the nzload utility?
- Question #126
Which statement is NOT true?
- Question #127
Which statement is NOT true?
- Question #129
Within a single PureData System for Analytics, what is the fastest way to copy a 10TB TableA from DatabaseA to another DatabaseB?
- Question #130
What function can nzrestore perform?
- Question #131
An ETL/ODBC application is inserting 1 million records in a single transaction against the PureData System for Analytics. 1 million individual INSERT SQL statements are generated....
- Question #132
When enabled, query history always collects information about login failures, session creation, session termination, and query history process startup. Which area does query histor...