iMerit Data Annotator 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. Diff between Coalesce and repatriation
Add your answer

Q1. Python Coding Question 1: Make a list with all datatypes objects in it.
Ans. 
Create a list containing all Python data types.
• Use the following data types: int, float, complex, str, list, tuple, dict, set, bool, bytes, bytearray, memoryview, None

• Example: ['int', 'float', 'complex', 'str', 'list', 'tuple', 'dict', 'set', 'bool', 'bytes', 'bytearray', 'memoryview', 'None']
Answered by AI
Add your answer
Q2. Python Coding Question 2: Extract a character from the string present in the list.
Ans. 
Extract a character from a string in a list of strings.
• Iterate through the list of strings

• Use indexing to extract the desired character from each string

• Handle cases where the index is out of range

• Return the extracted characters as a new list
Answered by AI
Add your answer
Q3. Python Coding Question 3: Make a dictionary with Name and Age having 4 records.
Ans. 
Create a dictionary with Name and Age for 4 records in Python.
• Use curly braces {} to create a dictionary.

• Separate key-value pairs with a colon :

• Separate each record with a comma ,
Answered by AI
Add your answer
Q4. Python Coding Question 4: Make a string and write code to return the output with the reverse string.
Add your answer
Q5. Python Coding Question 5: Write a function to check if the string is Palindrome. Check the function with a Palindrome.
Ans. 
Function to check if a string is a palindrome.
• Create a function that takes a string as input.

• Reverse the string and compare it with the original string.

• Return true if they are the same, false otherwise.

• Example: 'racecar' is a palindrome.
Answered by AI
Add your answer
Q6. SQL Coding Question 1: Write an SQL query to extract the data from employees table, extract day of joining, month of joining, year of joining from the "Date Of Joining".
Add your answer
Q7. What is Data normalization and standardization?
Ans. 
Data normalization is the process of organizing data in a database efficiently, while data standardization is the process of ensuring consistency and uniformity in data.
• Data normalization involves organizing data into tables and columns to reduce redundancy and improve data integrity.

• Data standardization involves ensuring that data is consistent and uniform across the database.

• Normalization helps in reducing data redun...read more
Answered by AI
Add your answer
Q8. Statistics/Probability Question: 4 ball of each colors(Red, Green, Blue) are present in the box. After drawing 3 ball randomly from the box, what is the probability of getting all 3 ball having the same co...read more
Ans. 
The probability of drawing 3 balls of the same color from a box containing 4 balls of each color (Red, Green, Blue).
• Calculate the total number of ways to draw 3 balls out of 12 balls

• Calculate the number of ways to draw 3 balls of the same color

• Divide the number of favorable outcomes by the total number of outcomes to get the probability
Answered by AI
Add your answer

Q1. Why don't you take experienced people
Ans. 
We are open to hiring both experienced and inexperienced individuals to bring a diverse range of skills and perspectives to our team.
• We believe in providing opportunities for growth and development to individuals at all stages of their career.

• Fresh perspectives and new ideas from inexperienced individuals can bring innovation to the team.

• Experienced individuals may have set ways of doing things that could benefit from ...read more
Answered by AI
Add your answer
Q2. 2 years experience SAP & ERP
Add your answer

Q1. Questions related to projects
Add your answer

Q1. Questions related to projects and some scenario based questions
Add your answer

Q1. Complete interview was on project discussion
Add your answer
Q2. On ensemble models some questions on stats
Add your answer