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 statement is correct about statistical views?
A) A statistical view provides the optimizer with more accurate cardinality estimates.
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 is created by executing runstats on a regular view.
2. Click the Exhibit button.
In a DB2 Connect scenario between a Windows client and a z/OS server, the commands in the exhibit produced an SQL30061N error while trying to connect to the BIGDB001 database in the DB2T subsystem on the z/OS server: SQL30061N The database alias or database name name was not found at the remote node.
Explanation:
The database name is not an existing database at the remote database node. The statement cannot be processed. The z/OS DBA has confirmed that the LOCATION NAME is DB2T. Which change would enable the command in the exhibit to execute correctly?
A) CATALOG DCS DATABASE dsample AS db2t
B) CATALOG DCS DATABASE db2t AS dsample
C) CATALOG DATABASE bigdb001 AS dsample AT NODE db2t AUTHENTICATION DCS
D) CATALOG DATABASE db2t AS dsample AT NODE node001 AUTHENTICATION DCS
3. Which option of the REORG TABLE statement will release blocks that contain no rows from a multi-dimensional clustering (MDC) table?
A) RECLAIM FREE BLOCKS
B) RECLAIM EXTENTS ONLY
C) RELEASE FREE EXTENTS ONLY
D) RELEASE FREE BLOCKS ONLY
4. 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 the database?
A) ALTER DATABASE mydb ADD STORAGE 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?
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;
5. 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 server node and/or database are not cataloged correctly on the client.
C) The client's authentication type is not compatible with the server.
D) The DB2 Administration Server is not started.
E) The port number is not assigned in the server's services file.
Solutions:
| Question # 1 Answer: A | Question # 2 Answer: A | Question # 3 Answer: B | Question # 4 Answer: B | Question # 5 Answer: A,B |
By Lawrence
