We're so confident of our products that we provide no hassle product exchange.
IBM C2090-546 Exam Overview:
| Certification Vendor: | IBM |
| Exam Name: | DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade |
| Exam Number: | C2090-546 |
| Available Languages: | English |
| Related Certifications: | IBM Certified Database Administrator - DB2 9.7 for Linux, UNIX, and Windows |
| Exam Price: | $100 USD |
| Exam Format: | Multiple-choice |
| Sample Questions: | IBM C2090-546 Sample Questions |
| Exam Way: | Authorized testing center or online delivery through IBM's authorized testing provider. |
| Pre Condition: | Intended for candidates who already hold a previous IBM DB2 Database Administrator certification and are upgrading to DB2 9.7. |
IBM C2090-546 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| DB2 9.7 Architecture and New Features | - DB2 9.7 enhancements
|
| Performance Monitoring and Administration | - Database maintenance and tuning
|
| Backup Recovery and High Availability | - Data protection strategies
|
| Database Installation and Configuration | - Instance and database configuration
|
| Security and Authorization | - Database security management
|
IBM DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade Sample Questions:
1. If DB2 load operation is performed against a table which contains at least one XML column, which statement is true?
A) One compression dictionary is built for relational data and one compression dictionary is built for the XML data.
B) One compression dictionary is built for both relational data and for XML data.
C) One compression dictionary is built for relational data, XML data is not compressed.
D) One compression dictionary is built for relational data, one compression dictionary is built for XML data, and one compression dictionary is built for both relational and XML data.
2. Regardless of the value set for the mon_obj_metrics parameter, data is always collected for monitor elements reported by which of the two following table functions? (Choose two.)
A) MON_GET_INDEX
B) MON_GET_TABLESPACE
C) MON_GET_CONTAINER
D) MON_GET_TABLE
E) MON_GET_BUFFERPOOL
3. If table TAB_A and index TABA_IDX are created as follows:
What can be compressed?
A) Only data in columns C1 and C2 in table TAB_A and index TABA_IDX.
B) Only data in columns C1 and C2 of table TAB_A.
C) All data in table TAB_A and index TABA_IDX.
D) All data in table TAB_
4. Table TAB_A and index TABA_IDX were created by executing these SQL statements:
If this SQL statement is executed after 100,000 records have been inserted into table TAB_A:
ALTER INDEX taba_idx COMPRESS NO;
Which statement correctly describes what will happen to index TABA_IDX?
A) The index will remain compressed until it is REORGed.
B) The index will be uncompressed immediately.
C) The index will remain compressed until the COMPRESS attribute for table TAB_A has been set to NO.
D) The index will remain compressed until the COMPRESS attribute for table TAB_A has been set to NO and both the table and the index have been REORGed.
5. A range-partitioned table TAB1 has been created with COL1 and COL2 with COL1 as the partitioning column. What is the result of running the following statement? CREATE UNIQUE INDEX xcol2 ON tab1(col2) PARTITIONED
A) The uniqueness will be enforced locally within each partition.
B) The index will be created as a non-unique index and a warning will be returned.
C) The statement will be rejected and an error will be returned.
D) The index will be created as a unique non-partitioned index and a warning will be returned.
Solutions:
| Question # 1 Answer: A | Question # 2 Answer: A,D | Question # 3 Answer: A | Question # 4 Answer: A | Question # 5 Answer: C |
By Prima
