Pass the actual test with the help of C2090-320 study guide
Last Updated: Sep 06, 2026
No. of Questions: 122 Questions & Answers with Testing Engine
Download Limit: Unlimited
Help you pass test with Actualtests4sure updated C2090-320 Actual Test Questions at first time. All exam materials of IBM C2090-320 test questions are with validity and reliability, compiled and edited by the experienced experts team, which can help you prepare and attend exam casually and then pass the IBM C2090-320 test surely.
Actualtests4sure has an undoubtedly 99.6% one-shot pass rate among our customers.
We're confident in our products that we promise "Money Back Guaranteed".
A IBM credential tells employers that your skills meet the vendor's own standard. Prepare for the C2090-320 exam with 122 expert-verified practice questions from Actualtests4sure, and walk into the test center knowing exactly what to expect.
| Certification Vendor: | IBM |
|---|---|
| Exam Name: | DB2 11 Fundamentals for z/OS |
| Exam Number: | C2090-320 |
| Real Exam Qty: | 60 |
| Exam Duration: | 90 minutes |
| Passing Score: | 60-65% |
| Certificate Validity Period: | 2 years |
| Available Languages: | English |
| Exam Format: | Scenario-based questions, Single answer, Multiple choice |
| Exam Price: | $200 USD (varies by region) |
| Related Certifications: | IBM Certified Database Administrator - DB2 11 for z/OS IBM Certified Advanced Database Administrator - DB2 for z/OS |
| Recommended Training: | IBM DB2 11 for z/OS Training |
| Exam Registration: | Pearson VUE IBM Exams IBM Certification Portal |
| Sample Questions: | IBM C2090-320 Sample Questions |
| Exam Way: | Proctored online or Pearson VUE test center |
| Pre Condition: | Recommended basic knowledge of SQL and mainframe (z/OS) concepts |
| Official Syllabus URL: | https://www.ibm.com/certify |
| Section | Objectives |
|---|---|
| SQL and Database Objects | - Database objects
|
| DB2 Security | - Authorization and privileges
|
| DB2 for z/OS Architecture | - Data storage concepts
|
| Performance and Monitoring | - Monitoring tools
|
| Data Recovery and Utilities | - DB2 utilities
|
The IBM C2090-320 exam, officially titled DB2 11 Fundamentals for z/OS exam, is the required test for earning the IBM Certified Specialist - DB2 11 Fundamentals for z/OS certification, a credential at the Associate level. Passing it validates the skills IBM expects from certified professionals, and it can also support progress toward related credentials such as IBM Certified Database Administrator - DB2 11 for z/OS, IBM Certified Advanced Database Administrator - DB2 for z/OS.
The C2090-320 exam includes 60 questions, and you have 90 minutes to complete it. Before exam day, divide the available time by the question count so you know the pace you need to hold, and practice flagging time-consuming items for review instead of stalling on a single question. Timed sessions in the Actualtests4sure test engine are the easiest way to build that rhythm before it counts.
You need 60-65% to pass the C2090-320 exam, and the official registration fee is $200 USD (varies by region). Keep in mind that a failed attempt means paying that fee in full again for a retake, so avoid booking your seat on a hunch. Work through the Actualtests4sure practice test until your scores sit comfortably above the passing requirement before you schedule the exam.
IBM asks candidates to meet the following requirement before registering: Recommended basic knowledge of SQL and mainframe (z/OS) concepts. Exam policies do change, so confirm the latest details on the official exam page at https://www.ibm.com/certify before you book.
You can book your seat through the official registration channels below:
The C2090-320 exam is delivered in the following format: Proctored online or Pearson VUE test center.
IBM recommends the following official training for this exam:
A course builds the theory; practice turns it into exam-day performance. Once you finish a class, the 122 practice questions from Actualtests4sure show you how the same knowledge appears in exam-style items.
Yes. Actualtests4sure offers a free PDF demo of the IBM DB2 11 Fundamentals for z/OS practice questions, so you can judge the quality and format before purchasing. After you buy, your purchase includes 365 days of free updates; if the product expires after that period, you can extend the update service at a 50% discount from your member zone.
Every Actualtests4sure order is covered by a 100% Money Back Guarantee. If you take the corresponding C2090-320 exam within 60 days of purchase and do not pass, send a scan of your exam enrollment slip together with your official Score Report PDF within two days of the exam date, and your claim will be processed within seven days. The candidate name must match the payer name, and the guarantee does not apply if you take the exam within three days of purchase, if you downloaded the product but never took the exam, or to free materials and expired orders. If you would rather have fresh material than a refund, you can exchange your purchase for two additional exam products of equal value at no cost and keep the update service on your original product. Delivery itself is instant: your download is available right after payment and a copy is emailed to you within one minute — if nothing arrives within two hours, contact our support team. You may install the software on as many computers as you need.
The IBM DB2 11 Fundamentals for z/OS exam is organized into 5 major domains. Some of the key domains include:
Scroll up to the Exam Topics section for the complete breakdown, and use it to plan how much study time each domain deserves.
Question 1
Which of the following statements will create an application-period temporal table?
A. CREATE TABLE POLICY_ATT(BANK VARCHAR(4),
SYS_BEGIN TIMESTAMP NOT NULL, SYS_END TIMESTAMP NOT NULL, CLIENT CHAR(4)T TYPE CHAR(5), PAY INT, PERIOD SYSTEM_TIME(SYS_BEG1N, SYS_END));
B. CREATE TABLE POLICY_ATT(BANK VARCHAR(4). SYS_BEGIN TIMESTAMP. SYS_END TIMESTAMP, CLIENT CHAR(4), TYPE CHAR(5), PAY INT, PERIOD SYSTEM_TIME(SYS_BEGIN, SYS_END));
C. CREATE TABLE POLICY_ATT(BANK VARCHAR(4),
BUS_BEGIN TIMESTAMP NOT NULL, BUS_END TIMESTAMP NOT NUK, CLIENT CHAR{4), TYPE CHAR(5), PAY INT. PERIOD BUSINESS_TIME(BUS_BEGIN. BUS_END));
D. CREATE TABLE POLICY_ATT(BANK VARCHAR(4). BUS_BEGIN TIMESTAMP. BUS_END TIMESTAMP.
CLIENT CHAR(4), TYPE CHAR(5), PAY INT. PERIOD BUSINESS_TIME(BUS_BEGIN. BUS_END));
Question 2
Which characteristic best describes a created global temporary table?
A. Inserts are logged
B. Rows are locked when they exist in the table
C. They have permanent, shareable descriptions
D. Access to rows can be shared across multiple processes
Question 3
Which of the following statements about a system-period temporal table is TRUE?
A. Rows can be archived into a history table which is always read only
B. The table contains only the current active rows
C. AN SQL query for auditing can be run against current data or history data, but not both
D. Every row has a pair of timestamps which is set and managed by the application
Question 4
When the following SQL statement is executed, the user SMITH is able to manage all objects in the DB2 subsystem except for which of the following?
GRANT DBADM ON SYSTEM TO smith;
A. Traces
B. Sequences
C. Security Objects
D. Tables
Question 5
Which of the following automatically maintains historical versions of data over several years?
A. A partitioned-by-growth table
B. A partitioned-by-range table
C. A system-period temporal table
D. An application-period temporal table
Solutions:
| Question 1 Answer: D | Question 2 Answer: C | Question 3 Answer: D | Question 4 Answer: D | Question 5 Answer: C |
Over 71645+ Satisfied Customers

Caesar
Dominic
Geoffrey
Ives
Lionel
Nicholas
Actualtests4sure is the world's largest certification preparation company with 99.6% Pass Rate History from 71645+ Satisfied Customers in 148 Countries.