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×

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

Useful for hiring

  • System Engineer - IMS
  • Mainframe Developer - IMS
  • IMS DB Function Expert

Start hiring job-fit candidates using this assessment

GET A DEMO

"Our recruitment team loves Interview Mocha especially for their skill assessments, simulators, and friendly support. Since using Interview Mocha, we interview only relevant candidates, and this has reduced our time to hire. Recruitment is no longer an hassle for us."

Christoph, e-Zest GmbH
Question

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.

Assuming 
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?

Answer
    • =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

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=6.121.2.0, 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 http://go.microsoft.com/fwlink/?LinkId=260882 for more information. 
"

What is the Most Likely solution to this problem?

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

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?

Answer
    • 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)

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.

Test description:

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.

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