Rolling Arrays Associate Consultant Interview Questions and Answers

Q1. Mysql query for 3rd highest salary
Ans. 
Use a subquery to find the third highest salary from the employees table in MySQL.
• Use a subquery to select distinct salaries from the employees table.

• Order the salaries in descending order and use LIMIT to get the third highest salary.

• Example: SELECT DISTINCT salary FROM employees ORDER BY salary DESC LIMIT 2, 1;
Answered by AI
Add your answer
Q2. What are the steps to connect to a database?
Ans. 
Steps to connect to a database involve specifying the database type, providing credentials, and establishing a connection.
• Specify the type of database you want to connect to (e.g. MySQL, PostgreSQL, MongoDB).

• Provide the necessary credentials such as username and password.

• Establish a connection using a programming language or tool like JDBC, ODBC, or ORM frameworks.
Answered by AI
Add your answer

Q1. Tell us about the change management
Add your answer
Q2. What is HEAD type of method in REST API Integration
Ans. 
HEAD method in REST API Integration is used to retrieve the headers of a resource without fetching the body.
• HEAD requests are similar to GET requests but only return the headers of the resource, not the body.

• This can be useful for checking the status of a resource or determining its size without downloading the entire content.

• For example, a HEAD request to a website URL will return the headers like content type, conten
Answered by AI
Add your answer

Q1. What is your proudest solution provided to the clients
Add your answer
Q2. Breif about your day to day activities
Add your answer

Q1. TEll us about yourself
Add your answer
Q2. Why should we hire you
Add your answer

The assignment is not very challenging

Q1. Where do you see yourself in next 5 years
Add your answer
Q2. What is SWOT analysis
Ans. 
SWOT analysis is a strategic planning tool used to identify Strengths, Weaknesses, Opportunities, and Threats of a business or project.
• Strengths: internal factors that give an advantage (e.g. strong brand reputation)

• Weaknesses: internal factors that may hinder success (e.g. limited resources)

• Opportunities: external factors that could be beneficial (e.g. new market trends)

• Threats: external factors that could cause troub
Answered by AI
Add your answer

Q1. About different joins in SQL
Add your answer
Q2. 1)About previous projects done in detail 2) Regarding any certification like dp-203 or spark certification 3) spark architecture 4) about delta table
Add your answer
Q3. Some questions about adf pipelines scenario based
Add your answer
Q4. Spark actions and transformation
Add your answer

Quite easy for the cs based students

Q1. Easy but need to answer creatively for every question
Add your answer
Q2. Tell me about yourself
Add your answer

Q1. Who developed c
Ans. 
C was developed by Dennis Ritchie at Bell Labs in the early 1970s.
• Developed by Dennis Ritchie at Bell Labs

• Created in the early 1970s

• Influenced by B programming language
Answered by AI
Add your answer

Q1. Coding problem statement
Add your answer

A 60-minute aptitude test.

In this round, you will receive multiple questions tailored to your area of expertise.

Q1. What motivated you to pursue a career in UI/UX design?
Add your answer
Q2. Could you please showcase your previous work experiences?
Add your answer