American Broadcasting Company Senior Qa Software Engineer Interview Questions and Answers

There was aptitude test out of which 12 candidate selected

Q1. Asked me about my project in details
Add your answer
Q2. What does group by do in SQL.
Ans. 
GROUP BY in SQL is used to group rows that have the same values into summary rows.
• GROUP BY is used with aggregate functions like COUNT, SUM, AVG, etc.

• It is used to summarize data by grouping rows based on specified columns.

• GROUP BY is often used in conjunction with the SELECT statement.
Answered by AI
Add your answer
Q3. Then asked about spring boot
Add your answer

Technical aspects about linked list,trees, stacks

Topic related to humanities

Q1. Questions from Resume and projects
Add your answer
Q2. A coding question where high rank and low rank officers were given in an array in which number 1-8 represents high rank officers and apart from that there was a single integer which represents low rank off...read more
Add your answer

Q1. How do yo sharding in mongodb
Ans. 
Sharding in MongoDB involves partitioning data across multiple servers to improve scalability and performance.
• Sharding is achieved by dividing data into chunks based on a shard key

• Each shard contains a subset of the data, distributed across multiple servers

• MongoDB's sharding architecture includes config servers, query routers, and shard servers

• Sharding can be implemented at the collection level in MongoDB
Answered by AI
Add your answer

Q1. Python questions
Add your answer

Q1. Why you want to work here
Ans. 
I am passionate about software development and believe in the company's mission and values.
• I admire the company's innovative projects and technologies.

• I resonate with the company's culture of collaboration and continuous learning.

• I am excited about the opportunity to work with a talented team of developers.

• I believe my skills and experience align well with the company's needs.
Answered by AI
Add your answer

Q1. Basics of sql and some coding questions
Add your answer
Q2. Data structures
Add your answer

Q1. Putin arrays strings
Add your answer

Island Perimeter and Number of Provinces. Basic Leetcode question

Q1. What is closure
Ans. 
A closure is a function that has access to its own scope, the scope in which it was defined, and the global scope.
• A closure is created when a function is defined inside another function.

• The inner function has access to the variables and parameters of the outer function, even after the outer function has finished executing.

• Closures are useful for creating private variables and functions in JavaScript.

• They can also be us...read more
Answered by AI
Add your answer
Q2. What is Encapsulation
Ans. 
Encapsulation is the process of hiding internal details and providing a public interface for accessing and manipulating data.
• Encapsulation bundles data and methods together into a single unit.

• It helps in achieving data abstraction and data hiding.

• By encapsulating data, we can control access to it and prevent unauthorized modifications.

• Encapsulation promotes code reusability and maintainability.

• Example: A class in objec...read more
Answered by AI
Add your answer
Q3. What is Inheritance
Ans. 
Inheritance is a concept in object-oriented programming where a class inherits properties and behaviors from another class.
• Inheritance allows for code reuse and promotes the concept of hierarchy.

• The class that is being inherited from is called the superclass or base class.

• The class that inherits from the superclass is called the subclass or derived class.

• The subclass can access the public and protected members of the s...read more
Answered by AI
Add your answer
Q4. What is Abstraction
Ans. 
Abstraction is the process of simplifying complex systems by focusing on essential details.
• Abstraction involves hiding unnecessary details and exposing only relevant information.

• It allows developers to create models or representations that capture the essential aspects of a system.

• Abstraction helps in managing complexity, improving code reusability, and enhancing maintainability.

• For example, in object-oriented programm...read more
Answered by AI
Add your answer
Q5. What is Polymorphism
Ans. 
Polymorphism is the ability of an object to take on many forms. It allows objects of different classes to be treated as the same type.
• Polymorphism is a fundamental concept in object-oriented programming.

• It enables code reusability and flexibility.

• Polymorphism can be achieved through method overriding and method overloading.

• Example: A parent class Animal can have multiple child classes like Dog, Cat, and Bird. They can ...read more
Answered by AI
Add your answer

Q1. Merge sorted arrays
Add your answer

Q1. Checking cache using python
Ans. 
Use Python's built-in 'functools' module to check cache for function results.
• Import 'functools' module

• Use 'lru_cache' decorator to cache function results

• Specify 'maxsize' parameter to limit cache size

• Use 'cache_info()' method to get cache statistics
Answered by AI
Add your answer