← Back to exam page

P2090-050 – IBM PureData System for Analytics Technical Mastery Test v1

Loading demo links...

Showing 4–6 of 10 questions

Question 4 (Volume B)

A stored procedure returning one value is created, which two methods can be used to execute the procedure? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    Using the EXECUTE command.
  • ○

    Using the SELECT statement within a FROM clause.
  • ○

    Using the SELECT statement within a HAVING clause.
  • ○

    Using the SELECT statement without a FROM clause.
  • ○

    Using the SELECT statement with tables in the FROM clause.
Question 5 (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.
Question 6 (Volume A)

What is the host Linux file that must be modified to adjust optimizer settings permanently?

Select an option, then click Submit answer.

  • ○

    /nz/data/postgresql.conf
  • ○

    /nz/data/config/system.cfg
  • ○

    /nz/kit/sys/initTopology.cfg
  • ○

    /nz/kit/log/sysmgr/sysmgr.log