IBM Netezza Technical Mastery v1 Set 1

1 ✘ 2 ✘ all ✘

You must first run the nzstop command as the nz user from the host command line. ✘ GROOM can materialize the results of previous ALTER TABLE ADD/DROP column commands. ✘ The table being groomed will be locked exclusively during the groom operation. ✘ GROOM is an administrative command that must be run by a DBA. ✔

Privileges are additiveou cannot remove a privilege from a user who has been granted that privilege as a member of a group. ✘ Object owners automatically have full access to their objects. ✘ Users with privileges on an object can pass that object to others by default. ✘ By default, newly created objects have no privileges associated with them. ✔

SELECT INTO #TEMPTABLE col1, col2 FROM MYTABLE;

✘

CREATE TEMP TABLE AS TEMPTABLE SELECT col1, col2 FROM MYTABLE;

✘

CREATE TEMPORARY TABLE MYTABLE SAMEAS MYOTHERTABLE;

✘ None of the above. ✔

ZoneMaps are not used at all. ✘ ZoneMaps are used in the exact same way as in any other distribution. ✘ ZoneMaps are used only when statistics are not up to date. ✘ None of the above. ✔

Querying external tables is about the same speed as querying normal tables. ✘ Loading data via external tables is about the same speed as using the native nzload utility. ✘ External tables can be used to load remote data files via an ODBC or JDBC connection. ✘ External tables can be used to load or unload data from Netezza. ✔

The only difference between EXPRESS and FULL statistics is how dispersion is calculated. ✘ The user can specify whether FULL or EXPRESS statistics are calculated. ✘ ZoneMaps are disabled for the duration of the GENERATE STATISTICS command. ✘ It requires specific permissions. ✔

exactly one snippet is generated representing the entire query ✘ one snippet is generated for each join within the query ✘ the number of snippets generated depends on a number of factors, including the complexity of the query ✘ one snippet is generated for each TB of data scanned ✔

Netezza is a columnar database. ✘ Netezza is a row-based database. ✘ Netezza uses a form of columnar compression, but stores data in a row based format. ✘ Netezza stores data in a format determined by ZoneMaps. ✔

Multiversioning ✘ Two-phase commit ✘ Locking ✘ Round-robin ✔