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
"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."
Associate Manager
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
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: 20 minutes
10 Application Questions
The combination of Application questions helps to evaluate Technical as well as practical Skills of Candidates.
Test description:
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.
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 touchGlobal companies using Mocha assessments
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...