Are you a candidate looking to sharpen your skills? Try our practice tests or view sample interview questions & Get hired by the best. Click Here×

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."

Pedro Furtado, Altran,
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 touch

Global companies using Mocha assessments

  • altran
  • credit suisse
  • sephora
  • nielsen
  • capgemini
  • akamai

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...
GET A DEMO

Why hiring managers and recruiters across the globe love Interview Mocha

Take your first step to hire job fit candidates

GET A DEMO