IBM IBM Certifications C2090-600 Questions & Answers

• Question 11:

  If Secure Sockets Layer is a requirement, which of the following parameters must be set to encrypt data in transit?

  A. Set the DB2COMM registry variable to DB2COMM=SSL

  B. Set the DB2COMM registry variable to DB2COMM=SSL, TCPIP

  C. Set the AUTHENTICATION configuration parameter to DATA_ENCRYPT

  D. Set the AUTHENTICATION configuration parameter to SERVER_ENCRYPT

  Correct Answer: B

• Question 12:

  When operating in NPS compatibility mode, which of the following are limitations for using a routine written in NZPLSQL? (Choose two.)

  A. The routine cannot contain comments.

  B. The routine must return either an integer or a null.

  C. The routine must be cross-compatible with Oracle PL/SQL syntax rules.

  D. The routine cannot contain argument lists or variable arguments (varargs).

  E. The routine must be generated with IBM Database Conversion Workbench (DCW).

  Correct Answer: BD

• Question 13:

  Which of the following statements is TRUE?

  A. REORGCHK automatically runstables reorganization.

  B. REORGCHK uses only current table and index statistics.

  C. REORGCHK can only be used for user tables, not for system tables.

  D. REORGCHK can be used to verify the level of data fragmentation and indicate whether reorganization might be required.

  Correct Answer: B

• Question 14:

  Which of the following statements about compression for BLU MPP tables is TRUE?

  A. Compression must be explicitly enabled for BLU MPP tables

  B. Compression requires decompression to evaluate partition joins

  C. Unique compression dictionaries are generated for each partition

  D. Each table has a single compression dictionary that getsreplicated across all partitions

  Correct Answer: D

• Question 15:

  How would you enable self-tuning of memory areas that are controlled by memory configuration parameters?

  A. Set the DB2_WORKLOAD aggregate registry variable to ANALYTICS for self-tuning of the sort parameter on workloads that access column-organized tables.

  B. Set the SELF_TUNING_MEM database configuration parameter to ON using the UPDATE DATABASECONFIGURATION command or the db2CfgSet API.

  C. Set the sortheap or the sheapthres_shr configuration parameters to AUTOMATIC using the UPDATE DATABASE CONFIGURATION command or the db2CfgSet API with sheapthres set to at least 4K.

  D. Use AUTOMATIC keyword for the buffer pool size on the CREATE BUFFERPOOL statement or the ALTER BUFFERPOOL statement after making sure that at least one entry is present in SYSCAT.BUFFERPOOLDBPARTITIONS.

  Correct Answer: B

• Question 16:

  Which statement regarding setting up a local keystore for DB2 native encryption is TRUE?

  A. A local keystore is not needed if a Hardware Security Module (HSM) is used to managemaster keys.

  B. If a local keystore is used to store data encryption keys, a stash file must be used to store master keys temporarily.

  C. A master key must be generated and placed in an existing local keystore before a new encrypted

  database will be created.

  D. After a local keystore is created, you will be prompted for a password whenever the database manager accesses the keystore.

  Correct Answer: C

• Question 17:

  Which command can be used to view the configured global registry settings for all installed DB2 copies found on a Linux server?

  A. db2val

  B. db2set

  C. db2look

  D. db2greg

  Correct Answer: B

• Question 18:

  Which data types are only valid when DB2_COMPATIBILITY_VECTOR=ORA? (Choose two.)

  A. XML

  B. REAL

  C. NUMBER

  D. VRCHAR2

  E. VARBINARY

  Correct Answer: CE

• Question 19:

  Which statement about the db2move command is TRUE?

  A. The LOAD actions can be run from a client machine.

  B. Object ownership cannot be changed after a successful schema copy operation.

  C. Tables containing GENERATED ALWAYS identity columns can be imported or loaded.

  D. Loading data into tables containing XML columns is only supported for the LOAD actions.

  Correct Answer: D

• Question 20:

  Given the following: What will be the result of the following SQL statement?

  

  INSERT INTO v3 (col1) values (30);

  A. The insert will succeed as it passes validation.

  B. The insert will succeed as there is no WITH CHECK OPTION on view V3.

  C. The insert will result in an error as it violates the WITH CHECK OPTION on view V2.

  D. The insert will succeed as the default WITH CHECK OPTION is LOCAL on view V2.

  Correct Answer: C