Certification: IBM Certified Database Associate - DB2 10.1 Fundamentals
Certification Full Name: IBM Certified Database Associate - DB2 10.1 Fundamentals
Certification Provider: IBM
Exam Code: C2090-610
Exam Name: DB2 10.1 Fundamentals
C2090-610 Exam Product Screenshots
The IBM Certified Database Associate: DB2 10.1 Fundamentals certification aim is to provide database associates with the appropriate knowledge about the DB2 10.1 fundamental concepts. The certification provides in-depth knowledge on the intermediate tasks and basic tasks that are required in the day-to-day administration. It also provides understanding of basic SQL and additional DB2 10.1 products.
Who can do this Certification?
Those having the affinity for knowledge in database fundamentals including but not limited to physical and logical database designs, SQL language, relational database theory, using stored procedures, XML and using functions, are well suited for IBM Certified Database Associate: DB2 10.1 Fundamentals certification.
After acquiring this certification from IBM the individual will have wide knowledge including configuring, installing, monitoring and managing theDB2 in the Linux environment. He will have knowledge in tools and procedures that are needed for database recovery and database back-up, system monitoring and online maintenance. He will also have ability to build and run DB2 applications contained in Linux.
The attainment of IBM Certified Database Associate: DB2 10.1 Fundamentals certification requires an individual to pass only one exam called C2090-610: DB2 10.1 Fundamentals test. This exam makes up the second step in the certification path. You are required to pass this test in order to be awarded this certification and move on to the next level of IBM certifications.
There are courses that one can take prior before the certification. However, these courses are recommended but they are not a mandatory to have them before thetest. The courses help to prepare for this certification exam. These courses are but not limited to SQL Workshop, DB2 Fundamentals, Database Fundamentals, and A Redbook Called Up and Running with DB2 on Linux.The individual should also have familiarity in and basic knowledge in SQL. He or she should have entry-level experience using the DB2 10.
The C2090-610: DB2 10.1 Fundamentals test
The exam covers mainly 6 big topics which are outlined below:
- Data concurrency- locking, DB2 locks, isolation levels (13%)
- Working with views, tables and indexes in DB2 (22%) - Types of DB2 data, temporary table, schemas, data constraint.
- Working with the DB2 Data Using the SQL (20%) –select data, sort data, update, insert, delete data
- Working with the Databases and the Database Objects-characteristics, properties, create objects
- The Security (15%)-restricting data, column and row access control, trusted contexts.
- Planning (10%)-database workloads, DB2 products, data concepts.
This entry level test will test skills in integrating DB2 for UNIX, Linux and Windows with Red hat and SUSE operating systems of Linux. It may also test whether you can be able to install, configure, manage and monitor DB2 in the Linux environment among other skills. The individual needs to study in deep the above outlined topics for him or her to pass this test. The full exam topic details more exam preparation tools are available in the website of the vendor.
The questions contained in this test are 69 questions. The candidate is allowed a total of ninety minutes (or one and a half hours) to attempt all the questions as per the exam details. The candidate must attain 66% to pass the exam. There are no essays or assignments that require to be submitted to attain this certification.
Validity of the certification
This is one of those IBM certifications that has no expiry date.
Steps Involved in the Certification
The steps required to be completed in this certification process are 3
- Training: SQL Workshop, DB2 Fundamentals, Database Fundamentals, and A Redbook Called Up and Running with DB2 on Linux
- Exam: C2090-610: DB2 10.1 Fundamentals test
- Form: completing the course submission form.
The steps do not have to be completed in the order of listing. However, completion of the course submission form must be the last step.
One of the most valuable company assets is data. Hierarchical and relational databases will and have been in use in industries for number of years. This data have to be managed by professionals. Linux on the other hand is one of the server operating platform that is growing so fast. Therefore companies must find for professionals who are knowledgeable in the Linux and are knowledgeable in databases. IBM is known for the leadership it has shown in technology. Therefore, taking the IBM Certified Database Associate: DB2 10.1 Fundamentals certification from IBM is the best decision you can make today.
Elias Mbao, Woodworks Company
Frequently Asked Questions
How can I get the products after purchase?
All products are available for download immediately from your Member's Area. Once you have made the payment, you will be transferred to Member's Area where you can login and download the products you have purchased to your computer.
How long can I use my product? Will it be valid forever?
Test-King products have a validity of 90 days from the date of purchase. This means that any updates to the products, including but not limited to new questions, or updates and changes by our editing team, will be automatically downloaded on to computer to make sure that you get latest exam prep materials during those 90 days.
Can I renew my product if when it's expired?
Yes, when the 90 days of your product validity are over, you have the option of renewing your expired products with a 30% discount. This can be done in your Member's Area.
Please note that you will not be able to use the product after it has expired if you don't renew it.
How often are the questions updated?
We always try to provide the latest pool of questions, Updates in the questions depend on the changes in actual pool of questions by different vendors. As soon as we know about the change in the exam question pool we try our best to update the products as fast as possible.
How many computers I can download Test-King software on?
You can download the Test-King products on the maximum number of 2 (two) computers or devices. If you need to use the software on more than two machines, you can purchase this option separately. Please email firstname.lastname@example.org if you need to use more than 5 (five) computers.
What is a PDF Version?
PDF Version is a pdf document of Questions & Answers product. The document file has standart .pdf format, which can be easily read by any pdf reader application like Adobe Acrobat Reader, Foxit Reader, OpenOffice, Google Docs and many others.
Can I purchase PDF Version without the Testing Engine?
PDF Version cannot be purchased separately. It is only available as an add-on to main Question & Answer Testing Engine product.
What operating systems are supported by your Testing Engine software?
Our testing engine is supported by Windows. Andriod and IOS software is currently under development.