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

"Our recruitment team loves Interview Mocha especially for their skill assessments, simulators, and friendly support. Since using Interview Mocha, we interview only relevant candidates, and this has reduced our time to hire. Recruitment is no longer an hassle for us."

Christoph, e-Zest GmbH
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

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