Filter interviews by
Clear (1)
I applied via Walk-in and was interviewed in Feb 2023. There were 4 interview rounds.
25 Aptitude MCQ and 25 post based MCQ
Top trending discussions
I applied via Naukri.com and was interviewed in Oct 2024. There was 1 interview round.
Developed a PL/SQL project for managing inventory and sales data in a retail store.
Designed database tables to store product information, sales transactions, and customer details.
Implemented PL/SQL procedures and functions for adding, updating, and querying data.
Created triggers to enforce business rules and maintain data integrity.
Developed reports using PL/SQL queries to analyze sales performance and inventory levels
I work on performance optimization by analyzing query execution plans, indexing, and code refactoring.
Analyzing query execution plans to identify bottlenecks
Creating appropriate indexes to improve query performance
Refactoring code to optimize resource usage
Using tools like Explain Plan and SQL Tuning Advisor
I applied via Approached by Company and was interviewed in Sep 2023. There were 3 interview rounds.
Window functions in SQL are used to perform calculations across a set of table rows related to the current row.
Window functions are used to calculate values based on a set of rows related to the current row.
They allow you to perform calculations without grouping the rows into a single output row.
Examples of window functions include ROW_NUMBER(), RANK(), and LAG().
Packages in PL/SQL are used to group related procedures, functions, variables, and other PL/SQL constructs together for better organization and security.
Packages help in modularizing code for easier maintenance and debugging
They provide encapsulation and hide implementation details
Packages can contain multiple procedures, functions, variables, cursors, and exceptions
They improve performance by reducing network traffic
E...
Create a function based on shared logic
Identify common logic that can be reused in multiple functions
Create a separate function to encapsulate the shared logic
Call the shared function from other functions where the logic is needed
I applied via Referral and was interviewed before Jun 2023. There was 1 interview round.
Oracle pl sql developer
Factorial of a number is the product of all positive integers up to that number.
To calculate factorial of a number, multiply all positive integers up to that number.
Factorial of 0 is 1.
Example: Factorial of 5 is 5*4*3*2*1 = 120.
Modelling of schema involves designing the structure of a database to organize and represent data.
Identify entities and their relationships
Define attributes for each entity
Establish primary and foreign keys
Normalize the schema to reduce redundancy
Consider performance and scalability
I applied via Company Website and was interviewed in Sep 2024. There was 1 interview round.
Packages and types are two important components in PL/SQL used for organizing and defining reusable code and data structures.
Packages are containers for related procedures, functions, variables, and other PL/SQL constructs.
Types are user-defined data structures that can be used to define new data types in PL/SQL.
Packages can contain types as well as other PL/SQL constructs, providing a way to organize and encapsulate r...
I applied via Approached by Company and was interviewed in Jun 2022. There was 1 interview round.
Types of cursors include implicit, explicit, and parameterized cursors.
Implicit cursors are automatically created by Oracle when a SQL statement is executed.
Explicit cursors are defined by the programmer using the DECLARE, OPEN, FETCH, and CLOSE statements.
Parameterized cursors allow for dynamic SQL statements to be executed with different parameters.
based on 1 interview
Interview experience
based on 3 reviews
Rating in categories
Software Developer
135
salaries
| ₹0 L/yr - ₹0 L/yr |
Operations Executive
87
salaries
| ₹0 L/yr - ₹0 L/yr |
Executive Software Developer
39
salaries
| ₹0 L/yr - ₹0 L/yr |
Application Support Engineer
29
salaries
| ₹0 L/yr - ₹0 L/yr |
Client Account Manager
28
salaries
| ₹0 L/yr - ₹0 L/yr |
TCS
Infosys
Wipro
HCLTech