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…
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…
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
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…