IBM P2090-047 - IBM PureData System for Transactions Technical Mastery Test v1 Exam

Page:    1 / 27   
Total 132 questions

A SELECT statement spends all its time returning 1 billion rows. What can be done to make this faster?

  • A. Use a CURSOR.
  • B. Use an EXTERNAL table.
  • C. Use the COPY command.
  • D. Increase the PreFetch Count.


Answer : B

What function can nzbackup perform?

  • A. Back up pg.log files.
  • B. Back up TEMP tables.
  • C. Back up host data (catalog metadata).
  • D. Back up the data using the specified number of streams.


Answer : D

nzbackup/nzrestore with the -user option has been replaced with which option to allow multi-level security (MLS) information, such as categories, cohorts, and levels to be backed up/restored?

  • A. -all
  • B. -mls
  • C. -users
  • D. -globals


Answer : D

When loading a local ASCII file into table via an external table, where can the SQL be submitted?

  • A. From a User Defined Function.
  • B. From a JDBC application networked to the system.
  • C. From nzsql on an AIX machine networked to the system.
  • D. From nzsql on Microsoft Windows networked to the system.


Answer : B

Which is NOT a function that can be performed by nzbackup?

  • A. Backup data
  • B. Backup schemas
  • C. Backup users/groups
  • D. Backup the /nz/data directory


Answer : D

Page:    1 / 27   
Total 132 questions