Question 1
Which statement regarding temporary tables is TRUE?
- They are limited to 1 terabyte in size
- They may include a DISTRIBUTE ON clause
- They are limited to 16 tables per user per database
- They will be included in any nzbackup of the database
Question 2
Which procedural logic is NOT supported by NZPLSQL?
- Scrollable cursors
- Looping (while, for)
- Conditionals (if, else)
- Returning a scalar result or result set
Question 3
Which of the following properties about the rowid column is FALSE?
- At installation the initial rowid value is 100,000
- Rowid values are sequential across each table
- The system automatically assigns values for the column
- 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?
- They are automatically selected by the system
- They are always based on the samecolumns as the table's distribution key
- They are added via the ALTER TABLE ADD INDEX(column_name) statement
- 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.
- The default value for this variable is FALSE
- This variable controls whether the system allows users to create and manage multiple schemas
- 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
- 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