IBM DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade Sample Questions:
1. What DB2 feature must NOT be activated in order to enable Secure Sockets Layer (SSL) support?
A) High Availability Disaster Recovery (HADR)
B) Connection Concentrator
C) Work Load Manager (WLM)
D) Kerberos Authentication
2. DBAPP1 is a database in instance INST1.
Which scenario can be used? (Assume that all three users are connected to DBAPP1).
A) SECADM1: CREATE ROLE admrole SYSADM1: GRANT ROLE admrole TO USER user1 DBADM1: GRANT DATAACCESS ON DATABASE TO ROLE admrole
B) SYSADM1: CREATE ROLE admrole SECADM1: GRANT ROLE admrole TO USER user1 DBADM1: GRANT DATAACCESS ON DATABASE TO ROLE admrole
C) SYSADM1: CREATE ROLE admrole SYSADM1: GRANT ROLE admrole TO USER user1 SECADM1: GRANT DATAACCESS ON DATABASE TO ROLE admrole
D) SECADM1: CREATE ROLE admrole SECADM1: GRANT ROLE admrole TO USER user1 SECADM1: GRANT DATAACCESS ON DATABASE TO ROLE admrole
3. Which parameter can be used to compress XML data being LOADed into a table that recently had an XML column added to it?
A) KEEPDICTIONARY
B) XMLVALIDATE
C) XMLCOMPRESS
D) RESETDICTIONARY
4. Which statement describes the state of the DMS table space TBS_1 after the successful execution of the following script? ALTER TABLESPACE tbs_1 MANAGED BY AUTOMATIC STORAGE
A) The table space TBS_1 is managed by automatic storage and in a rebalance pending state waiting for the REBALANCE command.
B) The table space TBS_1 is managed by automatic storage, online and still using its old containers.
C) The table space TBS_1 is managed by automatic storage, in a backup pending state and all its containers are relocated to the database assigned automatic storage paths.
D) The table space TBS_1 is managed by automatic storage, online and all its containers are relocated to the database assigned automatic storage paths.
5. A DBA wants to use XQuery on a XML document to determine the number of lock waits for a particular workload. Which of the following table functions should be used?
A) MON_GET_LOCKS_DETAILS
B) MON_GET_LOCKS
C) MON_GET_WORKLOAD_DETAILS
D) MON_GET_WORKLOAD
Solutions:
| Question # 1 Answer: B | Question # 2 Answer: D | Question # 3 Answer: D | Question # 4 Answer: B | Question # 5 Answer: C |

We're so confident of our products that we provide no hassle product exchange.


By Isidore


