Ninestars Information Technologies Interview Questions and Answers

SQL query to find duplicate salaries in an employee table using GROUP BY and HAVING clauses.

• Use SELECT statement to specify the salary column.

• Utilize GROUP BY to group records by salary.

• Apply HAVING clause to filter groups with more than one occurrence.

• Example query: SELECT salary FROM employee GROUP BY salary HAVING COUNT(*) > 1;

Yes, I can change the location of data by updating the file path or database connection string.

• Update the file path in the code to point to a different location

• Change the database connection string to connect to a different server

• Modify the API endpoint to fetch data from a new location

I have experience working with various technologies including Java, Python, SQL, and AWS.

• Java

• Python

• SQL

• AWS

Assess the feasibility and impact of the request, communicate with the client and team, and devise a plan to meet the increased volume.

• Evaluate the current workload and capacity of the team and resources

• Assess the impact of the increased volume on the quality of service and delivery timeline

• Communicate with the client to understand the reason for the request and negotiate a feasible solution

• Collaborate with the te...read more

F1 is a high-speed, open-wheel racing championship that takes place annually around the world.

• F1 stands for Formula One and is the highest class of international auto racing

• It involves teams and drivers competing in a series of races called Grand Prix

• The cars are designed for speed and aerodynamics, with engines that can reach up to 15,000 RPM

• F1 has a huge global following and is known for its high-tech innovation...read more

Python regex allows for powerful string searching and manipulation using patterns.

• Regex is defined using the 're' module in Python.

• Common functions include re.search(), re.match(), and re.findall().

• Example: re.search(r'\d+', 'There are 123 apples') returns a match object for '123'.

• Special characters like '.' (any character), '*' (zero or more), and '+' (one or more) are used in patterns.

• Grouping can be done using ...read more