Global Education 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. Basic Questions
Add your answer

Q1. Previous Job Related Questions & experience related questions
Add your answer

Q1. Technical Questions & Previous Experience related questions.
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. All related to manual and automation testing and little about api nd performance testing too
Add your answer

Q1. Whatever u wrote on resume and some technical stuff with onsite guy
Add your answer

Q1. With your Mananger all related to resume and technical stuff
Add your answer

Q1. All hr questions
Add your answer

Q1. Salary discussion
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