IBM C2090-560 Exam Actual Questions

The questions for C2090-560 were last updated on Nov. 20, 2024.

Viewing page 1 out of 34 pages.
Viewing questions 1-4 out of 134 questions

Topic 1 - Single Topic

Question #1 Topic 1

Which statement regarding temporary tables is TRUE?

A. They are limited to 1 terabyte in size
B. They may include a DISTRIBUTE ON clause
C. They are limited to 16 tables per user per database
D. They will be included in any nzbackup of the database

Reveal Solution Discussion

Correct Answer: B 🗳️

Question #2 Topic 1

Which procedural logic is NOT supported by NZPLSQL?

A. Scrollable cursors
B. Looping (while, for)
C. Conditionals (if, else)
D. Returning a scalar result or result set

Reveal Solution Discussion

Correct Answer: A 🗳️

Question #3 Topic 1

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

A. At installation the initial rowid value is 100,000
B. Rowid values are sequential across each table
C. The system automatically assigns values for the column
D. The host assigns a range of sequential rowids to each SPU

Reveal Solution Discussion

Correct Answer: C 🗳️

Question #4 Topic 1

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

A. They are automatically selected by the system
B. They are always based on the samecolumns as the table's distribution key
C. They are added via the ALTER TABLE ADD INDEX(column_name) statement
D. They are added via the ALTER TABLE ADD ZONEMAP(column_name) statement

Reveal Solution Discussion

Correct Answer: A 🗳️