Information Management System Test ( IMS Test)

Topics covered

Web Development (ASP), WebDevelopment (PHPMySQL), MS Exchange, RDBMS (Oracle DB), PHP (Database Connection), Regular Expressions, Exchange Server, Net Programming

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

IMS (Information Management System) test is useful to effectively assess the candidate's skills before an interview. Information Management System is a hierarchical database and information management system with extensive transaction processing capabilities. IMS test is designed to check the application and management skills. The test is created and validated by Subject Matter Experts.

Test Topics :
The IMS Test contains questions on following topics :  

  • Web Development (ASP)

  • WebDevelopment (PHPMySQL)

  • MS Exchange

  • RDBMS (Oracle DB)

  • PHP (Database Connection)

  • Regular Expressions

  • Exchange Server

  • Net Programming

The IMS Test contains MCQ's (Multiple Choice Questions), MAQ's (Multiple Answer Questions), Fill in the Blank, Descriptive, True or False. Using powerful reporting, you will have a detailed analysis of test results to help you make better decisions and predict candidate and employee success.

This pre-employment test is useful for hiring:
  • System Engineer - IMS
  • Mainframe Developer - IMS
  • IMS DB Function Expert

Test details:

IMS Test enables employers and recruiters to evaluate skills and job readiness of candidates. For this reason, the emphasis is laid upon evaluating the knowledge of applied skills gained through real work experience, rather than theoretical knowledge.

Test Details: 20 minutes 

20 Application Questions

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

IMS Test (Information Management System Test)

Question #1 of 3

I have a spreadsheet with two columns, one with a date, and one with a time range.

A2: CourseDate      B2: Course Time
9/7/2016            9:00 am - 9:50 am

But I need to convert it to the following: start date/time and end date/time like below.

Start Date/Time      End Date/Time
9/7/16 9:00 AM      9/7/16 9:50 AM

I tried text to columns for the time and then did a concatenate to put the date and time together. However, doing that changes the time to something like 0.375. Changing the format of the cells didn’t help either.

A2 = 9/7/2016
B2 = 9:00 am - 9:50 am

Which of the following will give the desired result if used as the formula for START TIME and END TIME respectively?

    • =A2+LEFT(B2,FIND("-",B2)-1) and =A2+REPLACE(B2,1,FIND("-",B2)+1,"")

    • =A2+REPLACE(B2,1,FIND("-",B2)+1,"") and =A2+LEFT(B2,FIND("-",B2)-1)

    • =A2+LEFT(B2,FIND("-",B2)-1) and =B2+LEFT(A2,FIND("-",A2)-1)

    • =A2+REPLACE(B2,1,FIND("-",B2)+1,"") and =B2+REPLACE(A2,1,FIND("-",A2)+1,"")

Question #2 of 3

I have code that works perfectly well on the Development server. But when published to the testing server, it bugs out with the following message:

The Entity Framework provider type 'Oracle.ManagedDataAccess.EntityFramework.EFOracleProviderServices, Oracle.ManagedDataAccess.EntityFramework, Version=, Culture=neutral, PublicKeyToken=89b483f429c47342' registered in the application config file for the ADO.NET provider with invariant name 'Oracle.ManagedDataAccess.Client' could not be loaded. Make sure that the assembly-qualified name is used and that the assembly is available to the running application. See for more information. 

What is the Most Likely solution to this problem?

    • Delete the affected config file and reinstall it

    • First compile the application using an Assembler before publishing it

    • Convert the application to Assembly language

    • Install the Oracle Entity Framework on the testing server

Question #3 of 3

I have a field in my Oracle database from which I would love to select everything except the last 3 characters of the field value. Example:
Current Value (edt_nbr)   |    Expected Result
----------------------------------- |------------------------
EDITradepartners850      |    EDITradepartners
MMCCEDI850                    |    MMCCEDI

I tried using the left function and discovered Oracle does not have the LEFT (or RIGHT) function, but fortunately, it has the SUBSTR function which can serve similar purposes. After reading a bit about the SUBSTR function, I came up with the following query to do what I want:

SELECT edt.edi_nbr, 
       Substr(edt.edi_nbr, 1, Length(edt.edi_nbr) - 3) AS TPID 
FROM   prod.edtrdptnrs edt;

It worked perfectly while selecting edi_nbr. However, when I tried selecting another field, it did not work. I tried another and then another only to discover that it works well for some fields and doesn't work well for others. Now this is driving me crazy.

Which of the following modifications of the SUBSTR function above would make the query work on CHAR data types as well?

    • substr(edt.edi_nbr,1,length(ltrim(edt.edi_nbr))-3)

    • substr(edt.edi_nbr,1,length(rtrim(edt.edi_nbr))-3)

    • substr(edt.edi_nbr,1,length(utrim(edt.edi_nbr))-3)

    • substr(edt.edi_nbr,1,length(dtrim(edt.edi_nbr))-3)

Candidate Name
Assessment Name
Invited by
Assessment Date
IP Address

24.00 Out of 40.00
23 Minutes

Java EE




Oracle PL/SQL


Analytical Thinking


Note:If score<= 30% then its a Weakness. If score >=70% then its a Strength.


Java EE, Oracle PL/SQL, Analytical Thinking




It was a good test for me, the questions were on the latest technology of java on which I am currently working. It was a great experience. Thank you!

Related Tests

Take your first step to hire job fit candidate


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
  • akamai
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

Take your first step to hire job fit candidate