Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home IBM C2090-560

IBM C2090-560 Exam Practice Questions (P. 1)

  • Full Access (134 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #1
Which statement regarding temporary tables is TRUE?
  1. A
    They are limited to 1 terabyte in size
  2. B
    They may include a DISTRIBUTE ON clause
  3. C
    They are limited to 16 tables per user per database
  4. D
    They will be included in any nzbackup of the database

Correct Answer:
B

Question #2
Which procedural logic is NOT supported by NZPLSQL?
  1. A
    Scrollable cursors
  2. B
    Looping (while, for)
  3. C
    Conditionals (if, else)
  4. D
    Returning a scalar result or result set

Correct Answer:
A

Question #3
Which of the following properties about the rowid column is FALSE?
  1. A
    At installation the initial rowid value is 100,000
  2. B
    Rowid values are sequential across each table
  3. C
    The system automatically assigns values for the column
  4. D
    The host assigns a range of sequential rowids to each SPU

Correct Answer:
C

Question #4
Columns in a table may be zone mapped. How are those columns chosen?
  1. A
    They are automatically selected by the system
  2. B
    They are always based on the samecolumns as the table's distribution key
  3. C
    They are added via the ALTER TABLE ADD INDEX(column_name) statement
  4. D
    They are added via the ALTER TABLE ADD ZONEMAP(column_name) statement

Correct Answer:
A

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. A
    The default value for this variable is FALSE
  2. B
    This variable controls whether the system allows users to create and manage multiple schemas
  3. C
    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. D
    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

Correct Answer:
B

Next Questions

All Pages