Filter interviews by
Be the first one to contribute and help others!
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.
The internet is a global network of interconnected computers that communicate using a standardized protocol called TCP/IP.
The internet is made up of millions of servers, computers, and other devices connected through physical cables or wireless signals.
Data is transmitted across the internet in small packets using the TCP/IP protocol.
Websites are hosted on servers and accessed by users through web browsers like Chrome ...
To install an operating system, you need to boot from the installation media and follow the on-screen instructions.
Insert the installation media (such as a USB drive or DVD) into the computer
Restart the computer and access the boot menu to select the installation media as the boot device
Follow the on-screen instructions to choose the language, partition the hard drive, and install the OS
Once the installation is complet...
To install an app, you can download it from an app store or website, then follow the installation instructions.
Download the app from an app store (e.g. Google Play Store, Apple App Store) or website
Follow the on-screen instructions to install the app
Grant necessary permissions if prompted during installation process
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.
posted on 14 Feb 2024
I applied via Naukri.com and was interviewed in Jan 2024. There was 1 interview round.
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
based on 29 reviews
Rating in categories
Business Development Manager
4
salaries
| ₹4.2 L/yr - ₹4.5 L/yr |
Project Coordinator
4
salaries
| ₹1.1 L/yr - ₹3 L/yr |
Computer Operator
4
salaries
| ₹0.6 L/yr - ₹4 L/yr |
NIIT
Kendriya Vidyalaya Sangathan
Aptech
Ryan International School