Filter interviews by
I applied via Naukri.com and was interviewed in Sep 2022. There were 4 interview rounds.
Basic aptitude test we can crack easily
Technical interview scheduled by hr
Views and materialized views, collection data types.
Views are virtual tables that display data from one or more tables.
Materialized views are physical copies of the data in a view.
Collection data types include arrays, nested tables, and varrays.
Arrays are fixed-size, ordered collections of elements of the same data type.
Nested tables are dynamic, unordered collections of elements of the same data type.
Varrays are varia...
Top trending discussions
I applied via Recruitment Consulltant and was interviewed in Jan 2023. There were 3 interview rounds.
I applied via Naukri.com and was interviewed in May 2021. There were 3 interview rounds.
Procedures and functions are both PL/SQL program units, but they have some key differences.
Procedures do not return a value, while functions do.
Procedures can have OUT parameters to pass values back to the caller, while functions cannot.
Functions can be used in SQL statements, while procedures cannot.
Functions must return a value, while procedures do not necessarily have to.
Procedures are typically used for performing ...
Implicit cursors are automatically created by the Oracle server, while explicit cursors are explicitly declared by the programmer.
Implicit cursors are used for single-row queries, while explicit cursors are used for multi-row queries.
Implicit cursors are automatically opened, fetched, and closed by the Oracle server, while explicit cursors need to be manually opened, fetched, and closed by the programmer.
Implicit curso...
Soft parsing is reusing the existing execution plan while hard parsing is generating a new execution plan.
Soft parsing is faster as it avoids the overhead of generating a new execution plan.
Hard parsing is slower as it involves generating a new execution plan.
Soft parsing occurs when the SQL statement is already in the shared pool.
Hard parsing occurs when the SQL statement is not in the shared pool or needs a new execu...
RDBMS is a type of DBMS that stores data in a structured manner using tables with relationships.
DBMS is a software system that manages data stored in a computer's memory or disk storage.
RDBMS is a type of DBMS that uses a relational model to store data in tables with relationships.
RDBMS supports ACID properties (Atomicity, Consistency, Isolation, Durability) for data integrity.
Examples of RDBMS include Oracle, MySQL, S...
SQL query to find the nth highest salary
Use the ORDER BY clause to sort the salaries in descending order
Use the LIMIT clause to select the nth highest salary
SQL query to delete duplicate records from a table.
Use the DELETE statement with a subquery to identify and delete duplicate records.
The subquery should select the duplicate records based on the criteria for duplication.
Ensure to keep at least one copy of the duplicate records to avoid deleting all instances.
Delete is a DML operation that removes specific rows from a table, while truncate is a DDL operation that removes all rows from a table.
Delete is slower than truncate as it generates undo logs and triggers
Delete can be rolled back, while truncate cannot be rolled back
Delete operation maintains the integrity of the transaction log, while truncate operation does not
Delete operation fires delete triggers, while truncate o...
I applied via Recruitment Consulltant and was interviewed before Apr 2023. There was 1 interview round.
I appeared for an interview in Dec 2024, where I was asked the following questions.
A PL/SQL function to validate email addresses using regex patterns.
Define a function with a VARCHAR2 parameter for the email address.
Use regular expressions to match the email format.
Return TRUE if the email matches the pattern, otherwise FALSE.
Example regex: '^[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Z|a-z]{2,}$'.
Consider edge cases like missing '@' or domain parts.
A trigger can automate data insertion in response to changes in a specified table.
Triggers are database objects that automatically execute when a specified event occurs.
To create a trigger for INSERT, DELETE, or UPDATE, use the CREATE TRIGGER statement.
Example: CREATE TRIGGER trg_after_insert AFTER INSERT ON source_table FOR EACH ROW INSERT INTO target_table (column1) VALUES (:NEW.column1);
You can define the timing of ...
I applied via Naukri.com and was interviewed in Jun 2022. There were 2 interview rounds.
I applied via Campus Placement and was interviewed before Nov 2021. There were 3 interview rounds.
Numerical and logical aptitude test
There are 5 rounds on datastructure and algorithm
I applied via Naukri.com and was interviewed before Oct 2020. There were 3 interview rounds.
State management in React involves managing the state and props of components.
State is used to manage data that changes within a component
Props are used to pass data from a parent component to a child component
State can be updated using setState() method
Props are read-only and cannot be modified within a component
State and props are used together to create dynamic and interactive UIs
I applied via Campus Placement and was interviewed before Jun 2021. There were 3 interview rounds.
I was selected through campus drive at my college. The test was easy. I would suggest freshers to practice some mock tests online, grammer, intelligence, quant., etc.
based on 1 interview experience
Difficulty level
Duration
Design Engineer
6
salaries
| ₹1.8 L/yr - ₹3 L/yr |
Mechanical Engg. Design
3
salaries
| ₹1.8 L/yr - ₹5.3 L/yr |
Cognizant
Teleperformance
iEnergizer
Reliance Retail