Download IBM.C2090-560.Pass4Sure.2019-02-27.134q.tqb
| Vendor: | IBM |
| Exam Code: | C2090-560 |
| Exam Name: | PureData System for Analytics v7.1 |
| Date: | Feb 27, 2019 |
| File Size: | 1014 KB |
Demo Questions
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
Correct answer: B
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
Correct answer: A
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
Correct answer: C
