Adrenalin Esystems Interview Questions and Answers

Q1. Design schema for movie booking system ?
Ans. 
Design schema for a movie booking system.
• Create tables for movies, theaters, users, bookings, and payments.

• Use foreign keys to establish relationships between tables.

• Include attributes like movie title, showtime, seat number, user details, booking status, payment details, etc.

• Consider implementing a booking algorithm to handle seat selection and availability.

• Ensure data integrity and normalization for efficient data re
Answered by AI
Add your answer
Q2. How would u scale the app (database wise) over India ?
Ans. 
To scale the app database over India, consider sharding, replication, and using cloud services.
• Implement sharding to distribute data across multiple servers based on geographic location or other criteria.

• Set up replication to ensure data consistency and availability in different regions.

• Utilize cloud services like AWS or Azure to easily scale resources based on demand.

• Optimize queries and indexes to improve database pe...read more
Answered by AI
Add your answer

Q1. What is sharding vs partitioning
Ans. 
Sharding and partitioning are both techniques used in database management to improve performance and scalability by dividing data into smaller chunks.
• Sharding involves splitting a database into smaller, independent databases called shards, each responsible for a subset of the data.

• Partitioning involves dividing a database into smaller segments called partitions, each containing a subset of the data based on a defined c...read more
Answered by AI
Add your answer
Q2. What are the 3 basic components of database, and do a RCA for why a DB is down.
Ans. 
The 3 basic components of a database are data, schema, and software. An RCA for a DB being down involves identifying the root cause of the issue.
• Data: the actual information stored in the database, such as customer records or product details.

• Schema: the structure that defines how the data is organized and related to each other, including tables, fields, and relationships.

• Software: the database management system (DBMS) ...read more
Answered by AI
Add your answer

Q1. About yourself, your past work experience and why you want to get into this role The interviewer was very calm and just wanted to learn about the background.
Add your answer

Q1. All behavioural questions- 1 how do your prioritise your work? 2 do you have experience in managing cross functional teams? 3 what if one of your Co-worker decline working on a project, How would you tackl...read more
Add your answer

Q1. Again all behavioural questions- How do you work with large volume of works? How do you manage work life balance? How do you give harsh feedbacks to your coworkers?
Add your answer

Q1. All behavioural questions again- same as above just a bit here and there asked in different ways
Add your answer

A link was provided for the 15-minute online aptitude test.

90 minutes coding round. There were three problems. One for JavaScript and two for ReactJS

Q1. Mostly ReactJS questions were asked and a few Javascript questions were asked.
Add your answer

Q1. Again a few react based questions then it was mostly discussion on the past experiences.
Add your answer

Q1. A general discussion about the notice period, compensation, and information about the company's culture was provided.
Add your answer

Q1. Basic to intermediate.net, EF, SQL, C#, OOP
Add your answer
Q2. Basics of .Net Core
Add your answer

Q1. Deep into.net and sql
Add your answer

Q1. Introducing your self and project
Add your answer
Q2. Severity and priority
Add your answer
Q3. Smoke and sanity testing
Add your answer
Q4. Scenario base question if find bug before release
Add your answer

Q1. Java 8 features
Add your answer
Q2. Functional interfaces with custom functional interface coding question
Add your answer
Q3. Stream apis and one coding question
Add your answer
Q4. Spring framework,IOC container, bean scopes.
Add your answer
Q5. Different between monolithic and micro services architecture. Pros and cons.
Add your answer
Q6. REST apis
Add your answer
Q7. Few SQL queries
Add your answer

Q1. Tell me about youself
Ans. 
Experienced PMO Manager with a background in project management and strong leadership skills.
• Over 5 years of experience in project management

• Skilled in developing project plans and timelines

• Strong leadership and team management abilities

• Excellent communication and problem-solving skills

• Managed cross-functional teams to successfully deliver projects on time and within budget
Answered by AI
Add your answer
Q2. Resume based questions
Add your answer
Q3. Projects related qquestions
Add your answer

Q1. My expertise are in golang. And all the questions were straight forward around golang.
Add your answer
Q2. What is concurrency. How to check performance of applications. How to handle concurrency. How many no of goroutines can be created and so on.
Ans. 
Concurrency is the ability of a system to run multiple tasks simultaneously. Performance of applications can be checked using profiling tools. Concurrency can be handled using synchronization techniques like mutexes and channels.
• Concurrency allows multiple tasks to run concurrently, improving performance and responsiveness.

• Performance of applications can be checked using profiling tools like Go's built-in 'pprof' packa...read more
Answered by AI
Add your answer

Q1. How to make sure there are no vulnerabilities. What engineering principles you follow.
Ans. 
To ensure no vulnerabilities, follow secure coding practices, conduct regular security audits, use encryption, and stay updated on security threats.
• Follow secure coding practices such as input validation, output encoding, and parameterized queries.

• Conduct regular security audits to identify and address vulnerabilities in the code.

• Use encryption to protect sensitive data in transit and at rest.

• Stay updated on security t...read more
Answered by AI
Add your answer