C2090-560

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

Question 16

Dirty reads occur when a transaction reads data that is written by concurrentuncommitted transactions. Under what conditions are dirty reads allowed on the IBM PDA system?

  1. When an FPGA is busy
  2. By turning off serialization within the system
  3. They are never permitted under any conditions
  4. When the transaction isolation is read-committed

Question 17

What can be backed up using the nzbackup utility?

  1. Host data
  2. pg.log files
  3. Temporary tables
  4. User permissions

Question 18

Which of the following will NOT show the current sessions on the Netezza server?

  1. nzsql\act
  2. nzsession
  3. nzsystem-showSessions
  4. SELECT* FROM_v_session

Question 19

Which of the following statements about temporary tables is TRUE?

  1. Synonyms can be created for temporary tables
  2. Temporary tables have been deprecated as of NPS 7.0.3
  3. Temporary tables can be specified as a base table for materialized views
  4. When a user executes the command "SET SESSION READ ONLY", they are still able to create and write to temporary tables

Question 20

What are two considerations for usage of materialized views? (Choose two.)

  1. Materialized views are not supported.
  2. Materialized views are logical entities.
  3. Materialized views may improve query performance.
  4. Materialized views are the same as database views.
  5. Materialized views are considered for usage by the Optimizer.