Netcore Cloud Private Limited Email Deliverability Specialist Interview Questions and Answers

1st round is coding assessment round based on graph and hashmaps

Q1. Explain joins in SQL
Ans. 
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
• Joins are used to retrieve data from multiple tables based on a related column between them

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• INNER JOIN returns rows when there is at least one match in both tables

• LEFT JOIN returns all rows from the left table and the matched rows from the right table

• ...read more
Answered by AI
Add your answer
Q2. What are object and class in OOPs?
Ans. 
Objects are instances of classes in OOPs. Classes are blueprints for creating objects with attributes and methods.
• Objects are instances of classes

• Classes are blueprints for creating objects

• Classes define attributes and methods for objects

• Example: Class 'Car' with attributes like 'color' and methods like 'drive'
Answered by AI
Add your answer

Q1. EXPLAINATION of DSP and SSP
Ans. 
DSP stands for Demand-Side Platform and SSP stands for Supply-Side Platform in the context of programmatic advertising.
• DSP is a platform used by advertisers to purchase ad inventory in real-time auctions.

• SSP is a platform used by publishers to sell their ad inventory to advertisers.

• DSPs and SSPs work together in programmatic advertising to automate the buying and selling of ad space.

• DSPs use data and algorithms to targ...read more
Answered by AI
Add your answer

Q1. Java coding and development
Add your answer
Q2. Db and development skills
Add your answer

Q1. OOPS , multi thread, exception
Add your answer
Q2. Java 8 features
Add your answer

Moderate round . Easy to clear

Q1. Explain stream api
Ans. 
Stream API is a feature in Java that allows processing collections of objects in a functional style.
• Stream API provides a way to perform operations on a collection of objects in a declarative way.

• It supports functional-style operations like map, filter, reduce, and forEach.

• Streams can be created from various sources like collections, arrays, or I/O channels.

• Stream operations are lazy, meaning they are only executed whe...read more
Answered by AI
Add your answer
Q2. Data base connection in sprinh boot
Ans. 
Database connection in Spring Boot is configured using application.properties or application.yml file.
• Define database connection properties in application.properties or application.yml file

• Use @EnableJpaRepositories annotation to enable JPA repositories

• Use @Entity annotation to define entity classes

• Use @Autowired annotation to inject the DataSource or EntityManager
Answered by AI
Add your answer

Q1. Why you want to join in mgs
Ans. 
I want to join MGS because of its reputation for cutting-edge technology and innovative projects.
• Exciting opportunities for growth and learning

• Strong focus on technology and innovation

• Desire to work with talented and passionate individuals

• Alignment with company values and culture
Answered by AI
Add your answer
Q2. Notice period days
Add your answer

Q1. Life cycle of software development
Ans. 
Software development life cycle refers to the process of planning, creating, testing, and deploying software.
• Requirements gathering and analysis

• Design

• Implementation

• Testing

• Deployment

• Maintenance

• Examples: Waterfall model, Agile methodology
Answered by AI
Add your answer
Q2. Why finance sector
Ans. 
I am drawn to the finance sector due to its dynamic nature, opportunities for growth, and impact on global economy.
• Fascinated by the ever-changing market trends and economic dynamics

• Passionate about analyzing financial data and making strategic recommendations

• Excited about contributing to the growth and stability of businesses through financial insights
Answered by AI
Add your answer

Q1. Your best internship till date
Ans. 
My best internship was at a tech startup where I worked on developing a new mobile app.
• Collaborated with a team of developers to design and implement new features

• Analyzed user feedback to make improvements to the app

• Participated in meetings with clients to gather requirements and provide updates

• Gained hands-on experience with agile development methodologies
Answered by AI
Add your answer