IBM C2090-541 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Performance Monitoring & Tuning | 12% | - Locking, concurrency, and deadlock resolution - Monitoring tools: db2top, snapshot monitor - SQL optimization and access plans |
| Topic 2: Maintenance & Utilities | 18% | - Load, Import, and Export utilities - RUNSTATS, REORG, and REBIND - Diagnostic tools: db2diag, db2dart, db2exfmt |
| Topic 3: Server Management & Configuration | 20% | - Memory management including STMM - Installation and upgrade - Instance and database configuration - Registry variables and environment settings |
| Topic 4: Physical Database Design | 18% | - Storage optimization - Partitioning, MDC, and range-clustered tables - Table spaces and containers - Index design and maintenance |
| Topic 5: Backup, Recovery & High Availability | 17% | - FlashCopy and snapshot support - Crash recovery and rollforward - Backup and restore operations - HADR configuration and failover |
| Topic 6: Security & Access Control | 15% | - Authentication and authorization - Privileges and roles - Auditing and encryption |
IBM DB2 9.7 DBA for Linux UNIX and Windows Sample Questions:
1. Which statement is correct when describing the AUTOCONFIGURE command?
A) It calculates and displays initial values for the database manager configuration parameters and database configuration parameters for a single database, with the option of applying these values.
B) It calculates and displays initial values for buffer pool sizes, the database manager configuration parameters, and database configuration parameters for all databases within an instance, with the option of applying these values.
C) It calculates and displays initial values for the database manager configuration parameters and database configuration parameters for all databases within an instance, with the option of applying these values.
D) It calculates and displays initial values for buffer pool sizes, the database manager configuration parameters, and database configuration parameters for a single database, with the option of applying these values.
2. Which statement is correct about informational constraints?
A) The database manager uses an informational constraint to enforce the uniqueness of the key during changes to the columns of the unique constraint.
B) An informational constraint is a column or combination of columns that has the same properties as a unique constraint.
C) An informational constraint specifies that every row that is inserted or updated in the table must conform to the definition of the table.
D) An informational constraint can be used by the SQL compiler to improve the access to data and query performance.
3. Because of an application abend, a database named PAYROLL needs to be restored to approximately 9:26 am on June 1, 2009. After the database is restored from a backup image, the command shown below is executed: ROLLFORWARD DATABASE payroll TO 2009-06-01-09.26.44.609002 USING LOCAL TIME AND STOP
When this command is executed, the error shown below is generated:
SQL4970N Roll-forward recovery on database "PAYROLL" cannot reach the specified stop point (end-of-log or point-in-time) because of missing log file(s) on node(s) "0".
Which two commands could be used to resolve this error? (Choose two.)
A) ROLLFORWARD DATABASE payroll TO 2009-06-01-09.26.44.609002 USING UTC TIME AND STOP NORETRIEVE MISSING RECORDS
B) ROLLFORWARD DATABASE payroll TO 2009-06-01-09.26.44.609002 USING LOCAL TIME AND STOP OVERFLOW LOG PATH /mnt/arclog
C) ROLLFORWARD DATABASE payroll TO END OF LOGS AND STOP
D) ROLLFORWARD DATABASE payroll TO 2009-06-01-09.26.44.609002 USING UTC TIME AND STOP
4. Which statement is true about unique constraints?
A) A unique constraint is identical to a unique index.
B) There can be multiple unique constraints per table.
C) A foreign key can only reference a unique constraint.
D) There can be only one unique constraint key per table
5. Click the Exhibit button.
Refer to the exhibit for information on how tables TABA and TABB were created. What would be the number of extents allocated for each table after the successful creation of both tables?
A) TABA: 1 extent TABB: 1 extent
B) TABA: 4 extents TABB: 40 extents
C) TABA: 1 extent TABB: 10 extents
D) TABA: 2 extents TABB: 20 extents
Solutions:
| Question # 1 Answer: D | Question # 2 Answer: D | Question # 3 Answer: B,C | Question # 4 Answer: B | Question # 5 Answer: B |
1042 Customer Reviews
Quality and ValueITCertKing Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all study materials.
Tested and ApprovedWe are committed to the process of vendor and third party approvals. We believe professionals and executives alike deserve the confidence of quality coverage these authorizations provide.
Easy to PassIf you prepare for the exams using our ITCertKing testing engine, It is easy to succeed for all certifications in the first attempt. You don't have to deal with all dumps or any free torrent / rapidshare all stuff.
Try Before BuyITCertKing offers free demo of each product. You can check out the interface, question quality and usability of our practice exams before you decide to buy.
