IBM C1000-085 Online Practice Questions and Exam Preparation

IBM C1000-085 Online Questions & Answers

• Question 1:

  How can a user update statistics on a table?

  A. by running UPDATE STATISTICS
  B. by running a query against the table
  C. by running GENERATE STATISTICS
  D. by restarting the database
  A. by running UPDATE STATISTICS

• Question 2:

  Which two file formats are valid for external tables?

  A. text-delimited
  B. fixed-length
  C. JSON
  D. HL7
  E. XML
  A. text-delimited
  C. JSON

• Question 3:

  Which three scripts are included in the IBM Netezza Performance Server Software Support Tools?

  A. nzsql
  B. nz_ddl
  C. nzsqa
  D. nz_stats
  E. nzbackup
  F. nz tables
  C. nzsqa
  E. nzbackup
  F. nz tables

• Question 4:

  Which statement is true when executing the GROM command on a Clustered Base Table (CBT)?

  A. It reclaims space from deleted rows and does not re-order data
  B. Enough space is required for GROOM to make a complete copy of the table
  C. GROOM uses CREATE TABLE AS SELECT (CATAS) for CBT to reclaim space and re- order data.
  D. It reclaims space from deleted rows and re-orders data.
  A. It reclaims space from deleted rows and does not re-order data

• Question 5:

  What is the duration of SQB by default?

  A. 3 seconds
  B. 6 seconds
  C. 2 seconds
  D. 10 seconds
  C. 2 seconds

• Question 6:

  Which two cross-database SQL operations are allowed?

  A. DELETE
  B. ALTER VIEW
  C. ALTER TABLE
  D. CREAE TABLE
  E. REVOKE
  C. ALTER TABLE
  D. CREAE TABLE

• Question 7:

  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
  C. stopped

• Question 8:

  Which log file provides a DBA with an actual SQL statement that was executed?

  A. clientmgr.log
  B. pg.log
  C. sysmgr.log
  D. dbos.log
  C. sysmgr.log

• Question 9:

  Which statement is correct about command nz_responders?

  A. displays user activity in tabular format
  B. displays information from nzsql responders -all in a more user-friendly format
  C. displays information from nzsqa responders -sys in a more user-friendly format
  D. displays resource utilization statistics in JSON format
  B. displays information from nzsql responders -all in a more user-friendly format

• Question 10:

  When restoring a database using nzrestore utility, which is true for the npshost option?

  A. It is the hostname of the storage server
  B. It is a HOSTNAME value set in backupHostname.txt file on the backup source system.
  C. It is a host name of the target system to restore a database to.
  D. It is a remote host name or IP address of the system to connect to.
  C. It is a host name of the target system to restore a database to.