C1000-085 Online Practice Questions and Answers

DRAG DROP

What is the order of the operations of a typical snippet in a query plan?

Select and Place:

What access is required to create a new user in IBM Netezza Performance Server?

A. An account with NEW USER administrative privilege

B. An account with CREATE USER administrative privilege.

C. An account with CREATE GROUP access on the host OS.

D. An account with CREATE ID access on the host OS.

When is a PRIMARY KEY (PK) table constraint evaluated during an INSERT statement into the table?

A. The PK constraint is never checked when a row is inserted into the table.

B. After the row is inserted into the table.

C. Before the row is inserted into the table.

D. The PK constraint is only checked during a GENERATE STATISTICS operation.

What is the maximum length of a CHAR/VARCHAR column?

A. 65.535

B. 32.000

C. 64,000

D. 16.000

Which date time format is used to capture history activities?

A. system time

B. local time

C. EST

D. GMT

What should be the state of the IBM Netezza Performance Server system in order to run the nz_manual_vacuum command?

A. online

B. running

C. stopped

D. paused

Consider a scenario where a customer has a FACT_SALES table with a column zip_code with data type char(5| They frequently restrict on this column, but the query is very inefficient.

What is the correct way to optimize this query without modifying the column?

A. Create a copy of FACT_SALES table with zip_code as integer data type.

B. alter table fact_sales to organize on zip_code. followed by groom.

C. CREATE ORGANIZED view for FACT_SALES table

D. Create a view with a typecast to integer and use view for query purposes

Which level of transaction isolation does IBM Netezza Performance Server implement?

A. uncommitted read

B. serializable

C. repeatable read D. committed read

Which command is used to register a user defined table function in the database?

A. CREATE FUNCTION

B. nzudxcompile

C. ALTER FUNCTION

D. ECHO

What is the purpose of the nzstate command?

A. restore the database to the last backup

B. list the state of the system

C. list the states of backups available

D. list the state of a running query