GlobalLogic Interview Questions, Process, and Tips for Experienced

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. Who is your favourite writer, and what makes their work stand out to you?
Add your answer
Q2. What is your favourite movie name, why did you like it, and what do you consider to be it's main goal?
Add your answer

Q1. Difference between scrum and Kanban
Ans. 
Scrum is a framework for agile project management with fixed-length iterations, while Kanban is a visual system for managing work as it moves through a process.
• Scrum has fixed-length iterations called sprints, usually 2-4 weeks long, while Kanban does not have fixed time frames.

• Scrum requires a prioritized backlog of work, while Kanban focuses on visualizing and limiting work in progress.

• Scrum emphasizes cross-function...read more
Answered by AI
Add your answer

Q1. What is bias variance trade off
Ans. 
Bias-variance tradeoff is the balance between underfitting and overfitting in machine learning models.
• Bias refers to error from erroneous assumptions in the learning algorithm, leading to underfitting.

• Variance refers to error from sensitivity to fluctuations in the training data, leading to overfitting.

• The tradeoff involves finding the right level of model complexity to minimize both bias and variance.

• Regularization te...read more
Answered by AI
Add your answer

Q1. Describe 5 non functional requirements
Ans. 
Non functional requirements are criteria that specify how a system should behave, rather than what it should do.
• Performance - system should respond within 2 seconds for all user interactions

• Scalability - system should be able to handle 1000 concurrent users

• Reliability - system should have a 99.99% uptime

• Security - system should encrypt all sensitive data

• Usability - system should have a user-friendly interface
Answered by AI
Add your answer
Q2. How will you improve performance of legacy app which has to work with your latest microservice.
Ans. 
Improve legacy app performance by optimizing code, implementing caching, and scaling resources.
• Optimize code by identifying and removing bottlenecks

• Implement caching to reduce database calls and improve response time

• Scale resources by using containers or serverless architecture

• Use asynchronous processing for long-running tasks

• Upgrade hardware or infrastructure if necessary
Answered by AI
Add your answer

Q1. Explain security in microservices
Ans. 
Security in microservices involves implementing authentication, authorization, encryption, and monitoring to protect data and services.
• Implement authentication and authorization mechanisms to control access to microservices.

• Use encryption to secure communication between microservices and external clients.

• Implement monitoring and logging to detect and respond to security incidents.

• Consider using API gateways for central...read more
Answered by AI
Add your answer
Q2. Describe microservices architecture for a wealth management app
Ans. 
Microservices architecture for a wealth management app involves breaking down the application into smaller, independent services.
• Each microservice focuses on a specific business function, such as client onboarding, portfolio management, or reporting.

• Services communicate through APIs, allowing for flexibility and scalability.

• Each microservice can be developed, deployed, and scaled independently, leading to faster develo...read more
Answered by AI
Add your answer

Q1. Performance optimisation
Add your answer

Q1. Lods,parameters
Add your answer

Q1. Sql queries on analytical queries
Add your answer
Q2. Different constraints and join methods
Ans. 
Different constraints and join methods in database queries
• Constraints in database queries ensure data integrity and enforce rules on data

• Join methods in database queries are used to combine rows from two or more tables based on a related column between them

• Examples of constraints include primary key, foreign key, unique key, and check constraints

• Examples of join methods include inner join, outer join (left, right, full
Answered by AI
Add your answer

It was mostly on sub queries.