Filter interviews by
I applied via Campus Placement and was interviewed in Apr 2018. There were 5 interview rounds.
A trigger is a PL/SQL block that is automatically executed in response to a specific event. A procedure is a named PL/SQL block that performs a specific task. A cursor is a database object used to retrieve data from a result set.
A trigger is used to automatically execute a set of SQL statements when a specific event occurs, such as inserting, updating, or deleting data from a table.
A procedure is a reusable block of co...
To recover data in Oracle, you can use the flashback feature or export tables using the Data Pump utility.
To recover data using flashback, you can use the FLASHBACK TABLE statement to restore a table to a previous state.
To export tables, you can use the Data Pump utility with the EXPDP command to export tables to a file.
You can also use the SQL Developer tool to export tables as SQL insert statements or CSV files.
Joins are used to combine rows from two or more tables based on related columns. There are different types of joins.
Types of joins: inner join, left join, right join, full outer join, cross join
Joins are used to retrieve data from multiple tables based on a related column
Natural join is a type of join that automatically matches columns with the same name in both tables
Example: SELECT * FROM employees NATURAL JOIN depar
Foreign key, primary key, and unique key are all constraints used in database tables to enforce data integrity.
Primary key is a column or a set of columns that uniquely identifies each row in a table.
Foreign key is a column or a set of columns in one table that refers to the primary key in another table.
Unique key ensures that the values in a column or a set of columns are unique across all the rows in a table.
Delete, drop, and truncate are SQL commands used to remove data from a table, but they differ in their functionality.
DELETE is used to remove specific rows from a table based on a condition.
DROP is used to remove an entire table from the database.
TRUNCATE is used to remove all rows from a table, but keeps the structure intact.
DELETE and TRUNCATE can be rolled back, but DROP cannot.
DELETE triggers the delete trigger, wh
The query to display the top 5 salaries in PL/SQL.
Use the SELECT statement to retrieve the salaries from the table.
Order the salaries in descending order using the ORDER BY clause.
Limit the result to the top 5 rows using the FETCH FIRST clause.
To copy the structure of a table without copying the data, you can use the CREATE TABLE AS SELECT statement.
Use the CREATE TABLE AS SELECT statement to create a new table with the same structure as the original table.
Specify the columns and their data types in the SELECT statement, but exclude the actual data from the original table.
Example: CREATE TABLE new_table AS SELECT * FROM original_table WHERE 1=0;
A view is a virtual table created from one or more tables. It can be used to simplify complex queries and provide a customized view of data.
A view is a stored query that can be treated as a table
Types of views include simple views, complex views, and materialized views
A complex view is a view that involves multiple tables or subqueries
Complex views can be used to combine data from different tables or apply complex calc...
Indexing is a technique used in databases to improve the performance of queries by creating a data structure that allows for faster data retrieval.
Indexing creates a separate data structure that contains a subset of the data in the database, organized in a way that allows for efficient searching and retrieval.
Indexes are created on one or more columns of a table and can be used to quickly locate data based on the value...
Procedures and functions are both PL/SQL program units, but they have some 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 queries, while procedures cannot.
Functions must return a value, while procedures do not have to.
Functions can be called directly in PL/SQL code, while procedure
The query displays employee records with the same salary.
Use the GROUP BY clause to group the records by salary.
Use the HAVING clause to filter the groups with more than one employee.
Select the necessary columns to display the employee records.
To eliminate duplicates without using the distinct command in PL/SQL, we can use the GROUP BY clause.
Use the GROUP BY clause to group the data by the columns that you want to eliminate duplicates from.
Select the columns you want to display in the result set.
Aggregate functions like COUNT, SUM, AVG, etc. can be used to perform calculations on the grouped data.
The GROUP BY clause ensures that only unique combinations of
The PLSQL code snippet to replace only the third character with * in a given string.
Use the SUBSTR function to extract the first two characters of the string.
Concatenate the extracted characters with '*' and the remaining characters starting from the fourth position using the SUBSTR function.
Assign the modified string back to the original variable.
I applied via Naukri.com and was interviewed in Apr 2024. There was 1 interview round.
Using PL/SQL to create a procedure with a ref cursor to find the average and factorial of a given number.
Create a procedure that takes in a number as input and returns the average of that number using a ref cursor.
Use the EXISTS function to check if a factorial exists for a given number.
Write a block of code to calculate the factorial of a number using a loop.
Use a case statement to handle duplicate records in PL/SQL.
Use a case statement to check for duplicate records based on specific criteria.
Implement logic within the case statement to handle the duplicates appropriately.
Consider using a unique identifier or combination of columns to identify duplicates.
I applied via Referral and was interviewed in Oct 2024. There were 3 interview rounds.
Was asked to create a UI component keeping in mind scalability and reuseability.
General discussion about resume and projects, and then some basic JS coding questions like implement throttling and memoization.
I applied via Naukri.com and was interviewed in Jul 2024. There was 1 interview round.
OOPs concept in PHP refers to Object-Oriented Programming principles such as encapsulation, inheritance, polymorphism, and abstraction.
Encapsulation: Bundling data and methods that operate on the data into a single unit (class)
Inheritance: Allows a class to inherit properties and methods from another class
Polymorphism: Ability to present the same interface for different data types
Abstraction: Hiding the implementation
ORM in Laravel is Eloquent, a powerful and expressive ORM that allows you to interact with your database using PHP syntax.
Eloquent is the ORM used in Laravel to interact with the database
It allows you to define relationships between database tables using Eloquent models
Eloquent provides methods for querying, inserting, updating, and deleting records in the database
Example: defining a User model in Laravel and using it
SQL query to find the third highest salary from employees table.
Use the ORDER BY clause to sort salaries in descending order.
Use the LIMIT clause to retrieve the third highest salary.
Consider handling cases where there may be ties for the third highest salary.
posted on 30 Nov 2024
I applied via campus placement at Kalinga Institute of Industrial Technology, Khurda and was interviewed in May 2024. There were 2 interview rounds.
Coding round was there. Two coding questions were asked to solve in 1 hour. The difficulty was easy to medium.Leetcode questions of arrays and strings.
I applied via Campus Placement and was interviewed in Jun 2024. There were 2 interview rounds.
Technical MCQ questions on core computer science subjects were asked.
I applied via Recruitment Consulltant and was interviewed in May 2024. There was 1 interview round.
Easy to medium questions
A software for managing inventory in a retail store
Create a user-friendly interface for adding, updating, and deleting products
Include features for tracking sales, restocking inventory, and generating reports
Implement barcode scanning functionality for quick product lookup
I applied via Approached by Company and was interviewed in May 2024. There was 1 interview round.
Flatten and remove duplicates from an array of strings
Use the flat() method to flatten the array
Use the Set object to remove duplicates
Convert the Set back to an array using the spread operator
Some of the top questions asked at the Agile Softech Plsql Developer interview -
Softwaretest Engineer
7
salaries
| ₹2.4 L/yr - ₹3 L/yr |
Software Developer
6
salaries
| ₹0.9 L/yr - ₹4 L/yr |
Software Engineer
4
salaries
| ₹1.2 L/yr - ₹20 L/yr |
Java Developer
4
salaries
| ₹1.1 L/yr - ₹4 L/yr |
Software Engineer Trainee
4
salaries
| ₹0.9 L/yr - ₹8.7 L/yr |
Teleperformance
FIS
Nagarro
Optum