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×

IBM DB2 Online Interview Test

Topics Covered

  • embedded SQL statements
  • index statements
  • primary and secondary authorization ID
  • Rebind statement

Useful for hiring

  • Database admin
  • DB2 administrator
  • Jr. DB2 Developer

Start hiring job-fit candidates using this assessment

GET A DEMO

"We are impressed with Interview Mocha's comprehensive IT skill test batteries and their ability to provide tailor-made assessments quickly. The results we got from Interview Mocha exceeded our expectations, employees found the tests quick, fun, and a benchmark of their knowledge."

Ajay Garg, Siemens,
Associate Manager
Question

Given the following cursor declaration:

DECLARE COURSEUPDATE CURSOR FOR
SELECT CSTITLE
FROM TU00001.COURSES
FOR UPDATE OF CDUR

Which of the following embedded SQL statements will use this cursor correctly?

Answer
    • UPDATE TU00001.COURSES
      SET CDUR = 5

    • UPDATE TU00001.COURSES
      SET CDUR = 5
      WHERE CURRENT OF COURSEUPDATE

    • UPDATE SET CDUR = 5
      WHERE CURRENT OF COURSEUPDATE

    • UPDATE TU00001.COURSES C
      SET C.CSTITLE = 'New Title'
      WHERE CURRENT OF COURSEUPDATE

Question

The following commands are issued against a database containing a table:

TBACCAD.TUTCOURSES:
CREATE ALIAS TBACCAD.COUR FOR TBACCAD.TUTCOURSES;
CREATE ALIAS USR.COUR FOR TEMP.COUR;
CREATE ALIAS TU00001.COURSES FOR USR.COUR

If user TU00001 issues the following statement,
SELECT * FROM COUR

Which of the following objects will be accessed?

Answer
    • TBACCAD.COUR

    • USR.COUR

    • TEMP.COUR

    • TU00001.COUR

Question

Which of the following statements concerning storage groups is NOT true?

Answer
    • All the volumes in a storage group must be of the same device type (e.g. tape, disk, ...).

    • Volumes can only have standard VSAM datasets allocated.

    • The volumes in a storage group are controlled by a VSAM catalog.

    • Storage groups may overlap. The same volume may belong to more than one storage group.

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