Xyz Company Rollout Manager Interview Questions and Answers

Q1. Questions related to the JD
Add your answer

Q1. Database questions for Java position
Add your answer
Q2. SQL performance techniques
Ans. 
SQL performance techniques
• Use indexes to speed up queries

• Avoid using SELECT * and only select necessary columns

• Use stored procedures to reduce network traffic

• Avoid using subqueries and instead use JOINs

• Use EXPLAIN to analyze query performance

• Normalize database tables to reduce redundancy

• Use connection pooling to reduce overhead

• Avoid using cursors and use set-based operations instead
Answered by AI
Add your answer

Q1. Linux shell script for reading and parsing the flat file
Ans. 
A Linux shell script can be used to read and parse a flat file.
• Use the 'read' command to read the file line by line

• Use 'cut' command to parse the data based on delimiter

• Use 'awk' command to filter and manipulate data

• Use 'sed' command to search and replace data

• Use 'grep' command to search for specific patterns in the file
Answered by AI
Add your answer

Q1. What are your salary expectations?
Add your answer
Q2. Why are you looking for a change?
Add your answer
Q3. Where do you see yourself in 5 years?
Add your answer
Q4. Minimum salary expectation
Add your answer

Hanker rank
1. DataStructure questions like linked list reverse and rearrange the odd and even
2. SQL write a query using join
3. Program using collections
4. Linux cmds objectives
5. Java objectives

Q1. F2F round: 1. Simple Java program like a. Palindrome for a string using recursive method b. Count a duplicate char from string with out using a collection
Add your answer

Q1. F2F round : 1. Where generic questions will be asked about your past experience and challenges which you have faced 2. They will share you the scenario we need to write a program
Add your answer

Q1. F2F round: 1. Questions on framework 2. Simple question on java 3. JSON parsing and assertions for api testing
Add your answer

Q1. Hiring manager round: 1. Infrastructure level questions will be asked 2. Automation Testing strategy and estimations 3. About ROI Basically it's like culture fit round
Add your answer

Depends on the business unit and a hackerearth test

Q1. QA automation typical questions
Add your answer

Q1. Automation typical questions
Add your answer

Q1. Core Java moderate to tough coding and Questions
Add your answer

Q1. General technical questions for different problem not necessarily related to Automation stack depends on the interviewer if Dev lead or QA lead
Add your answer

Q1. Chapter lead again QA APPROACH BASED QUESTIONS
Add your answer

Q1. Salary not any tough questions
Add your answer

It was a HackerRank test with 2 java/dsa questions and 1 sql question.

Q1. In this round I was asked to solve 2 logical program. Then they asked few questions related to the program why I have used that data structure or stream what are the other approaches and all. Then 1 scena...read more
Add your answer

Q1. Again some dsa programs and scenario based questions I was asked.
Add your answer

Q1. I was asked few questions about my previous project. And normal discussion about the tools and technologies I had worked.
Add your answer

Q1. Salary discussion+ organization related discussion
Add your answer