Filter interviews by
CTE stands for Common Table Expression in SQL, used to create temporary result sets that can be referenced within a SELECT, INSERT, UPDATE, or DELETE statement.
CTEs improve readability and maintainability of complex queries
CTEs can be recursive, allowing for hierarchical data querying
CTEs are defined using the WITH keyword followed by the CTE name and query
Reverse a linked list by changing the next pointers of each node to point to the previous node.
Start with three pointers: current, prev, and next.
Iterate through the linked list, updating the next pointers to point to the previous node.
Update prev, current, and next pointers in each iteration until the end of the list is reached.
Runtime polymorphism is the ability of a subclass to override a method from its superclass during runtime.
Runtime polymorphism is achieved through method overriding in object-oriented programming.
It allows a subclass to provide a specific implementation of a method that is already defined in its superclass.
The actual method called is determined by the type of object at runtime.
Example: Animal class has a method 'm...
Abstraction in OOP is the concept of hiding complex implementation details and showing only the necessary features to the outside world.
Abstraction allows us to focus on what an object does rather than how it does it
It helps in reducing complexity and improving maintainability of code
Example: A car is an abstraction of various components like engine, wheels, etc. Users interact with the car without needing to know...
Arrow functions are a concise way to write functions in JavaScript.
Arrow functions have a shorter syntax compared to regular functions.
They do not have their own 'this' keyword, and instead inherit 'this' from the parent scope.
Arrow functions are best suited for non-method functions, and cannot be used as constructors.
Example: const add = (a, b) => a + b;
B Trees are used for indexing in databases and file systems.
Used for efficient searching, insertion, and deletion operations in databases.
Helps in maintaining sorted data for quick retrieval.
Commonly used in file systems to store large amounts of data efficiently.
Each node in a B Tree can have multiple children, reducing the height of the tree.
Arrow functions are a concise way to write functions in JavaScript.
Arrow functions have a shorter syntax compared to regular functions.
They do not have their own 'this' keyword, and instead inherit 'this' from the parent scope.
Arrow functions are best suited for non-method functions, and cannot be used as constructors.
Example: const add = (a, b) => a + b;
Runtime polymorphism is the ability of a subclass to override a method from its superclass during runtime.
Runtime polymorphism is achieved through method overriding in object-oriented programming.
It allows a subclass to provide a specific implementation of a method that is already defined in its superclass.
The actual method called is determined by the type of object at runtime.
Example: Animal class has a method 'makeSo...
Abstraction in OOP is the concept of hiding complex implementation details and showing only the necessary features to the outside world.
Abstraction allows us to focus on what an object does rather than how it does it
It helps in reducing complexity and improving maintainability of code
Example: A car is an abstraction of various components like engine, wheels, etc. Users interact with the car without needing to know the ...
DSA questions Reverse the linkedlist
I applied via Campus Placement and was interviewed in Mar 2023. There were 5 interview rounds.
Tricky questions from js, sql, c#
B Trees are used for indexing in databases and file systems.
Used for efficient searching, insertion, and deletion operations in databases.
Helps in maintaining sorted data for quick retrieval.
Commonly used in file systems to store large amounts of data efficiently.
Each node in a B Tree can have multiple children, reducing the height of the tree.
CTE stands for Common Table Expression in SQL, used to create temporary result sets that can be referenced within a SELECT, INSERT, UPDATE, or DELETE statement.
CTEs improve readability and maintainability of complex queries
CTEs can be recursive, allowing for hierarchical data querying
CTEs are defined using the WITH keyword followed by the CTE name and query
Reverse a linked list by changing the next pointers of each node to point to the previous node.
Start with three pointers: current, prev, and next.
Iterate through the linked list, updating the next pointers to point to the previous node.
Update prev, current, and next pointers in each iteration until the end of the list is reached.
I applied via Campus Placement and was interviewed in Sep 2023. There was 1 interview round.
Only DSa and aptitude was asked
Top trending discussions
It was straightforward
The candidate should discuss their previous experience, how they handle their role and expectations, their work schedule, and provide an explanation about their previous team.
Discuss previous experience in software engineering roles
Explain how you handled your role and met expectations in previous positions
Describe your typical work schedule and any flexibility you have
Provide an overview of your previous team, their s...
List is mutable, tuple is immutable in Python.
List can be modified, tuple cannot be modified
List uses square brackets [], tuple uses parentheses ()
List is used for collections of items that may change, tuple is used for fixed collections
I appeared for an interview before May 2024, where I was asked the following questions.
posted on 5 Jul 2023
posted on 20 Apr 2022
I applied via Company Website
posted on 8 Nov 2022
I applied via Recruitment Consulltant and was interviewed in May 2022. There were 2 interview rounds.
The optimum diameter of a pump depends on various factors such as flow rate, head, viscosity, and efficiency.
The diameter should be selected based on the required flow rate and head of the system.
Higher viscosity fluids require larger diameter pumps to reduce frictional losses.
Efficiency of the pump increases with larger diameter impellers.
The diameter should also be selected based on the available space and cost const...
Stream balance inside distillation column is crucial for efficient separation of components.
Stream balance refers to the equal distribution of feed and product streams across the column.
Imbalance can lead to poor separation efficiency, flooding, or tray damage.
Factors affecting stream balance include tray design, liquid and vapor flow rates, and column diameter.
Techniques such as tray hydraulics and computational fluid...
Designing a distillation column for binary mixtures involves determining the number of trays, feed location, and reflux ratio.
Determine the boiling points of the components
Calculate the minimum reflux ratio
Choose the number of trays based on the desired separation
Determine the feed location based on the composition of the feed
Design the reboiler and condenser
Consider the pressure drop across the column
I appeared for an interview in Jul 2022.
based on 3 interview experiences
Difficulty level
Duration
Production Officer
36
salaries
| ₹2.1 L/yr - ₹4.6 L/yr |
Executive Production
34
salaries
| ₹3 L/yr - ₹5.6 L/yr |
Software Engineer
15
salaries
| ₹7.4 L/yr - ₹19 L/yr |
Assistant Manager - Production
13
salaries
| ₹4.7 L/yr - ₹7.2 L/yr |
Associate Software Engineer
9
salaries
| ₹6.5 L/yr - ₹9 L/yr |
Air Liquide
Cohizon Life Sciences Limited
Anupam Rasayan India
Indo Amines