IBM C2090-611 Online Practice Questions and Exam Preparation

IBM C2090-611 Online Questions & Answers

• Question 31:

  You are tasked with using the Export, Import, and Load utilities to move data from a UNIX platform database to a Windows platform database. What file format is recommended for moving data across platforms?

  A. IXF
  B. DEL
  C. ASC
  D. WSF
  A. IXF

• Question 32:

  What are two types of security label components that can be used with Label-Based Access Control (LBAC)? (Choose two).

  A. Set
  B. Tree
  C. Group
  D. Range
  E. Hierarchy
  A. Set
  B. Tree

• Question 33:

  What are two types of check options that can be used to create views? (Choose two.)

  A. Local
  B. Client
  C. Server
  D. Remote
  E. Cascaded
  A. Local
  E. Cascaded

• Question 34:

  Which statement is true regarding the workload management dispatcher?

  A. The workload management dispatcher monitors work performed by entities executing in the DB2 system service class.
  B. The workload management dispatcher monitors the allocation of CPU resources between service classes on a system.
  C. The workload management dispatcher monitors non-DB2 work performed in fenced mode processes such as fenced stored procedures.
  D. The workload management dispatcher monitors work performed by applications or middleware products that perform a portion of their workoutside of the DB2 database manager.
  B. The workload management dispatcher monitors the allocation of CPU resources between service classes on a system.

• Question 35:

  Which SQL/XML publishing function can be used to convert XML data into other formats, including other XML schemas?

  A. XSLPARSE
  B. XSLELEMENT
  C. XSLCONVERT
  D. XSLTRANSFORM
  D. XSLTRANSFORM

• Question 36:

  Which statement regarding SECADM authority is true?

  A. The instance owner has SECADM authority by default.
  B. PUBLIC cannot receive SECADM authority, either directly or indirectly.
  C. Only users with SECADM authority are allowed to grant the CONNECT database authority to others.
  D. The SECADM_GROUP database manager configuration parameter determines who has SECADM authority by default.
  B. PUBLIC cannot receive SECADM authority, either directly or indirectly.

• Question 37:

  A user with SYSADM authority executes the following commands at host SERVER1:

  

  Assuming the user ADMINISTRATOR exists, what could be causing the problem?

  A. The password for user ADMINISTRATOR is missing.
  B. The userid should not be longer than eight characters.
  C. The syntax of the CATALOG NODE command must contain a valid TCP/IP address.
  D. The db2c_sample entry in the Windows Services File might not be assigned port number 50000.
  D. The db2c_sample entry in the Windows Services File might not be assigned port number 50000.

• Question 38:

  What must a user possess if they want to run a DB2 Command Line Processor (CLP) script against a database using the Job Manager in IBM Data Studio?

  A. Permission to log in to the database client using telnet.
  B. Permission to log in to the database server using telnet.
  C. Permission to log in to the database client using secure shell (SSH).
  D. Permission to log in to the database server using secure shell (SSH).
  D. Permission to log in to the database server using secure shell (SSH).

• Question 39:

  Which tool should be used to give you lock wait information from the DB2 memory sets?

  A. db2pd
  B. db2mtrk
  C. db2fodc
  D. db2support
  A. db2pd

• Question 40:

  Which statement about BEFORE triggers is FALSE?

  A. A BEFORE trigger's action is executed for each row in the set of affected rows before the trigger event executes.
  B. A BEFORE trigger's action is executed for each row in the set of affected rows instead of executing the trigger event.
  C. A BEFORE trigger is used to perform validation of input data and to automatically generate values for newly inserted rows.
  D. A BEFORE trigger cannot be used to modify data in a database because they are activated before the trigger event is applied to the database.
  B. A BEFORE trigger's action is executed for each row in the set of affected rows instead of executing the trigger event.