IBM DB2 C2090-546

A IBM credential carries real weight with employers, and the IBM DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade exam is the step that earns it. Getcertkey makes that step shorter with 78 expert-prepared practice questions for the C2090-546 exam.

IBM C2090-546 Exam Overview:

Certification Vendor:	IBM
Exam Name:	IBM DB2 9.7 Database Administrator for Linux, UNIX and Windows Upgrade
Exam Number:	000-546
Real Exam Qty:	60-65
Available Languages:	English
Exam Duration:	90 minutes
Exam Price:	USD 200-250 (varies by region)
Certificate Validity Period:	2 years
Exam Format:	Scenario-based questions, Multiple choice
Passing Score:	60-70%
Related Certifications:	IBM Certified Database Administrator - DB2 9.7 for Linux, UNIX, and Windows
Recommended Training:	IBM DB2 9.7 Database Administration Training
Exam Registration:	IBM Certification Portal Pearson VUE Registration
Sample Questions:
Exam Way:	Online proctored or test center (Pearson VUE)
Pre Condition:	Recommended: IBM Certified Database Administrator - DB2 9.7 for LUW or equivalent DB2 administration experience
Official Syllabus URL:	https://www.ibm.com/training/certification

IBM C2090-546 Exam Syllabus Topics:

IBM DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade Exam FAQ: What Candidates Ask Most

What is the IBM C2090-546 exam?

The C2090-546 exam is the official IBM exam behind the IBM Certified Database Administrator - DB2 9.7 for Linux, UNIX, and Windows (Upgrade) certification, validating the skills measured by the IBM DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade credential. It sits at the Professional level of the IBM certification program. It also connects to IBM Certified Database Administrator - DB2 9.7 for Linux, UNIX, and Windows, so the knowledge you build here carries over to those tracks as well.

How many questions are on the C2090-546 exam, and how much time do I get?

The C2090-546 exam contains 60-65 questions to be completed within 90 minutes. Before exam day, divide the available time by the question count to work out a comfortable per-question pace, and mark any item that eats into it so you can return later instead of getting stuck. Timed sessions in the Getcertkey test engines make that pacing automatic — run at least two full-length mock exams under the clock so time pressure never becomes the reason you drop points.

What score do I need to pass the C2090-546 exam, and what does it cost?

The passing score for the C2090-546 exam is 60-70%, and the official registration fee is USD 200-250 (varies by region). Retakes are not discounted — every new attempt means paying the full fee again — so it pays to measure yourself before you book. Work through the 78 practice questions on Getcertkey, sit a timed practice test, and schedule your exam only when your scores are consistently comfortable. That simple habit is the cheapest exam strategy there is.

Are there any prerequisites for the C2090-546 exam?

Recommended: IBM Certified Database Administrator - DB2 9.7 for LUW or equivalent DB2 administration experience Requirements can change when IBM revises its certification program, so confirm the current eligibility rules on the official exam page before you register.

How do I register for the C2090-546 exam?

You can book the IBM DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade exam through the official registration channels below:

• IBM Certification Portal
• Pearson VUE Registration

As for delivery, the exam is offered in the following format: Online proctored or test center (Pearson VUE). Choose the option that suits you best when you book your seat.

What official training is recommended for the C2090-546 exam?

IBM recommends the following training resources for the IBM DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade exam:

• IBM DB2 9.7 Database Administration Training

Official courses build the foundation; the 78 practice questions from Getcertkey then show you how that knowledge is examined, so the two work best together.

Can I try the C2090-546 practice questions before I buy?

Yes. Getcertkey provides a free C2090-546 PDF demo so you can review the question style and answer quality before purchasing. Every purchase also includes 365 days of free updates — if IBM revises the exam during that period, the updated material reaches you at no cost. Once the free-update year ends, you can extend your update service at a 50% discount.

What if I fail the C2090-546 exam, and how is my order delivered?

Every IBM DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade purchase on Getcertkey is covered by a 100% money-back guarantee with clear conditions: if you take the corresponding exam within 60 days of your purchase and do not pass, you can claim a full refund by submitting a scanned copy of your exam enrollment slip and your official score report as a PDF within two days of the exam date; claims are processed within seven days of submission. The guarantee does not apply to exams taken within three days of purchase, to material that was downloaded but never used in an exam attempt, or to free products and expired orders, and the candidate name must match the payer name. If you would rather not take a refund, you can instead exchange your purchase for two free exam preparation products of equal value and keep the update service on your original product.

Delivery is instant: your download is sent to your email within one minute of payment, with no limit on how many computers you may install the material on. If nothing arrives within two hours, check your spam folder and contact customer service for help.

What topics are covered in the C2090-546 exam?

The IBM DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade exam blueprint is organized into 5 domains. The first three are:

• DB2 Architecture and Concepts
• Performance and Monitoring
• Installation, Upgrade and Migration

For the complete domain-by-domain breakdown, scroll up to the full exam topics outline above and use it to plan how you distribute your study time.

IBM DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade Sample Questions:

Question #1
Which function/stored procedure CANNOT be used to view audit facility data?

A. SYSPROAUDIT_LIST_LOGS
B. SYSPROC.AUDIT_ARCHIVE
C. SYSPROC.AUDIT_DELIM_EXTRACT
D. SYSPROC.AUDIT_AUTH

Question #2
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 the COMPRESS attribute for table TAB_A has been set to NO.
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 and both the table and the index have been REORGed.
D. The index will remain compressed until it is REORGed.

Question #3
The SALES database was created without AUTOMATIC STORAGE. If the following command is executed: ALTER DATABASE sales ADD STORAGE ON '/db2fs1', '/db2fs2' What is the expected result?

A. The SALES database is converted to AUTOMATIC STORAGE, all new table spaces will use the AUTOMATIC STORAGE paths, ALTER TABLESPACE statement is needed to convert existing table spaces.
B. The SALES database is converted to AUTOMATIC STORAGE, all new table spaces will use the AUTOMATIC STORAGE paths, existing table spaces need to be dropped and recreated.
C. The SALES database is converted to AUTOMATIC STORAGE and all its existing DMS table spaces are in rebalance pending state.
D. The SALES database and all its table spaces are converted to AUTOMATIC STORAGE.

Question #4
If table TAB_A has just been created as follows:

Which command will create a compression dictionary for table TAB_A?

A. DELETE FROM tab_a
B. UPDATE tab_a SET c1 = c1*1.1
C. REORG TABLE tab_a
D. LOAD FROM data.del OF DEL INSERT INTO tab_a

Question #5
Given the following DDL statements:

What is the end result of the CREATE INDEX statement?

A. TBSP21 and TBSP22 will each contain one local index.
B. TBSP21 will contain one index because NEW_IDX is not partitioned and will automatically go into the first index partition listed in the create table statement.
C. TBSP11 and TBSP12 will each contain one local index since the local indexes will physically reside in the same table space as the related data.
D. INDEX_TS will contain one non-partitioned index since the create index command is missing the PARTITION keyword.

Solutions: