Information Management System Test ( IMS Test)
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)
RDBMS (Oracle DB)
PHP (Database Connection)
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
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=18.104.22.168, 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?
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:
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?
Note:If score<= 30% then its a Weakness. If score >=70% then its a Strength.
Java EE, Oracle PL/SQL, Analytical Thinking
Good News! You can customize this test as per the job profile
- Choose and add questions from Interview Mocha question libraries
- Add your own set of questions
- Mail us at email@example.com to create a custom test
- Customize test settings like duration, number of questions, passing score, web proctoring and much more
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
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