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

"Interview Mocha's assessments eliminated reliance on resumes and reduced our time to hire by half. Now we spend time only on relevant candidates and take data-driven hiring decisions."

George Nichkov, Gett,
Global Analytics Team Lead
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.

Test details:

This IBM DB2 interview Test enables employers and recruiters to identify potential IBM DB2 database admin or consultant 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.

Questions : 20

Duration : 20 minutes

  • Mainframes  : The test contains 20 questions on Mainframes to assess the candidate in that particular area.

Test description:

DB2 Online Test helps you to evaluate the IBM DB2 skills of an applicant before an interview to hire as IBM DB2 Database administrator. IBM DB2 Database is basically a product developed by IBM which is a family of database server. IBM DB2 Database software offers the industry with reliability, leading performance and scalability with your choice of platform such as Linux, UNIX and Windows. The IBM DB2 test is designed & developed in assessing the DB2 Database Skills, RDBMS, knowledge of Linux or AIX, knowledge of monitoring and tuning the database of IBM DB2 Database admin- as per industry standards.

This IBM DB2 knowledge Test consists of meaningful questions on embedded SQL statements, index statements, primary and secondary authorization ID, Rebind statement and much more. 
 
The Online DB2 database Test is designed by our subject matter experts to evaluate knowledge of the DB2 database 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