GlobalLogic 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. Sliding window problem
Ans. 
Sliding window technique is used to solve problems involving subarrays or substrings by creating a window that can expand and contract based on certain conditions.
• Maintain start and end indices to represent current window

• Adjust indices based on problem constraints

• Minimize number of elements processed for optimized performance
Answered by AI
Add your answer
Q2. How do you handle stress
Ans. 
I handle stress by practicing mindfulness, taking breaks, and seeking support from colleagues.
• Practice mindfulness techniques such as deep breathing or meditation

• Take short breaks throughout the day to recharge

• Seek support from colleagues or a mentor to talk through challenges

• Exercise regularly to reduce stress levels

• Maintain a healthy work-life balance
Answered by AI
Add your answer

Q1. OOPS concept with practical examples
Ans. 
OOPS concept refers to Object-Oriented Programming principles like Inheritance, Encapsulation, Polymorphism, and Abstraction.
• Inheritance: Allows a class to inherit properties and behavior from another class. Example: Animal class can inherit from Mammal class.

• Encapsulation: Bundling data and methods that operate on the data into a single unit. Example: Using private variables in a class.

• Polymorphism: Ability to present...read more
Answered by AI
Add your answer
Q2. ASP.NET design patterns
Add your answer

Find the occurrence of char in the String. print the duplicate characters.

Q1. What is Interface and Java 8 feature in Inter face?
Add your answer
Q2. Lambda expression for map?
Ans. 
Lambda expression for map applies a function to each element of a list and returns a new list.
• Syntax: list(map(lambda x: function(x), list_name))

• Example: list(map(lambda x: x*2, [1, 2, 3])) returns [2, 4, 6]

• Lambda expression can also be replaced with a named function
Answered by AI
Add your answer
Q3. MAP vs HASHMAP and difference between the Collection vs Collections.
Ans. 
MAP is an interface while HASHMAP is a class implementing it. Collection is an interface while Collections is a utility class.
• MAP is used to store key-value pairs while HASHMAP is a class implementing it.

• MAP is an interface while HASHMAP is a class implementing it.

• Collection is used to store a group of objects while Collections is a utility class providing various methods to manipulate collections.

• Collection is an inte...read more
Answered by AI
Add your answer
Q4. How to handle dropdown using selenium?
Ans. 
Dropdowns can be handled using Select class in Selenium.
• Locate the dropdown element using any of the locators available in Selenium

• Create an object of Select class and pass the dropdown element as argument

• Use selectByVisibleText(), selectByValue() or selectByIndex() methods to select an option

• Use getOptions() method to get all the options in the dropdown

• Use isMultiple() method to check if the dropdown allows multiple s...read more
Answered by AI
Add your answer
Q5. How to handle alerts and capture the screenshots?
Ans. 
Alerts can be handled using automation tools and screenshots can be captured using built-in functions or third-party libraries.
• Use automation tools like Selenium or Appium to handle alerts in web or mobile applications respectively.

• For capturing screenshots, use built-in functions like 'screenshot' in Selenium or third-party libraries like 'Puppeteer' in Node.js.

• Save the screenshots with appropriate names and in a desi...read more
Answered by AI
Add your answer

Q1. Scrum methodology and types of meetings.
Ans. 
Scrum methodology involves various meetings such as daily stand-up, sprint planning, review, and retrospective.
• Daily stand-up meetings are held to discuss progress and plan for the day.

• Sprint planning meetings are held at the beginning of each sprint to plan the work to be done.

• Sprint review meetings are held at the end of each sprint to review the work done and get feedback.

• Retrospective meetings are held at the end o...read more
Answered by AI
Add your answer
Q2. API testing using rest assured and types of assertion.
Add your answer
Q3. GIT commands and how to create project in git?
Ans. 
GIT commands and project creation in GIT
• GIT commands: add, commit, push, pull, clone, branch, merge

• To create a project in GIT: initialize a repository, add files, commit changes, create a remote repository, push changes to remote repository

• Example: git init, git add ., git commit -m 'initial commit', create a repository on GitHub, git remote add origin , git push -u origin master
Answered by AI
Add your answer
Q4. How to trigger the Job in Jenkins and How to configure
Add your answer
Q5. Types of wait in selenium and syntax.
Ans. 
Types of wait in Selenium and their syntax.
• Implicit Wait: driver.manage().timeouts().implicitlyWait(10, TimeUnit.SECONDS)

• Explicit Wait: WebDriverWait wait = new WebDriverWait(driver, 10); wait.until(ExpectedConditions.visibilityOfElementLocated(By.id("elementId")));

• Fluent Wait: Wait wait = new FluentWait(driver).withTimeout(Duration.ofSeconds(10)).pollingEvery(Duration.ofSeconds(2)).ignoring(NoSuchElementException.clas...read more
Answered by AI
Add your answer
Q6. What is POM and implementation in project?
Add your answer

Q1. Discussion related to salary.
Add your answer
Q2. Related to job location
Add your answer