C2090-560

Review 134 C2090-560 practice questions with answer explanations and community insights.

Question 1

Which statement regarding temporary tables is TRUE?

  1. They are limited to 1 terabyte in size
  2. They may include a DISTRIBUTE ON clause
  3. They are limited to 16 tables per user per database
  4. They will be included in any nzbackup of the database

Question 2

Which procedural logic is NOT supported by NZPLSQL?

  1. Scrollable cursors
  2. Looping (while, for)
  3. Conditionals (if, else)
  4. Returning a scalar result or result set

Question 3

Which of the following properties about the rowid column is FALSE?

  1. At installation the initial rowid value is 100,000
  2. Rowid values are sequential across each table
  3. The system automatically assigns values for the column
  4. The host assigns a range of sequential rowids to each SPU

Question 4

Columns in a table may be zone mapped. How are those columns chosen?

  1. They are automatically selected by the system
  2. They are always based on the samecolumns as the table's distribution key
  3. They are added via the ALTER TABLE ADD INDEX(column_name) statement
  4. They are added via the ALTER TABLE ADD ZONEMAP(column_name) statement

Question 5

Select the statement about the ENABLE_USER_SCHEMA variable that is TRUE in a system using Netezza Performance Server Release 7.0.3 or higher.

  1. The default value for this variable is FALSE
  2. This variable controls whether the system allows users to create and manage multiple schemas
  3. If the variable is set to TRUE and the user does not specify a schema, the system will connect to the default schema for the database
  4. If the variable is set to FALSE and the user does not specify a schema, the system will connect to a schema that matches the database user name
We are moving to a new platform

CertificationTest is being migrated. Some pages may be slow or briefly unavailable; everything will be back to normal within a few hours. If you run into any issue, email support@certificationtest.net.