Home > All Tests > IBM > IBM DB/400 Test 
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 DB/400 Online Assessment Test

Topics Covered

  • Storage Manager Client Node
  • IBM DB2 SQL error messages
  • PIPE Statement
  • Keywords and Functions
  • Stored Procedures

Useful for hiring

  • AS/400 Developer
  • Application Developer - AS/400 System

Start hiring job-fit candidates using this assessment

GET A DEMO

"The best part of Interview Mocha is they have topic wise questions available. The skill wise extensive reports and advanced analytics lets us measure & benchmark the proficiency level of employees in that particular skill."

Cheryl Tolkinen, Securian, USA,
Learning & Development Manager
Sample Questions of This Test
Question

Which of the following order is correct for writing program that will modify report?

1. Modify the report specification to meet your requirements using your preferred technique.

2. To save the new report, use the method update(object, options) to overwrite the existing report in the content store with the new specification or method add(parentPath, object, options) to add a new report to the content store. Ensure that the search path you use for the new report is unique and that you do not overwrite another report.

3. Query the content store using the method query(objectPath, parameterValues, options) to retrieve the specification for your report. The query method returns an array of details, including the report. The specification is the value of the specification property for the returned report.

4. Use the method validateSpecification(specification, parameterValues, options) to confirm that the new report specification is valid.

Answer

    • 4 3 1 2

    • 1 2 3 4

    • 2 1 4 3

    • 3 1 4 2

Question

How to create a multi-member physical file?

Note: There can be multiple correct answers to this question.

Answer

    • ADDPFM FILE(AMINEM/ACCOUNT) MBR(MBR2)

    • STRDFU FILE(AMINEM/ACCOUNT) MBR(MBR2)

    • ADPFM FILE(AMINEM/ACCOUNT) MBR(MBR2)

    • CPYF FROMFILE(AMINEM/ACCOUNT) TOFILE(AMINEM/ACCOUNT) FROMMBR(ACCOUNT) TOMBR (MBR3) MBROPT(*ADD) CRTFILE(*NO) FROMRCD(1) NBRRCDS(3)

Question

What is missing in following script so it could run properly?

CREATE PROCEDURE divide ( IN numerator INTEGER,
                             IN denominator INTEGER, 
                              OUT divide_result INTEGER )
  LANGUAGE SQL
    BEGIN
       DECLARE overflow CONDITION FOR '22003';
      // ....
           RESIGNAL SQLSTATE '22375';
       IF denominator = 0 THEN
           SIGNAL overflow;
       ELSE
           SET divide_result = numerator / denominator;
       END IF;
     END

Answer

    • DECLARE CONTINUE HANDLER FOR overflow

    • DECLARE HANDLER FOR overflow

    • SET CONTINUE HANDLER FOR overflow

    • None of the mentioned

View Test Details

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

Related Tests

Why hiring managers and recruiters across the globe love Interview Mocha

Take your first step to hire job fit candidates

GET A DEMO