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 |
| Exam Price: | $100 USD |
| Related Certifications: | IBM Certified Database Administrator - DB2 9.7 for Linux, UNIX, and Windows |
| 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
|
| Backup Recovery and High Availability | - Data protection strategies
|
| Security and Authorization | - Database security management
|
| Database Installation and Configuration | - Instance and database configuration
|
| Performance Monitoring and Administration | - Database maintenance and tuning
|
IBM DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade Sample Questions:
Question #1
In a partitioned database environment, a table's distribution key can have:
- A. An XML column with primary key defined on it.
- B. Only XML columns with no primary key defined on it.
- C. An XML column with unique index defined on it.
- D. An XML column with other non-XML columns.
Correct Answer: D 🗳️
Question #2
When using an SQL UPDATE statement on an XML column, which statement is valid?
- A. An SQL UPDATE statement on an XML column must supply the complete new XML document.
- B. An SQL UPDATE statement can update an XML column using an XMLQUERY transform expression.
- C. An SQL UPDATE statement can modify a portion of an XML column using the SUBSTR function.
- D. An SQL UPDATE statement cannot be used on an XML column.
Correct Answer: B 🗳️
Question #3
If table TAB_A is created as follows:
Assuming the cardinality of the columns is the same, which statement will create an index that will benefit the most from compression?
- A. CREATE INDEX taba_idx ON tab_a (c2)
- B. CREATE UNIQUE INDEX taba_idx ON tab_a (c2)
- C. CREATE INDEX taba_idx ON tab_a (c4)
- D. ALTER TABLE tab_a ADD PRIMARY KEY (c1)
Correct Answer: A 🗳️
Question #4
The following trusted context has been defined:
Which statement is correct?
- A. If APP1 establishes a connection to the database, a connection to the database server at address 9.26.113.204 will be enabled using a role of CONTEXT_ROLE.
- B. If USER1 connects to the database from address 9.26.113.204 without providing a password, the connection will run under userid APP1.
- C. If APP1 connects from address 9.26.113.204, it will have role CONTEXT_ROLE associated with the connection.
- D. If APP1 connects from address 9.26.113.204 and no role has been granted to APP1, then and only then will role CONTEXT_ROLE be used.
Correct Answer: C 🗳️
Question #5
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.
Correct Answer: A 🗳️
By Ruth
