← Back to exam page

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

Loading demo links...

Showing 1–3 of 10 questions

Question 1 (Volume B)

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

Select all that apply, then click Submit answer.

  • ○

    NULL
  • ○

    UNIQUE
  • ○

    NOT NULL
  • ○

    PRIMARY KEY
  • ○

    DEFAULT value
Question 2 (Volume A)

What two characteristics can be changed when using the CREATE TABLE AS (CTAS) statement to copy TableA to TableB? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    The views on TableA.
  • ○

    The privileges on TableA.
  • ○

    The distribution key of TableB.
  • ○

    The materialized views on TableB.
  • ○

    The order of the data stored in TableB.
Question 3 (Volume B)

In a UNIX 64bit environment, a 64bit application requires which software to execute SQL statements via ODBC? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    nzsql
  • ○

    An ODBC driver manager.
  • ○

    The system does not support 64 bit ODBC.
  • ○

    A 64-bit ODBC driver for the same UNIX environment.
  • ○

    A 32-bit ODBC driver for the same UNIX environment.