menubar side image
imocha logo
  1. Home
  2. Skill Tests
  3. IBM Tests
  4. IBM DB/400 Test

IBM DB/400 Online Assessment Test

Candidates Assessed

21423+

Organizations Served

128+

iMocha’s IBM DB/400 test is the ideal pre-hire test for recruiters and hiring managers to assess candidates objectively. This assessment is useful for hiring AS/400 Developer and Application Developer - AS/400 System. Our test has helped our customers to reduce hiring time by 45%.

About IBM DB/400 Online Assessment Test

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.

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.

Are you a jobseeker looking to sharpen your skills?

Test Summary

IBM DB400 pre-employment test is designed & validated by our experienced Subject Matter Experts (SME). 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.

IBM DB 400 assessment test may contain MCQs (Multiple Choice Questions), MAQs (Multiple Answer Questions), Fill in the Blanks, Whiteboard Questions, Audio / Video Questions, LogicBox (AI-based Pseudo-Coding Platform), Coding Simulators, True or False Questions, etc.

Test Duration: 20 minutes

No. of Questions: 10

Level of Expertise: Entry/Mid/Expert

Useful for hiring

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

Topics Covered

right arrow
Storage Manager Client Node

iMocha’s IBM DM/400 online test helps recruiters and hiring managers to evaluate candidate’s understanding about storage manager which helps to manage the data on virtual or physical server

right arrow
IBM DB2 SQL error messages

Our assessment evaluates applicant’s knowledge about error codes that are used to diagnose code failure and fix the error

right arrow
PIPE Statement

This DB 400 assessment test evaluates applicant’s understanding about pipe statements used in DB 400 that helps to return one row from a table function in a database

right arrow
Keywords and Functions

Our test evaluates applicant’s ability to use keywords that performs some operations and functions is set of statements that performs specific task

right arrow
Stored Procedures

This IBM DB/400 skill test assesses candidate’s ability to use stored procedures which a set of code that can be called or reused whenever needed

Sample Questions

Choose from our 100,000+ question library or add your own questions to make powerful custom tests

Question types:

Multiple Option

Topic:

-

Difficulty:

Easy

Q 1. 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 types:

Multiple Answer

Topic:

-

Difficulty:

Easy

Q 2. 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 types:

Multiple Option

Topic:

-

Difficulty:

Easy

Q 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

View Full Report . . .

Skill wise performance report by iMocha

Hire job-fit candidates using this test now

You can customize this test by

difficulty level
Setting difficulty level of test      

Choose easy, medium or hard questions from our skill libraries to assess candidates of different experience levels.                       

multiple skills
Combining multiple skills into one test

Add multiple skills in a single test to create an effective assessment. Assess multiple skills together.                                              

adding own skill
Adding your own questions to the test

Add, edit or bulk upload your own coding questions, MCQ, whiteboarding questions & more.                       

tailor made test
Requesting a tailor-made test                  

Get a tailored assessment created with the help of our subject matter experts to ensure effective screening.

Related Skills

Trusted By

Rehana Nisar, Global Product & Services Recruitment Head, Gartner
gartner Logo

“We realized that to acquire quality talent, our recruitment process was in dire need of automation. Too many of our technical team were simply wasting hours conducting interviews that did not yield the desired results. For us, the foremost criteria was to find a recruitment partner who could tick all the right boxes.”

Rehana Nisar, Global Product & Services Recruitment Head,

Gartner

capgemini logo
coupa logo
ericsson logo
cognizant logo
nice logo
wipro logo

Start hiring job-fit candidates using this assessment

Schedule a demo
Start your free trial