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: | 000-546 / C2090-546 |
| Related Certifications: | IBM Certified Database Administrator - DB2 9.5 for Linux, UNIX, and Windows |
| Available Languages: | English, Japanese |
| Exam Format: | Multiple choice |
| Passing Score: | 55% |
| Certificate Validity Period: | 3 years |
| Exam Duration: | 90 minutes |
| Real Exam Qty: | 39 |
| Exam Price: | $200 USD |
| Recommended Training: | IBM DB2 9.7 New Features for Experienced DBAs DB2 9.7 Documentation Library |
| Exam Registration: | Pearson VUE Registration IBM Certification Page |
| Sample Questions: | IBM C2090-546 Sample Questions |
| Exam Way: | Online proctored or at authorized Pearson VUE test centers |
| Pre Condition: | Valid IBM Certified DBA - DB2 9.1 or 9.5 for Linux, UNIX, and Windows |
| Official Syllabus URL: | https://www.ibm.com/training/certification |
IBM C2090-546 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Monitoring and Problem Determination | 7.5% | - Locking and concurrency analysis - Diagnostic log analysis - Event monitors and snapshots |
| Topic 2: Security and Authorization | 12.5% | - Encryption and audit - Authentication and authorization models - Role-based access control |
| Topic 3: Performance and Tuning | 17.5% | - Memory and configuration parameters - SQL optimization and statistics - Workload management |
| Topic 4: XML and Advanced Features | 5% | - XML storage and indexing - XQuery and XML update |
| Topic 5: Physical Design and Storage | 22.5% | - Table spaces and containers - Partitioning and compression - Index design and optimization |
| Topic 6: Backup, Recovery, and High Availability | 15% | - Online and offline backup strategies - HADR and logging enhancements - Restore and rollforward recovery |
| Topic 7: Installation, Migration, and Upgrade | 20% | - Migration from previous versions - Upgrade preparation and planning - Post-upgrade verification |
IBM DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade Sample Questions:
1. Which of the following SQL statements will return monitoring information of all indexes in the DB2USER schema that have greater than 100 index scans?
A) SELECT * FROM TABLE(mon_get_index('DB2USER',100,-2))
B) SELECT * FROM TABLE(mon_get_index(' ','DB2USER',-2)) WHERE index_scans > 100
C) SELECT * FROM TABLE(mon_get_index('DB2USER',' ',-2)) WHERE index_scans > 100
D) SELECT * FROM TABLE(mon_get_index(' ',100,-2))
2. When the DIAGSIZE database manager configuration parameter is set to 10 on a Linux or Unix OS, what behavior will occur?
A) DB2 limits the size of the db2diag.log and <instance>.nfy files to 10 MB, and purges the old records when the limit is reached.
B) DB2 rotates through 10 db2diag.log and 10 <instance>.nfy files and limits the total size of the 20 files to 10 MB.
C) DB2 rotates through 10 db2diag.log and 10 <instance>.nfy files that are 10 MB in size.
D) DB2 rotates through 10 db2diag.log files that are 10 MB in size.
3. On which two operating systems (OS) can you integrate Workload Management (WLM) in DB2 LUW with the Workload Management in the OS? (Choose two.)
A) HP/UX
B) Linux
C) Solaris
D) AIX
E) Windows
4. If table space TS is created as follows: CREATE TABLESPACE ts MANAGED BY DATABASE USING (FILE '/data.dat' 12 M); If table space TS contains 4 MB of data and the hight water mark is at 6 MB, and the following statements are executed: ALTER TABLESPACE ts LOWER HIGH WATER MARK; ALTER TABLESPACE ts REDUCE (ALL CONTAINERS 5 M); What are the expected results?
A) The high water mark for all containers used by table space TS is only lowered if the size of all containers can be reduced by 5 MB.
B) The size of all containers is only reduced by 5 MB if the high water mark is lowered.
C) The high water mark for table space TS is lowered and the size of all containers is reduced by 5 MB.
D) The high water mark for all containers used for table space TS is lowered by 5 MB.
5. You have created a Trusted Context by using following command:
What is the ENCRYPTION type for the '9.26.146.201' address, the AUTHENTICATION type for
PUBLIC, and is MYCTX enabled?
A) High, WITH AUTHENTICATION, Yes
B) None, WITH AUTHENTICATION, No
C) High, WITHOUT AUTHENTICATION, No
D) None, WITHOUT AUTHENTICATION, Yes
Solutions:
| Question # 1 Answer: C | Question # 2 Answer: B | Question # 3 Answer: B,D | Question # 4 Answer: C | Question # 5 Answer: D |
By Rebecca
