i
ITC Infotech
Filter interviews by
I applied via Naukri.com and was interviewed in Sep 2024. There was 1 interview round.
Optimizing stored procedures involves using proper indexing, reducing unnecessary loops, and minimizing database calls.
Use proper indexing on columns used in WHERE clauses to improve query performance
Avoid using cursors and loops whenever possible, as they can be inefficient
Minimize the number of database calls by combining multiple queries into a single query or using temporary tables
Consider using bulk processing tec...
Optimizing SQL queries involves using indexes, minimizing data retrieval, avoiding unnecessary joins, and optimizing query structure.
Use indexes on columns frequently used in WHERE clauses
Minimize data retrieval by selecting only necessary columns
Avoid unnecessary joins by using EXISTS or IN clauses instead
Optimize query structure by using appropriate join types and conditions
Returning clause is used to return a value from a function or procedure in PL/SQL.
Used to return a single value from a function or procedure
Can be used to return multiple values using OUT parameters
Helps in passing values back to the calling program
Triggers can lead to performance issues, complexity, and potential for unintended consequences.
Triggers can make code harder to debug and maintain
They can lead to cascading effects if not carefully implemented
Performance can be impacted if triggers are not optimized
Triggers can introduce dependencies between different parts of the codebase
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
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 Monster
Use SQL query with ORDER BY clause to get result based on highest salary
Use SELECT statement to retrieve data from the table
Use ORDER BY clause with DESC keyword to sort salaries in descending order
Use LIMIT or FETCH FIRST clause to limit the result to only one row
Bulk collect is used to fetch multiple rows into collections at once, while bulk binding is used to bind collections to SQL statements for improved performance.
Bulk collect fetches multiple rows into collections in a single operation, reducing context switches and improving performance.
Bulk binding binds collections to SQL statements, reducing the number of context switches between the PL/SQL engine and SQL engine.
Bulk...
posted on 30 Aug 2024
I applied via Job Portal
PL/SQL is a procedural extension of SQL used for writing stored procedures, functions, triggers, and packages in Oracle databases.
PL/SQL stands for Procedural Language/Structured Query Language
It is used to write procedural code like stored procedures, functions, triggers, and packages in Oracle databases
SQL (Structured Query Language) is a standard language for accessing and manipulating databases
SQL is used to query,...
Questions on plsql and sql in general
Delete removes rows from a table, drop removes the entire table, and truncate removes all rows from a table.
Delete is a DML operation and can be rolled back, but it is slower than truncate.
Drop is a DDL operation and cannot be rolled back. It removes the table and all associated objects.
Truncate is a DDL operation and cannot be rolled back. It removes all rows from the table but keeps the table structure.
Delete and tru...
Table stores data in a structured format while view is a virtual table created from a query.
Table is a physical object while view is a logical object.
Table can be modified while view cannot be modified directly.
Table can have indexes while view cannot have indexes.
Table can have constraints while view cannot have constraints.
View can be used to simplify complex queries by joining multiple tables.
View can be used to res...
I have used both implicit and explicit cursors in PL/SQL development.
Implicit cursors are used for single-row queries while explicit cursors are used for multi-row queries.
I have used explicit cursors with parameters to make the query more dynamic.
I have also used cursor variables to pass cursors as parameters to procedures and functions.
Examples of cursor types I have used include FOR LOOP, FETCH, and UPDATE cursors.
Primary key uniquely identifies a record in a table, while unique key ensures uniqueness of a column or set of columns.
Primary key is a column or set of columns that uniquely identifies each record in a table
Unique key ensures that a column or set of columns have unique values
Primary key cannot have null values, while unique key can have null values
A table can have only one primary key, but multiple unique keys
JOINS DIFFERENCE BETWEEEN (LEFT,RIGHT,INNER,FULL)
CREATE OR REPLACE PROCEDURE PP(A NUMBER) IS
BEGIN
DBMS_OUTPUT.PUT_LINE(A);
END;
/
I applied via Company Website and was interviewed in Jul 2024. There were 3 interview rounds.
Easy exam sample available on youtube
Step functions are a type of serverless function that allow you to create workflows by chaining multiple functions together.
Step functions are used to coordinate multiple AWS services into serverless workflows.
They allow you to define a series of steps in a workflow, with each step being a separate function.
You can use step functions to handle complex business logic, long-running processes, and error handling.
Step func...
Scaling lambdas involves optimizing memory usage, increasing concurrency, and managing dependencies.
Optimize memory usage by reducing unnecessary variables and objects
Increase concurrency by using asynchronous programming and parallel processing
Manage dependencies by breaking down functions into smaller, more modular components
Consider using AWS Lambda Provisioned Concurrency for consistent performance
I addressed the issue directly and professionally, seeking to understand their perspective and find common ground.
Approached the colleague privately to discuss the issue
Listened actively to their concerns and perspective
Sought to find common ground and reach a resolution
Maintained professionalism and respect throughout the conversation
posted on 16 Oct 2024
Writing code in eggplant for Senior Developer interview
Use 'click' to simulate a mouse click on an element
Use 'typeText' to enter text into a field
Use 'verify' to check if an element is present on the screen
I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.
CSS Box-model defines how elements are rendered in a webpage, including padding, border, and margin.
Box-model consists of content, padding, border, and margin
Content area is where text or images are displayed
Padding is the space between content and border
Border is the line around the content and padding
Margin is the space outside the border
Flexbox is for one-dimensional layouts, grid is for two-dimensional layouts.
Flexbox is best for arranging items in a single row or column.
Grid is best for creating complex layouts with rows and columns.
Flexbox is more suitable for smaller scale layouts, while grid is better for larger scale layouts.
Flexbox is more flexible in terms of item order and sizing, while grid provides more control over the overall layout.
Both
based on 3 reviews
Rating in categories
Associate Information Technology Consultant
5.2k
salaries
| ₹4.1 L/yr - ₹15 L/yr |
Lead Consultant
4.4k
salaries
| ₹9 L/yr - ₹35.4 L/yr |
Associate Consultant
850
salaries
| ₹2.5 L/yr - ₹16.5 L/yr |
Software Engineer
497
salaries
| ₹4 L/yr - ₹14 L/yr |
Senior Software Engineer
366
salaries
| ₹6.2 L/yr - ₹27 L/yr |
TCS
Wipro
HCLTech
Tech Mahindra