Filter interviews by
Top trending discussions
I applied via LinkedIn and was interviewed in Aug 2024. There were 2 interview rounds.
Different types of joins include inner join, outer join, left join, and right join. Self join is when a table is joined with itself.
Inner join: Returns rows when there is a match in both tables
Outer join: Returns all rows when there is a match in one of the tables
Left join: Returns all rows from the left table and the matched rows from the right table
Right join: Returns all rows from the right table and the matched row...
A view is a virtual table created by a query. It can be used to simplify complex queries, provide security, and improve performance.
Views can hide complexity by encapsulating multiple tables into a single virtual table.
Views can restrict access to certain columns or rows, providing security.
Views can improve performance by pre-computing joins or aggregations.
Example: CREATE VIEW vw_employee AS SELECT emp_id, emp_name F
Optimizing SQL queries involves using indexes, minimizing data retrieval, and avoiding unnecessary joins.
Use indexes on columns frequently used in WHERE clauses
Minimize data retrieval by selecting only necessary columns
Avoid unnecessary joins by using subqueries or temporary tables
posted on 17 May 2024
I applied via Approached by Company and was interviewed in Apr 2024. There were 3 interview rounds.
posted on 11 Oct 2024
I applied via Approached by Company and was interviewed in Sep 2024. There were 2 interview rounds.
posted on 6 Oct 2024
I applied via Recruitment Consulltant and was interviewed in Sep 2024. There was 1 interview round.
posted on 5 Mar 2024
I applied via Approached by Company
Inheritance is a concept in object-oriented programming where a class inherits attributes and methods from another class.
Allows for code reusability by creating a new class based on an existing class
Child class can access and modify the attributes and methods of the parent class
Helps in creating a hierarchy of classes with shared characteristics
A life cycle hook in auto scaling allows you to perform custom actions before an instance is launched or terminated.
Life cycle hooks can be used to pause the instance launch process to perform custom actions.
Common actions include validating the instance configuration or setting up additional resources.
Examples of life cycle hooks include 'Launch' and 'Terminate'.
posted on 20 Oct 2023
I applied via Recruitment Consulltant and was interviewed in Sep 2023. There were 3 interview rounds.
I applied via Approached by Company and was interviewed in Jan 2024. There were 2 interview rounds.
posted on 11 Apr 2024
The difficult session involved addressing challenging behavior and lack of motivation among trainees.
Focused on identifying root causes of behavior and motivation issues
Implemented personalized strategies to address individual needs
Used positive reinforcement and encouragement to boost morale
Provided additional support and resources for struggling trainees
I applied via Recruitment Consulltant and was interviewed in Oct 2023. There were 3 interview rounds.
They gave assignment to edit the article, write video script, and e learning presentations.
based on 13 reviews
Rating in categories
French Teacher
5
salaries
| ₹0.6 L/yr - ₹5.4 L/yr |
Headmistress
3
salaries
| ₹8 L/yr - ₹9.4 L/yr |
TGT Social Science Teacher
3
salaries
| ₹5 L/yr - ₹5.5 L/yr |
Delhi Public School Ghaziabad Society
Podar International School
Eurokids
Kangaroo Kids Education