We're so confident of our products that we provide no hassle product exchange.
IBM C2090-541 Exam Overview:
| Certification Vendor: | IBM |
| Exam Name: | IBM DB2 9.7 DBA for Linux, UNIX and Windows |
| Exam Number: | C2090-541 |
| Available Languages: | English |
| Exam Duration: | 90 minutes |
| Passing Score: | 60% |
| Real Exam Qty: | 60 |
| Related Certifications: | IBM Certified Database Associate - DB2 IBM Certified Advanced Database Administrator - DB2 |
| Exam Price: | USD 200 (varies by region) |
| Certificate Validity Period: | 2 years |
| Exam Format: | Multiple choice, Multiple response |
| Recommended Training: | IBM DB2 9.7 Database Administration Training |
| Exam Registration: | IBM Certification Portal |
| Sample Questions: | IBM C2090-541 Sample Questions |
| Exam Way: | Computer-based exam delivered at authorized testing centers or online proctored exam (availability varies by region) |
| Pre Condition: | Basic knowledge of relational database concepts and DB2 fundamentals is recommended |
| Official Syllabus URL: | https://www.ibm.com/training/certification |
IBM C2090-541 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Monitoring and Performance Tuning | - Performance monitoring
|
| Installation and Configuration | - Instance configuration
|
| DB2 Architecture and Concepts | - DB2 instance and database architecture
|
| Database Operations and Utilities | - Backup and recovery
|
| Security and Authorization | - Data protection
|
IBM DB2 9.7 DBA for Linux UNIX and Windows Sample Questions:
1. You have a UTIL_IMPACT_LIM of 50 and a UTIL_IMPACT_PRIORITY of 60 for the backup utility. What are the maximum amount of system resources that the backup utility can use?
A) 40%
B) 50%
C) 30%
D) 60%
2. You want to estimate the potential index compression savings for existing indexes on a table What do you use to obtain this information?
A) ADMIN_GET_INDEX_COMPRESS_INFO table function
B) INSPECT
C) RUNSTATS
D) ADMIN_ESTIMATE_COMPRESS_INFO table function
3. Which command will reorg all indexes for a table named TABA?
A) REORG INDEXES FORtaba
B) REORG TABLEtaba INDEXES INPLACE
C) REORG INDEXES ALL FOR TABLEtaba
D) REORG TABLEtaba AND INDEXES ALL
4. A database administrator created a new database from an existing full database backup image. If the original database resided on a 64-bit AIX server and the new database was created on a different 64-bit AIX server, which two statements are correct? (Choose two.)
A) Existing SQL procedures must be dropped and re-created in the new database before they can be used.
B) Incremental backup images for the original database can be used to restore the new database.
C) Existing packages will be copied to the new database and can be used immediately.
D) Incremental backups are not allowed until a non-incremental backup is taken.
5. What correctly describes an MDC table rollout cleanup for qualifying DELETE statements after the statement shown below is run?
SET CURRENT MDC ROLLOUT MODE IMMEDIATE
A) MDC rollout optimization is used. The RID indexes are updated immediately during the delete process. The deleted blocks are available for reuse after the transaction commits.
B) MDC rollout optimization is not used. The RID indexes are updated immediately during the delete process. The deleted blocks are available for reuse after the transaction commits.
C) MDC rollout optimization is not used. The DELETE statement is processed in the same way as a DELETE statement that does not qualify for rollout.
D) MDC rollout optimization is used. The RID indexes are updated immediately during the delete process. The deleted blocks are available for reuse after an online REORG with the new RECLAIM EXTENTS clause.
Solutions:
| Question # 1 Answer: C | Question # 2 Answer: A | Question # 3 Answer: C | Question # 4 Answer: A,D | Question # 5 Answer: A |
By Edison
