Online IBM DB2 Fundamentals Test
Topics Covered
- SQL Scalar User-defined Functions
- SQL Statements and Procedures
- OLTP WorkloadQuery Tuner
- DB2 Objects
Useful for hiring
- DB2 DBA
- Database Administrator
- DB2 Mainframe System Engineer
Start hiring job-fit candidates using this assessment
GET A DEMO
"Finding quality talent is a challenge more so when you consider the sheer number of resumes we get each year. To top this, the time we spent on our recruitment process was humongous. Interview Mocha helped us to cut down on our candidate filtration time by 40%, making it our preferred assessment tool."
Capacity Manager
Question
In a trusted context environment, if a switch request is made with an authorization ID that is not allowed on a trusted connection, what state is the connection placed in?
Answer
-
Locked
-
Waiting
-
Pending
-
Unconnected
Question
Which SQL statement should be used to select the minimum and maximum salaries (SALARY), by job code (JOB), from a table EMPLOYEE?
Answer
-
SELECTjob, MIN(salary), MAX(salary)
FROM employee
GROUP BY job;
-
SELECT job, MIN(salary), MAX(salary)
FROM employee
ORDER BY job;
-
SELECT job, MIN(salary), MAX(salary)
FROM employee
GROUP BY job, MIN(salary), MAX(salary);
-
SELECT JOB, MIN(salary),MAX(salary)
FROM employee
ORDER BY job, MIN(salary), MAX(salary);
Question
Which two operations are allowed in the body of an SQL scalar user-defined function?
Note: There can be multiple correct answers to this question.
Answer
-
CALL statements
-
External file access
-
Use of a scratch pad
-
COMMIT statements
-
SQL control statements
Test details:
IBM DB2 pre-employment test enables employers and recruiters to identify potential DB2 DBA by evaluating working skills and job readiness. For this reason, the emphasis is laid upon evaluating the knowledge of applied skills gained through real work experience, rather than theoretical knowledge.
Test Details: 20 minutes
20 Application Questions
The combination of Application and Theory questions helps to evaluate Technical as well as practical Skills of Candidates.
Test description:
Online IBM DB2 Administrator Test helps Recruiting Team & Hiring Managers to effectively assess the database skills of candidates before an interview. IBM DB2 DBA skills Test is designed to check the application and SQL fundamentals skills of IBM DB2 Administrator- as per industry standards.
The IBM DB2 Fundamentals Test contains questions on following Topics:
-
SQL Scalar User-defined Functions
-
SQL Statements and Procedures
-
OLTP WorkloadQuery Tuner
-
DB2 Objects
This test on IBM DB2 basics is designed & validated by our subject matter experts to evaluate knowledge of the DB2 administrator before hiring. Using powerful reporting, you can have a detailed analysis of the test results to help you make a better hiring decision and predict the candidate’s performance.
The test contains MCQ's (Multiple Choice Questions), MAQ's (Multiple Answer Questions), Fill in the Blank, Descriptive, True or False.
Good News! You can customize this test as per your requirement
Choose and add questions from Interview Mocha question libraries
Add your own set of questions
Customize test settings like duration, number of questions, passing score, web proctoring and much more
Mail us at support@interviewmocha.com to create a custom test
Looking for a tailor-made test, to suit your assessment needs?
Get in touchGlobal companies using Mocha assessments
How Mocha assessments are brewed

Speed up your IT recruitment with Interview Mocha
- 500+ IT skill tests
- 20+ coding languages
- 50+ domain knowledge tests
- 100+ digital 2.0 skill tests
- Customer focus aptitude tests
- Enterprise ready features & more...