Zensar Technologies Senior Lead Consultant Interview Questions, Process, and Tips

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;

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.

I am currently responsible for managing client relationships and project timelines in my current company.

• Managing client relationships by ensuring clear communication and addressing any concerns or issues promptly

• Creating and maintaining project timelines to ensure deliverables are met on time

• Collaborating with cross-functional teams to ensure project success

• Providing regular updates to clients on project progress and

SAP PP involves business processes related to production planning and control.

• Creation of production orders

• Material requirement planning

• Capacity planning

• Shop floor execution

• Production scheduling

The org structure of SAP refers to the way in which SAP organizes its internal departments, teams, and reporting relationships.

• SAP typically follows a matrix organizational structure, with functional departments (such as sales, marketing, finance) and project teams working together.

• The org structure can vary depending on the size and complexity of the organization, as well as the specific industry or market focus.

• SAP m...read more

Program to convert aaabbbcdd string to a3b3c1d2.

• Iterate through the input string and keep track of the current character and its count

• Append the character and its count to a new string as you iterate

• Return the new string once all characters have been processed

Program to find count of palindromes in a given string

• Iterate through each substring and check if it is a palindrome

• Use two pointers approach to check for palindromes efficiently

• Consider both odd and even length palindromes

• Handle edge cases like single characters and empty strings

• Example: Input 'ababa', Output: 5 (a, b, aba, b, a)

GraphQL is a query language for APIs, Web workers run scripts in background threads, Service workers are scripts that run in the background and can intercept network requests.

• GraphQL is a query language for APIs that allows clients to request only the data they need.

• Web workers run scripts in background threads separate from the main browser thread, improving performance by handling tasks concurrently.

• Service workers a...read more

SOA focuses on large, monolithic services while Microservices are small, independent services.

• SOA is a centralized architecture with shared services, while Microservices are decentralized with each service having its own database.

• SOA is typically implemented using ESB (Enterprise Service Bus), while Microservices communicate via lightweight protocols like HTTP or messaging queues.

• SOA is more suitable for large enterpri...read more