C2090-560

C2090-560 practice questions, page 2 of 6, with answer review and explanations.

Question 6

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.)

  1. NULL
  2. UNIQUE
  3. NOT NULL
  4. RIMARY KEY
  5. DEFAULT value

Question 7

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

  1. /nz/data/postgresql.conf
  2. /nz/data/config/system.cfg
  3. /nz/kit/sys/initTopology.cfg
  4. /nz/kit/log/sysmgr/sysmgr.log

Question 8

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

  1. STAHIVAL
  2. RELREFS
  3. STALOVAL
  4. RELTUPLES
  5. ATTDISPERSION

Question 9

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

  1. Insert data from a non-replicated database
  2. LIMIT ALL
  3. RANDOMO
  4. A & C
  5. B & C

Question 10

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?

  1. The query plan will show a double redistribute for both tables CUSTOMER and ORDERS followed by a HashJoinNode to compare all rows
  2. 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
  3. 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
  4. 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