Filter interviews by
I applied via Recruitment Consultant and was interviewed before Oct 2019. There were 4 interview rounds.
EXIST checks for the existence of a value in a subquery, while IN checks for the existence of a value in a list.
EXIST is used with a subquery, while IN is used with a list of values.
EXIST returns true if the subquery returns any rows, while IN returns true if the value is found in the list.
EXIST is more efficient for large datasets, while IN is more efficient for small datasets.
Example: SELECT * FROM table1 WHERE colum...
INDEX and PARTITION are database optimization techniques that improve query performance.
INDEX is a data structure that improves the speed of data retrieval operations on a database table.
PARTITION is a technique that divides a large table into smaller, more manageable parts.
INDEX and PARTITION can be used together to further improve query performance.
Examples of INDEX include B-tree, hash, and bitmap indexes.
Examples o...
Removing duplicates using analytical functions in SQL
Use the ROW_NUMBER() function to assign a unique number to each row
Partition the data by the columns that define duplicates
Order the data by the same columns
Filter out rows with a row number greater than 1
Oracle DB Architecture is a multi-layered design consisting of physical, logical, and memory structures.
Physical layer includes data files, redo logs, and control files
Logical layer includes tablespaces, schema objects, and segments
Memory structures include SGA and PGA
Oracle uses a client-server architecture with a listener process
Oracle also supports RAC (Real Application Clusters) for high availability and scalabilit
ANSI JOINS are standard SQL joins while Oracle JOINS are specific to Oracle database.
ANSI JOINS are supported by most relational databases while Oracle JOINS are specific to Oracle.
ANSI JOINS use keywords like INNER JOIN, LEFT JOIN, RIGHT JOIN, etc. while Oracle JOINS use symbols like (+) for outer joins.
ANSI JOINS are more portable and easier to migrate to other databases while Oracle JOINS are more efficient in Oracl...
Interview questions for Application Engineer role covering various topics.
Subset sum variant - finding a subset of numbers that add up to a given sum
Single loop missing number - finding a missing number in an array using a single loop
Difference between two dates - calculating the difference between two dates in Java
Core Java concepts - knowledge of basic Java concepts such as inheritance, polymorphism, etc.
SQL - knowle...
posted on 20 Jun 2024
React DOM is a package that provides methods for updating the DOM in response to React components.
React DOM is used to render React components to the DOM.
It provides methods like ReactDOM.render() to render components.
React DOM efficiently updates the DOM when the state of a component changes.
It handles events and updates the DOM accordingly.
React DOM is separate from React itself, allowing for flexibility in rendering
MVC in Rails is a software design pattern that separates the application into three main components: Model, View, and Controller.
Model: Represents the data and business logic of the application.
View: Represents the user interface of the application.
Controller: Acts as an intermediary between the Model and View, handling user input and updating the Model accordingly.
Example: In a Rails application, a User model would ha...
posted on 20 Jun 2024
Write code for micro service
Singleton is a design pattern that restricts the instantiation of a class to one object.
Singleton pattern ensures that a class has only one instance and provides a global point of access to it.
Commonly used in scenarios where only a single instance of a class is needed, such as database connections or configuration settings.
Implementation can involve a private constructor, a static method to access the instance, and a ...
I applied via Campus Placement and was interviewed before Mar 2023. There were 4 interview rounds.
The Online test is pretty easy, you can pass it with basic knowledge
I applied via Campus Placement and was interviewed in Jul 2023. There were 3 interview rounds.
1 DP Question, 1 Rest API, 10 Aptitude MCQs, 10 English MCQs
based on 1 interview
Interview experience
based on 2 reviews
Rating in categories
Senior Consultant
1.3k
salaries
| ₹6 L/yr - ₹21 L/yr |
Staff Consultant
1.1k
salaries
| ₹4.5 L/yr - ₹13.6 L/yr |
Associate Consultant
1k
salaries
| ₹3.3 L/yr - ₹10 L/yr |
Principal Consultant
702
salaries
| ₹8.8 L/yr - ₹29 L/yr |
Application Developer
481
salaries
| ₹6 L/yr - ₹23 L/yr |
Oracle
KPIT Technologies
24/7 Customer
Intellect Design Arena