CMS IT Services Data Analyst Interview Questions and Answers

1 python question and 1 sql question for coding and rest were the mcqs based on sql and python.

Q1. Python code was asked for checking the anagrams
Add your answer
Q2. Sql code asked to solve on screen share using various use cases like group by, having, count
Add your answer

Q1. Python code was asked for swaping any number but without using python libraries
Add your answer
Q2. Sql code was asked using concepts of rank dense,rank, partition by
Add your answer

Q1. Briefing about my last job
Add your answer

Q1. On python data manipulation(easy)
Add your answer
Q2. Sql(intermediate)
Add your answer

DURATION 1.3 HRS WITH REASONING AND 2 CODING QUESTION

Q1. SQL QUESTION FIND N TH HIGHEST SALARY
Ans. 
Use SQL query with ORDER BY and LIMIT to find the Nth highest salary.
• Use ORDER BY clause to sort salaries in descending order

• Use LIMIT to specify the Nth highest salary

• Example: SELECT salary FROM employees ORDER BY salary DESC LIMIT N,1
Answered by AI
Add your answer
Q2. SQL QUESTION PIVOT TABLE QUESTION
Add your answer

Q1. Introduce yourself
Add your answer

Hacker Rank test Write a query to fetch the EmpFname from the EmployeeInfo table in upper case and use the ALIAS name as EmpName

Q1. SQL or Structured Query Language is a standard language for dealing with relational databases. With the humongous amount of data present, it is very important for us to understand how to use queries to ret...read more
Add your answer

Q1. Any question wtihtout i'm very honested and cearfully
Add your answer
Q2. My goal setting and my hobby ect.
Add your answer

The aptitude test consists of MCQ on computer technicals , english, verbals, etc as like usual aptitude test. Also it includes 2-3 sql queries to solve as well as 1-2 coding questions with easy to medium level difficulty.

Q1. Technical round was around 1 hour. They had asked me the technical questions related to computer fundamentals like networking, DS, OOP, etc. Then he went on java code and their programming basics like adap...read more
Add your answer

Q1. HR was the telephonic round for me. They just asked normal hr questions like intro, strengths, weakness, location preferences, technologies on which i had worked on etc. They have also gave me the CTC info...read more
Add your answer