IBM C2090-544 Online Practice Questions and Exam Preparation

IBM C2090-544 Online Questions & Answers

• Question 21:

  What are the steps required to remove July 2005 data from a partitioned table and replace with it with July 2010 data?

  A. 1) Detach partition containing July 2005 data2) Load July 2010 data into a new table3) Attach the new table as a new partition in the existing partitioned table4) Check constraint integrity for the partitioned table
  B. 1) Detach partition containing July 2005 data2) Load July 2010 data into a new table3) Attach the new table as a new partition in the existing partitioned table4) Rebind the partitioned table
  C. 1) Detach partition containing July 2005 data2) Load July 2010 data into a new table3) Attach the new table as a new partition in the existing partitioned table4) Update statistics on the partitioned table
  D. 1) Detach partition containing July 2005 data2) Load July 2010 data into a new table3) Attach the new table as a new partition in the existing partitioned table4) Reorg the partitioned table
  A. 1) Detach partition containing July 2005 data2) Load July 2010 data into a new table3) Attach the new table as a new partition in the existing partitioned table4) Check constraint integrity for the partitioned table

• Question 22:

  How can you change an existing non-partitioned index for a partitioned table to a partitioned index?

  A. Use the ALTER INDEX command.
  B. Use the DROP INDEX and CREATE INDEX commands.
  C. Use the REORG INDEX command.
  D. Use the ALTER INDEX and REORG INDEX commands.
  B. Use the DROP INDEX and CREATE INDEX commands.

• Question 23:

  A batch application updates a large number of rows within a single transaction. What is one way to help the application complete quickly?

  A. Code the application to issue a LOCK TABLE statement.
  B. Code the application to issue a LOCK ROW statement.
  C. Increase the group commit count.
  D. Increase the size of the lock list.
  A. Code the application to issue a LOCK TABLE statement.

• Question 24:

  An employee is not able to connect to the PRODDB database using the correct user ID and password. The TCP/IP protocol is running normally; other remote clients are also having problems connecting to this database. Which two could be the cause of the problem? (Choose two.)

  A. The DB2COMM environment variable at the server is not set to TCPIP.
  B. The DB2 Administration Server is not started.
  C. The port number is not assigned in the server's services file.
  D. The client's authentication type is not compatible with the server.
  E. The server node and/or database are not cataloged correctly on the client.
  A. The DB2COMM environment variable at the server is not set to TCPIP.
  E. The server node and/or database are not cataloged correctly on the client.

• Question 25:

  Which statement is correct about statistical views?

  A. A statistical view is created by executing runstats on a regular view.
  B. A statistical view holds information about the system catalog statistical tables.
  C. A statistical view provides the optimizer with additional correlation statistics.
  D. A statistical view provides the optimizer with more accurate cardinality estimates.
  D. A statistical view provides the optimizer with more accurate cardinality estimates.

• Question 26:

  Which conditions must be met to implement HADR?

  A. Operating systems on primary and standby servers must be the same; DB2 versions need not be the same; and the databases must have the same bit-size (32 or 64 bit).
  B. Operating systems on primary and standby servers need not be the same; DB2 versions must be the same; and the databases need not have the same bit-size (32 or 64 bit).
  C. Operating systems on primary and standby servers must be the same; DB2 versions must be the same; and the databases need not have the same bit-size (32 or 64 bit).
  D. Operating systems on primary and standby servers must be the same; DB2 versions must be the same; and the databases must have the same bit-size (32 or 64 bit).
  D. Operating systems on primary and standby servers must be the same; DB2 versions must be the same; and the databases must have the same bit-size (32 or 64 bit).

• Question 27:

  Which action(s) will cause a compression dictionary to be removed from a table?

  A. Set the table COMPRESS attribute to NO.
  B. Set the table COMPRESS attribute to NO;run REORG against the table.
  C. Set the table COMPRESS attribute to NO;run INSPECTESETDICTIONARY against the table.
  D. Set the table COMPRESS attribute to NO;run RUNSTATS against the table.
  B. Set the table COMPRESS attribute to NO;run REORG against the table.

• Question 28:

  What is a method for enabling non-buffered I/O at the table space level in a DB2 database?

  A. Set the DB2_DIRECT_IO configuration parameter to YES.
  B. Set the DB2_FILESYSTEM_CACHE configuration parameter to YES.
  C. Use the USE DIRECT IO clause with the CREATE TABLESPACE or ALTER TABLESPACE command.
  D. Use the NO FILE SYSTEM CACHING clause with the CREATE TABLESPACE or ALTER TABLESPACE command.
  D. Use the NO FILE SYSTEM CACHING clause with the CREATE TABLESPACE or ALTER TABLESPACE command.

• Question 29:

  If you know that the table space containers for your database reside on RAID-5 3+p arrays, which registry variable should be assigned the value *:3 to help improve performance?

  A. DB2_APM_PERFORMANCE
  B. DB2_EXTENDED_IO_FEATURES
  C. DB2_RESOURCE_POLICY
  D. DB2_PARALLEL_IO
  D. DB2_PARALLEL_IO

• Question 30:

  A user with Security Administrator (SECADM) authority executes the following statements:

  

  If user USER2 queries the table S.TAB1, how many rows will be returned?

  B. 1
  C. 2
  D. 3
  C. 2