IBM Certified Database Administrator - IBM IMS Sample Questions:
1. Which one of the following options is TRUE about DB2 pureScale?
A) DB2 pureScale feature supports multiple interconnects for both members and cluster caching facilities (CFs).
B) DB2 pureScale feature supports multiple interconnects for the cluster caching facilities (CFs).
C) A DB2 pureScale installation is only supported on AIX platform.
D) DB2 pureScale feature does not support range-partitioning tables.
2. How is DB2 installed on the server?
A) DB2 can only be purchased pre-installed on an IBM server. There is no need to ever installDB2.
B) DB2 must be installed on RAM drive on the server to speed up performance of the database.
C) DB2 can only be installed from a command prompt using command-line entries.
D) DB2 can be installed using the DB2 installation wizard.
3. What are some of the benefits of DB2 Express?
A) DB2 Express is faster and more powerful than the DB2 product.
B) DB2 Express is designed for development and testing. It is not used as a production database.
C) DB2 Express is a tool that allows the DBA to quickly solve (expressly) complex issues with theDB2 version of software.
D) DB2 Express has affordable licensing terms with all of the features of the DB2 engine.
4. The DB2 Storage Optimization feature allows you to save storage by compressing your database data. Which one of the following types of compression is new in DB2 10?
A) Temporary Tables Compression
B) Adaptive Compression
C) Declared Global Temporary Tables Compression
D) Classic Row Compression
5. Which one of the following sentences does NOT describe a benefit of Temporal Tables?
A) Temporal tables allow better data management by letting the application control data integrity and uniqueness.
B) Temporal tables lower costs by eliminating the complexity for businesses to develop their own temporal support infrastructure, such as additional tables, triggers, and application logic.
C) Temporal tables increase business insight by letting analysts understand how the business was doing in the past, what has changed in the present, what are the projections for the future.
D) Temporal tables provide a quick and easy way to track and record data changes in the table.
Solutions:
| Question # 1 Answer: B | Question # 2 Answer: D | Question # 3 Answer: D | Question # 4 Answer: B | Question # 5 Answer: A |

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


By Brian


