We're so confident of our products that we provide no hassle product exchange.
IBM DB2 9.7 Advanced DBA for LUW Sample Questions:
1. Which option of the REORG TABLE statement will release blocks that contain no rows from a multi-dimensional clustering (MDC) table?
A) RELEASE FREE BLOCKS ONLY
B) RELEASE FREE EXTENTS ONLY
C) RECLAIM EXTENTS ONLY
D) RECLAIM FREE BLOCKS
2. Which tool or command will display only the automatic storage paths in an existing backup image?
A) db2ckbkp
B) INSPECT
C) db2dart
D) db2pd
3. Given the following output from the GET DATABASE CONFIGURATION command:
Which of the following DB configurations listed below will enable circular logging?
A) LOGSECOND=-1
B) LOGRETAIN=CIRCULAR
C) LOGARCHMETH1=OFF and LOGARCHMETH2=OFF
D) LOGPRIMARY=LOGCIRCULAR and LOGRETAIN=OFF
4. 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 client's authentication type is not compatible with the server.
C) The server node and/or database are not cataloged correctly on the client.
D) The port number is not assigned in the server's services file.
E) The DB2 Administration Server is not started.
5. Which statement is correct about statistical views?
A) A statistical view provides the optimizer with additional correlation statistics.
B) A statistical view holds information about the system catalog statistical tables.
C) A statistical view is created by executing runstats on a regular view.
D) A statistical view provides the optimizer with more accurate cardinality estimates.
Solutions:
| Question # 1 Answer: C | Question # 2 Answer: A | Question # 3 Answer: C | Question # 4 Answer: A,C | Question # 5 Answer: D |
By Jonathan
