IBM C2090-560 Certification Practice Questions & Answers

Question 6 of 134

When using a CREATE TABLE statement, constraints can be specified at the column level. Which two constraints are NOT automatically enforced via the database? (Choose two.)

Question 7 of 134

What is the host Linux file that must be modified to permanently adjust optimizer settings such as enabling schema support?

A.

/nz/data/postgresql.conf

B.

/nz/data/config/system.cfg

C.

/nz/kit/sys/initTopology.cfg

D.

/nz/kit/log/sysmgr/sysmgr.log

Question 8 of 134

What columns contain row count information in the system tables? (Choose two.)

Question 9 of 134

Which statement or operation will cause IBM Netezza Replication Services to use the "By- VALUE" replication gmethod?

Question 10 of 134

The CUSTOMER table is distributed on "c_custkey".

The ORDERS table is distributed on "o_custkey".

Please refer to the SQL Query below:

Which of the following statements is TRUE?

A.

The query plan will show a double redistribute for both tables CUSTOMER and ORDERS followed by a HashJoinNode to compare all rows

B.

The query plan will show a broadcast for table CUSTOMER so that all rows in CUSTOMER can be compared to all rows in ORDERS using a HashJoinNode

C.

The query plan will show a broadcast for table CUSTOMER so that all rows in CUSTOMER can be compared to all rows in ORDERS using an ExprJoinNode

D.

The query plan will show a redistribute for table CUSTOMER so that all rows in CUSTOMER can be compared to all rows in ORDERS using an ExprJoinNode