IBM C2090-544 Online Practice Questions and Exam Preparation

IBM C2090-544 Online Questions & Answers

• Question 91:

  Which data organization schemes are supported?

  A. PARTITION BY HASH and ORGANIZE BY
  B. PARTITION BY RANGE and ORGANIZE BY HASH
  C. PARTITION BY HASH and ORGANIZE BY RANGE
  D. PARTITION BY RANGE and ORGANIZE BY
  D. PARTITION BY RANGE and ORGANIZE BY

• Question 92:

  Which of the following techniques will ensure that you CANNOT encounter two active primary servers in an HADR pair?

  A. Set ALTERNATER SERVER to fixed IP Addresses on both servers.
  B. Use a virtual IP Address for both servers.
  C. Use a virtual IP Address in the CATALOG DATABASE command.
  D. Catalog both servers separately and use a fixed IP address for both servers.
  C. Use a virtual IP Address in the CATALOG DATABASE command.

• Question 93:

  A journaling application inserts data with continually increasing sequential keys while a clean up process randomly deletes erroneous rows. What can be done to maximize insert performance?

  A. Issue a db2set DB2MAXFSCRSEARCH=1024 command.
  B. Issue an ALTER TABLESPACE EXTEND statement.
  C. Issue a db2set DB2SKIPDELETED=ON command.
  D. Issue an ALTER TABLE APPEND ON statement.
  D. Issue an ALTER TABLE APPEND ON statement.

• Question 94:

  Which database manager configuration parameter is used to set an instance-wide soft limit on the total amount of memory that can be consumed by private sorts, within that instance, at any given time?

  A. SORTHEAP
  B. SHEAPTHRES_SHR
  C. SHEAPTHRES
  D. SORTHEAP_SHR
  C. SHEAPTHRES

• Question 95:

  How can a DBA validate that an existing backup was compressed?

  A. Check the output from the command LIST HISTORY BACKUP ALL FOR the database.
  B. Check the value of the COMPRESS_BACKUP database configuration setting.
  C. Check the value of the DB2_COMPRESS_BACKUP registry variable.
  D. Check the header information of the backup file using db2ckbkp.
  D. Check the header information of the backup file using db2ckbkp.

• Question 96:

  A database and a table space were created using the following commands: Afterwards, two tables were created in table space TBSP1 and both tables were populated with 100,000 rows. If a DBA decides that database MYDB should use automatic storage, which command(s) are needed to convert both the database and table space TBSP1?

  

  A. ALTER DATABASE mydb ADD STORAGE ON ?mnt/path_1? ?mnt/path_2?
  B. ALTER DATABASE mydb ADD STORAGE ON ?mnt/path_1? ?mnt/path_2?ALTER TABLESPACE tbsp1 MANAGED BY AUTOMATIC STORAGE;
  C. ALTER DATABASE mydb AUTOMATIC STORAGE YES ON ?mnt/path_1? ?mnt/path_2?
  D. ALTER DATABASE mydb AUTOMATIC STORAGE YES ON ?mnt/path_1? ?mnt/path_2? ALTER TABLESPACE tbsp1 MANAGED BY AUTOMATIC STORAGE;
  B. ALTER DATABASE mydb ADD STORAGE ON ?mnt/path_1? ?mnt/path_2?ALTER TABLESPACE tbsp1 MANAGED BY AUTOMATIC STORAGE;

• Question 97:

  At which two levels can events be audited? (Choose two.)

  A. Instance level
  B. Database level
  C. Server level
  D. Operating System level
  E. Node level
  A. Instance level
  B. Database level

• Question 98:

  A database named MYDB is created in instance DB2INST1, which has been configured to use KRB_SERVER_ENCRYPT authentication. If a client attempting to access database MYDB does not support Kerberos authentication, which authentication method will be used to establish a connection?

  A. SERVER_ENCRYPT
  B. SERVER
  C. KRB_SERVER_ENCRYPT
  D. CLIENT
  A. SERVER_ENCRYPT

• Question 99:

  While attempting to establish connectivity between a Windows client and a UNIX server, the following commands were issued from the Windows client:

  CATALOG TCPIP NODE node001 REMOTE hostnm01 SERVER 50000; CATALOG DATABASE samp001 AS samp001 AT NODE node001;

  TERMINATE;

  When trying to connect to the SAMP001 database the following error was received: SQL30061N The database alias or database name name was not found at the remote node. The database name is not an existing database at the remote

  database node. The statement cannot be processed. What should be done resolve the problem?

  A. Add a Database Connection Services entry to the /etc/services file on the Windows client.
  B. Change the service name (SVCENAME) in the remote servers database configuration.
  C. Match the port number in the CATALOG TCPIP NODE command with the port number in the /etc/services file on the remote server.
  D. Add an entry into the Database Connection Services directory on the Windows client.
  B. Change the service name (SVCENAME) in the remote servers database configuration.

• Question 100:

  Click the Exhibit button.

  

  Refer to the table definition shown in the exhibit.

  Which will improve performance based on the query SELECT c6, c9 FROM tab3 WHERE c9 = 123456?

  A. CREATE INDEX idx98 ON tab3 (c6 ASC);CREATE INDEX idx99 ON tab3 (c9 DESC);RUNSTATS ON TABLE myschema.tab3;
  B. CREATE INDEX idx98 ON tab3 (c2 ASC, c6 ASC);CREATE INDEX idx99 ON tab3 (c2 ASC, c9 ASC);RUNSTATS ON TABLE myschema.tab3;
  C. CREATE INDEX idx99 ON tab3 (c2 ASC, c9 DESC);REORG TABLE myschema.tab3 AND INDEXES ALL;
  D. CREATE INDEX idx99 ON tab3 (c6 ASC, c9 DESC);REORG TABLE myschema.tab3 AND INDEXES ALL;
  A. CREATE INDEX idx98 ON tab3 (c6 ASC);CREATE INDEX idx99 ON tab3 (c9 DESC);RUNSTATS ON TABLE myschema.tab3;