We're so confident of our products that we provide no hassle product exchange.
IBM DB2 Fundamentals for LUW Exam Certification Details:
| Exam Price | $200 (USD) |
| Duration | 90 mins |
| Exam Code | C2090-616 |
| Books / Training | IBM Knowledge Center |
| Sample Questions | IBM DB2 Fundamentals for LUW Sample Questions |
| Exam Name | IBM Certified Database Administrator - DB2 11.1 for Linux UNIX and Windows |
| Passing Score | 68% |
| Number of Questions | 63 |
| Schedule Exam | Pearson VUE |
IBM C2090-616 Exam Overview:
| Certification Vendor: | IBM |
| Exam Name: | IBM DB2 11.1 Fundamentals for LUW |
| Exam Number: | C2090-616 |
| Passing Score: | 60-65% |
| Exam Format: | Multiple choice, Multiple response |
| Real Exam Qty: | 60-65 |
| Related Certifications: | IBM Certified Database Administrator - DB2 IBM Certified Advanced Database Administrator - DB2 IBM Certified Solution Expert - DB2 |
| Available Languages: | English |
| Exam Price: | USD 200 (varies by region) |
| Certificate Validity Period: | 3 years |
| Exam Duration: | 90 minutes |
| Recommended Training: | IBM DB2 Training Courses |
| Exam Registration: | Pearson VUE IBM Exams IBM Certification Registration |
| Sample Questions: | IBM C2090-616 Sample Questions |
| Exam Way: | Proctored online or authorized test center (Pearson VUE) |
| Pre Condition: | No formal prerequisites; basic knowledge of databases and SQL recommended. |
| Official Syllabus URL: | https://www.ibm.com/training/certification |
How to book C2090-616 Exam
Register for IBM Certified Database Administrator - DB2 11.1 for Linux UNIX and Windows Certification Exam on Pearson VUE
IBM C2090-616 Exam Syllabus Topics:
| Topic | Details | Weights |
|---|---|---|
| Working with DB2 Data using SQL | - Demonstrate the ability to use SQL to SELECT data from tables -Demonstrate the ability to use SQL to UPDATE, DELETE, or INSERT data - Demonstrate the ability to manage transactions -Demonstrate the ability to create and call an SQL stored procedure or a user defined function -Identify and describe SQL compatibility enhancements -Identify the OLAP function used to meet a specific business requirement | 19% |
| Data Concurrency | -Identify factors that influence locking -List objects on which locks can be obtained -Identify characteristics of DB2 locks -Given a situation, identify the isolation level that should be used | 14% |
| Working with Databases and Database Objects | -Create and connect to DB2 servers and databases -Identify DB2 objects -Identify and describe the DDL statements available -Describe the different types of tables available | 16% |
| Working with DB2 Tables, Views, and Indexes | -Identify and describe the DB2 data types available -Identify the characteristics of a table, view or index -Demonstrate the ability to create and use temporary tables -Demonstrate the ability to create and use triggers | 13% |
| Planning | -Identify and describe the DB2 products available -Identify and decribe the DB2 Cloud offerings available -Describe the characteristics of OLTP and Data Warehouse workloads -Describe the benefits of DB2 pureScale -Demonstrate the ability to use DB2 BLU Acceleration -Explain Federation support -Identify and describe Oracle and Netezza Compatibility Features | 21% |
| Security | -Describe methods used to restrict data access -Identify and describe the authorities and privileges available -Identify and describe the DCL statements available -Describe Roles and Trusted Contexts | 17% |
Reference: https://www.ibm.com/certify/exam.html?id=C2090-616
C2090-616 - DB2 11.1 Fundamentals for LUW
C2090-616 exam is part of the new IBM Certified Database Associate certification. This exam is an entry point for a user of any of the DB2 family of products. Candidates must have knowledge about the fundamentals concepts of DB2 11.1, database security, database transaction isolation and basic SQL (Structured Query Language). Candidates have the ability to do basic to intermediate tasks required in day-to-day administration, understand how to create databases and database objects.
By Maxine
