IBM IBM Certified Advanced Database Administrator A2090-544 Questions & Answers

• Question 101:

  Setting the DB2_FMP_COMM_HEAPSZ=0 will result in which the following?

  A. User-defined function calls will be disabled.

  B. In a partitioned environment, infinite communications will be enabled between partitions.

  C. In a partitioned environment, communications will not be buffered.

  D. Non-fenced routines can be invoked, however automatic database maintenance will be disabled.

  Correct Answer: D

• Question 102:

  Given INTRA_PARALLEL is OFF, average row length is 900 bytes, and temporary table cardinality is 1000, which setting would prevent a SORTHEAP overflow when the temporary table is sorted?

  A. SORTHEAPTHRES 10000K, SORTHEAP 250K

  B. SORTHEAPTHRES 10000K

  C. SORTHEAP AUTOMATIC, SHEAPTHRES 10000K

  D. SORTHEAP AUTOMATIC, SHEAPTHRES 0

  Correct Answer: D

• Question 103:

  

  Table T1 was created by executing the following statement:

  Immediately after creation, table T1 was populated with 10 rows. Later, user USER1 ran an application that

  inserted 100,000 rows into table T1.

  The following query is frequently ran against the T1 table:

  SELECT deptno, empno, deptname FROM t1 WHERE deptno = 'EN' AND empno = '123' Assuming

  current statics exist for the table and index, which index will provide optimal performance for this query?

  A. CREATE INDEX idx1 ON t1 (deptno, empno) INCLUDE (deptname)

  B. CREATE INDEX idx1 ON t1 (deptno, empno)

  C. CREATE INDEX idx1 ON t1 (deptno) INCLUDE (empno)

  D. CREATE INDEX idx1 ON t1 (deptno)

  Correct Answer: B

• Question 104:

  A DBA has established connectivity to a DB2 for z/OS database and is exploiting a System z sysplex for load balancing and fault-tolerance. Which series of statements and commands can be issued to ensure that agents remain allocated to help maintain the sysplex server list?

  A. UPDATE DBM CFG USING NUM_INITAGENTS 200;db2stop;db2start;

  B. UPDATE DBM CFG USING NUM_INITAGENTS 0;db2stop;db2start;

  C. UPDATE DBM CFG USING NUM_POOLAGENTS 200;db2stop;db2start;

  D. UPDATE DBM CFG USING NUM_POOLAGENTS 0;db2stop;db2start;

  Correct Answer: C

• Question 105:

  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.

  Correct Answer: B

• Question 106:

  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.

  Correct Answer: AE