P2090-050 Exam Questions

On which component(s) does the UDX run?

Which procedural logic is NOT supported by NZPLSQL?

Which attribute CANNOT be defined for both users and groups?

Zone Maps provide what information about a table?

What is the maximum number of databases that can be created?

When working with sequences, which statement will always be true?

What is a characteristic of a column that is based on the TIMESTAMP datatype?

Which will result in support for zonemaps on the LastName column?

What is the maximum number of columns you can choose as organizing keys for clustered base table?

Which clause CANNOT be used with a CREATE VIEW statement?

Which command is used to abort a user's SQL transaction?

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...

What is the only predefined database user, which is able to access all objects and perform all tasks against the database?

What operating system runs on a PureData System for Analytics host?

What PureData System for Analytics component is responsible for controlling table storage?

OLE-DB based applications requires which PureData System for Analytics software?

Which statement is NOT true regarding the nzload utility?

When unloading data via an external table, where can the SQL be submitted?

Which file format is NOT supported by the nzload utility?

Which statement is NOT true?

Which statement is NOT true?

Within a single PureData System for Analytics, what is the fastest way to copy a 10TB TableA from DatabaseA to another DatabaseB?

What function can nzrestore perform?

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....

When enabled, query history always collects information about login failures, session creation, session termination, and query history process startup. Which area does query histor...