IBM DB/400 Online Assessment Test

Topics covered

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

  • MAQ (Multiple Answer Question)
  • MCQ (Multiple Choice Question)
  • Descriptive Question
  • White Board Simulator
  • Coding Simulator
  • Audio Question
  • Video Question
  • Case Study Question

IBM DB/400 Online Test helps Recruiters & Hiring Managers to effectively assess the skills of the DB/400 before an interview. IBM DB/400 is basically a relational database manager that is fully integrated on your AS/400. This IBM DB/400 skills test is designed to check the development and programming skills of DB/400 Developer - As per Industry Standards.

IBM DB 400 assessment test contains questions on following Topics:
 

  • Storage Manager Client Node

  • IBM DB2 SQL error messages

  • PIPE Statement

  • Keywords and Functions

  • Stored Procedures 


IBM DB400 pre employment test is designed & validated by our experienced subject matter experts (SME)s. 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.

This pre-employment test is useful for hiring:
  • AS/400 Developer
  • Application Developer - AS/400 System

Test details:

This IBM DB/400 skill test enables employers to identify & hire AS/400 developers by evaluating working skills and job readiness. For this reason, the emphasis is on evaluating the knowledge of applied skills gained through real work experience, rather than theoretical knowledge.

Test Details: 30 minutes

20 Application Questions


The combination of Application questions helps to evaluate Technical as well as practical Skills of Candidates.

IBM DB/400 Test

Question #1 of 3

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.

    • 4 3 1 2

    • 1 2 3 4

    • 2 1 4 3

    • 3 1 4 2

Question #2 of 3

How to create a multi-member physical file?

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

    • 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 #3 of 3

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

    • DECLARE CONTINUE HANDLER FOR overflow

    • DECLARE HANDLER FOR overflow

    • SET CONTINUE HANDLER FOR overflow

    • None of the mentioned

SAMPLE REPORT
Candidate Name: David Messi Test Date: 28-May-2014
Test Name: IBM DB/400 Test Test Start Time: 13.30

Score: 18 Out Of 20

Percentage: 90

Result: PASS

passing score image
SECTION PERFORMANCE
Section Name FAIL PASS
DB 400
Score: 18/20
STRENGTH AND WEAKNESS
Strength DB 400
Weakness -
* Note: If score <= 40 then its a Weakness. If score >= 80 then its a Strength.
ONLINE PROCTORING
0%
10 20 30 40 50 60 70 80 90 100%
Tolerable Limit Not acceptable
Window Violation: 0 | Time Violation: 0 secs
CANDIDATE DETAILS
Gender : Male Phone Number : +1-541-754-3010
Total Experience (Years) : 3 Total Experience (Months) : 5
Skill Set : DB 400 Current Employer : Interview Mocha
Current Job Title : Solution Architect Current Salary : 600.00
Expected Salary : 1000000.00 Current Location : Chicago

Sign up for a free trial today

Get your free trial and test up to 10 candidates. No strings attached. No credit card required.

SIGN UP FOR FREE

Schedule a Demo

How Interview Mocha works?

  • Add this test to your account

  • Invite candidates to take this test online

  • Candidates take the test

  • View and share actionable test reports

Trusted by leading brands worldwide

  • altran
  • credit suisse
  • sephora
  • nielsen
  • capgemini
  • hexaware
Why hiring managers and recruiters across the globe love Interview Mocha
  • Largest number of ready pre-employment skill tests
  • Relevant test compositions and quality questions designed by Subject Matter Experts (IM SME)
  • Fastest custom test creation DNA
  • World’s most super easy skill assessment platform
  • High level of platform security implementation
  • Friendly and quick customer support
  • Ready to listen and implement your feedback, we are all ears
  • Affordable pricing

Sign up for a free trial today

Get your free trial and test up to 10 candidates. No strings attached. No credit card required.

SIGN UP FOR FREE

Schedule a Demo