Spy Health Interview Questions and Answers

The exam consists of seven sections, and the cutoff score is quite high; it is essential to complete the exam thoroughly.

Q1. Can you tell me about yourself?
Add your answer
Q2. Can you provide details about your internship experience?
Add your answer
Q3. Given a puzzle to solve
Add your answer
Q4. What can you tell me about your major projects?
Add your answer
Q5. What is the latest news you have heard regarding technology?
Add your answer

Q1. Queries on joins using inner join, left join, right join, outer join
Add your answer
Q2. What are the definitions of case and decode, what are the differences between them, and can you explain the logic for each?
Add your answer
Q3. What are the primary key and foreign key in database design, and can you provide examples of each?
Add your answer
Q4. What are the differences between Rank and Dense Rank in SQL?
Add your answer
Q5. What is the difference between procedures and functions?
Add your answer
Q6. Is it possible to use a package body without a package specification?
Add your answer
Q7. What is a SQL query that can be used to find duplicate values in a database?
Add your answer
Q8. Queries using group by and having clause
Add your answer
Q9. What are the definitions of the Substr and Instr functions?
Add your answer
Q10. What is the process for writing a SQL query that includes a subquery?
Add your answer
Q11. What is the difference between char, varchar, and varchar2 data types?
Add your answer
Q12. Queries using Trunc and round
Add your answer
Q13. Is it possible to combine two tables with differing data and columns without utilizing joins?
Add your answer
Q14. Is it possible to update data in a view?
Add your answer

Q1. Can you describe yourself and provide details about your project, including the brief questions that were asked about it?
Add your answer
Q2. Why TCS?
Add your answer
Q3. What is a dynamic cursor in database management?
Add your answer
Q4. Did you perform performance tuning, and if so, what steps did you take?
Add your answer
Q5. What is the definition of a package, and is it possible to use a package body without a package specification?
Add your answer
Q6. I got more questions from my project related
Add your answer

Q1. What are your reasons for wanting to join TCS?
Add your answer
Q2. What is your current salary package?
Add your answer
Q3. What is your expected salary package?
Add your answer
Q4. Are you comfortable with shift work?
Add your answer
Q5. Are you ok with any location
Add your answer
Q6. Holding any other offers in hand
Add your answer

A sequence was provided: 4181, 2684, 1597, 987, 610.
first 2 are given and write code for other value calculation using java 8

The second question required writing a reverse of a palindrome using both Java 8 streams. I was able to successfully write both and clear the first round.

Q1. Interviewer was himself not knowing anything as it was walkin drive he was sitting infront of me and checking questions on phone Introduction that he inturrepted in between when I was introducing myself
Add your answer
Q2. What are the features of Java 17, specifically related to sealed classes, including their syntax and necessity, along with the potential errors encountered when invoking a sealed class?
Ans. 
Java 17 introduces sealed classes to restrict inheritance and improve code maintainability.
• Sealed classes are declared using the 'sealed' keyword followed by the permitted subclasses.

• Subclasses of a sealed class must be either final or sealed themselves.

• Errors may occur when trying to extend a sealed class with a non-permitted subclass.
Answered by AI
Add your answer
Q3. Java 8 feathers stream api, functional interface, Intermittent operator ,Ternary operator, Prediction,Bi predicate. Answered all successfully
Add your answer
Q4. Draw low level design of implementation of notify me if item is back in stock in a ecommerce application
Ans. 
Implementation of 'notify me if item is back in stock' feature in an ecommerce application
• Create a database table to store user notifications for out-of-stock items

• Implement a service to check item availability and send notifications to subscribed users

• Provide a user interface for users to subscribe to notifications for specific items
Answered by AI
Add your answer
Q5. All design patterns which I know. Asked me to implement adapter pattern on paper
Add your answer
Q6. Then given a problem that concurrent way perform operation on excell to decrease the response time
Add your answer

Q1. Current CTC, Expected CTC, Notice Period, Skill set
Add your answer
Q2. Open for Fixed term hire? Open for working from client location at Gurgaon? (3 days from office)
Ans. 
Yes, open for fixed term hire and working from client location at Gurgaon for 3 days a week.
• Open for fixed term hire

• Willing to work from client location at Gurgaon for 3 days a week
Answered by AI
Add your answer

Q1. Introduction, Current role and responsibilities
Add your answer
Q2. List out the achievements in current project, Tools used
Ans. 
Implemented automated testing using Selenium WebDriver and JUnit in Agile environment
• Implemented automated testing framework using Selenium WebDriver

• Utilized JUnit for test case management

• Worked in Agile environment to ensure continuous testing and integration
Answered by AI
Add your answer
Q3. Pilot vs Beta testing. How can newly developed functionality be tested via automation rather doing it manually?
Ans. 
Pilot testing is done by a small group of users before the full release, while beta testing is done by a larger group of users. Automation testing can be used for regression testing, smoke testing, and performance testing.
• Pilot testing involves a small group of users testing the functionality in a controlled environment.

• Beta testing involves a larger group of users testing the functionality in a real-world environment.

• ...read more
Answered by AI
Add your answer
Q4. Primary key vs Unique key in SQL, Query to find row having last id in sql
Ans. 
Primary key uniquely identifies a record, while unique key allows only one instance of a value in a column. Query to find last id involves using ORDER BY and LIMIT.
• Primary key enforces uniqueness and not null constraint on a column

• Unique key enforces uniqueness but allows null values

• To find row with last id, use ORDER BY id DESC LIMIT 1 in SQL query
Answered by AI
Add your answer
Q5. Explain Software Testing Life Cycle, Defect Life Cycle
Ans. 
Software Testing Life Cycle (STLC) involves planning, designing, executing, and reporting on tests. Defect Life Cycle includes identification, logging, fixing, and retesting defects.
• STLC includes requirements analysis, test planning, test design, test execution, and test closure.

• Defect Life Cycle involves defect identification, defect logging, defect fixing, defect retesting, and defect closure.

• STLC ensures that the so...read more
Answered by AI
Add your answer
Q6. What's the meaning of 303 status code in API? Put vs Delete method in API What is 3 point estimation technique in Agile?
Ans. 
303 status code in API means 'See Other'. PUT method is used to update data, while DELETE method is used to remove data. 3 point estimation technique in Agile is used to estimate tasks.
• 303 status code indicates that the resource can be found at a different URI and should be retrieved from there

• PUT method is used to update an existing resource in the API

• DELETE method is used to remove a resource from the API

• 3 point esti...read more
Answered by AI
Add your answer
Q7. What kind of links and labels can be tagged to a bug in jira?
Ans. 
Links and labels that can be tagged to a bug in Jira
• Links: related issues, documents, websites

• Labels: priority, severity, type, status
Answered by AI
Add your answer
Q8. Have you done shell scripting? What does grep, href commands do in unix?
Ans. 
Shell scripting is a way to automate tasks in Unix/Linux systems. Grep is used to search for specific patterns in text files. Href is not a standard Unix command.
• Shell scripting automates tasks by writing scripts in a Unix/Linux environment

• Grep command is used to search for specific patterns in text files

• Example: grep 'search_pattern' file.txt

• Href is not a standard Unix command, it may be a typo or a custom script
Answered by AI
Add your answer
Q9. As a lead, how would you resolve conflict with a team member? As a lead, if you are given plenty of tasks to be completed with in a limited time frame. What would be your approach in doing them?
Ans. 
To resolve conflict with a team member, communication is key. Prioritize understanding, address the issue calmly, find common ground, and work towards a solution together.
• Listen to the team member's perspective and concerns

• Communicate openly and calmly about the issue

• Find common ground and areas of agreement

• Work together to find a solution that benefits both parties

• Seek input from other team members or a mediator if ne
Answered by AI
Add your answer
Q10. Open for relocating to Bangalore and working from client's office? (with no relocation bonus) Open for working in night / rotational shift? (with no additional compensation) Open for working in long exten...read more
Ans. 
Open to relocating to Bangalore, working in night shifts, long hours, and 24X7 culture. Goal is to excel in automation testing.
• Yes, open to relocating to Bangalore and working from client's office

• Yes, open to working in night/rotational shifts

• Yes, open to working in long extendable hours or 24X7 culture

• Goal is to excel in automation testing
Answered by AI
Add your answer