i
Expleo Group
Filter interviews by
Clear (1)
I applied via Naukri.com and was interviewed in Oct 2022. There were 2 interview rounds.
SQL is used to manage relational databases while PL/SQL is used to create procedures, functions, and triggers.
SQL is used to retrieve and manipulate data in a database.
PL/SQL is used to create stored procedures, functions, and triggers.
SQL is a declarative language while PL/SQL is a procedural language.
SQL is used to query data while PL/SQL is used to write code that can be executed.
SQL is used to create and modify tab...
Drop deletes the table and its structure while truncate deletes all the data in the table.
Drop is a DDL command while truncate is a DML command.
Drop cannot be rolled back while truncate can be rolled back using the undo tablespace.
Drop is slower than truncate as it deletes the table structure while truncate only deletes the data.
Drop can be used to delete views, sequences, and other database objects while truncate can ...
Top trending discussions
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
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 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...
I applied via Referral and was interviewed before Jun 2023. There was 1 interview round.
Oracle pl sql developer
I was interviewed in Nov 2024.
I applied via Naukri.com and was interviewed in Sep 2022. There were 3 interview rounds.
A temporary variable used to store data during program execution.
Temp variables are used to hold data temporarily during program execution.
They are typically used in loops or conditional statements.
Once the program execution is complete, the temp variable is no longer needed.
Example: int temp = 0; for(int i=0; i<10; i++) { temp += i; }
In this example, the temp variable is used to store the sum of the numbers 0-9.
based on 1 interview
Interview experience
Software Engineer
640
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Software Engineer
428
salaries
| ₹0 L/yr - ₹0 L/yr |
Softwaretest Engineer
268
salaries
| ₹0 L/yr - ₹0 L/yr |
Associate Software Engineer
187
salaries
| ₹0 L/yr - ₹0 L/yr |
QA Associate
138
salaries
| ₹0 L/yr - ₹0 L/yr |
TCS
Infosys
Wipro
HCLTech