i
Harjai Computers
Filter interviews by
I wrote a procedure to calculate the average salary of employees in a department.
Used cursor to fetch employee data
Calculated total salary using loop
Divided total salary by number of employees
Handled exceptions for zero employees in department
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
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.
Execution plan is a roadmap created by the database optimizer to determine the most efficient way to execute a query.
Execution plan shows the steps the database will take to execute a query.
Query optimization involves finding the most efficient way to execute a query.
Optimization techniques include index usage, join methods, and access paths.
Understanding execution plans helps in tuning queries for better performance.
I applied via Approached by Company and was interviewed in Feb 2024. There was 1 interview round.
Procedure is used to perform an action, while function returns a value.
Procedure does not return a value, while function does
Functions can be used in SQL queries, procedures cannot
Functions can be called from SQL statements, procedures cannot
In performance tuning, init refers to the initialization parameter file used by Oracle Database to configure various settings.
init is a text-based configuration file that contains parameters to optimize the performance of Oracle Database.
It is used to set parameters such as memory allocation, parallel processing, and resource utilization.
By tuning the init file, developers can improve the overall performance of the dat...
Named and unnamed exceptions in PL/SQL with examples
Named exceptions are user-defined exceptions with specific names like 'custom_exception'
Unnamed exceptions are predefined exceptions like 'NO_DATA_FOUND' or 'TOO_MANY_ROWS'
Named exceptions can be raised using RAISE statement with the exception name
Unnamed exceptions are raised automatically by the system in case of errors
Example of named exception: DECLARE custom_exce...
SQL is a query language used to interact with databases, while PL/SQL is a procedural language extension for SQL.
SQL is used for querying and manipulating data in databases.
PL/SQL is used for writing procedural code like loops, conditions, and functions.
SQL statements are executed one at a time, while PL/SQL blocks can contain multiple statements.
PL/SQL can be used to create stored procedures, functions, and triggers i...
SQL is a structured query language used to communicate with databases. SQL extensions add additional functionality to the language.
SQL is a standard language used to interact with databases
SQL extensions like PL/SQL add procedural programming capabilities to SQL
PL/SQL is an extension of SQL used in Oracle databases
I applied via Approached by Company and was interviewed in Mar 2022. There were 3 interview rounds.
A cursor is a database object used to retrieve data from a result set one row at a time.
Types of cursors: Implicit, Explicit, Ref, and Dynamic
Implicit cursor is used for single row queries
Explicit cursor is used for multi-row queries
Ref cursor is used to point to a cursor variable
Dynamic cursor is used to execute dynamic SQL statements
Explanation of triggers and their types in PL/SQL
Triggers are database objects that are automatically executed in response to certain events
Types of triggers include DML, DDL, and system triggers
Syntax for creating a trigger: CREATE [OR REPLACE] TRIGGER trigger_name {BEFORE|AFTER} {INSERT|UPDATE|DELETE} ON table_name [FOR EACH ROW] [WHEN condition] BEGIN ... END;
SQL optimization, normalization, and pragma usage are important concepts in PL/SQL development.
SQL optimization involves improving the performance of SQL queries by analyzing and modifying the query structure, indexes, and data access patterns.
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
Pragma is a compiler directive that provides additional information ...
I applied via LinkedIn and was interviewed in May 2022. There were 2 interview rounds.
I have a strong ability to learn new software quickly.
I am a self-motivated learner and enjoy exploring new technologies.
I am comfortable with online tutorials, documentation, and experimenting with new software.
I have experience learning new software such as Oracle SQL Developer, Toad, and PL/SQL Developer.
I am able to adapt to new software quickly and efficiently.
based on 2 reviews
Rating in categories
Softwaretest Engineer
104
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Tester
93
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Developer
50
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Software Engineer
50
salaries
| ₹0 L/yr - ₹0 L/yr |
HR Executive
42
salaries
| ₹0 L/yr - ₹0 L/yr |
TCS
Wipro
Infosys
HCLTech