i
GlobalLogic
Filter interviews by
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
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
I applied via Job Portal and was interviewed before Mar 2023. There were 3 interview rounds.
I applied via Naukri.com and was interviewed in Oct 2024. There were 2 interview rounds.
Group discussion related in company
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 26 Sep 2024
Coding test was around 2 hrs
Kubernetes is an open-source container orchestration platform for automating deployment, scaling, and management of containerized applications.
Kubernetes helps in automating the deployment, scaling, and management of containerized applications.
It allows for easy scaling of applications by adding or removing containers based on demand.
Kubernetes provides features like load balancing, self-healing, and rolling updates fo...
Docker container runtime is the engine that executes containers, managing their lifecycle and resources.
Docker container runtime is responsible for running and managing Docker containers.
It provides an isolated environment for applications to run without affecting the host system.
Popular container runtimes include Docker Engine, containerd, and CRI-O.
I applied via Approached by Company and was interviewed in Feb 2024. There were 2 interview rounds.
Asked simple tricky questions
2 question 1 easy 2 medium dsa
2 codes of dsa and mcq.
Associate Analyst
3.8k
salaries
| ₹1 L/yr - ₹4 L/yr |
Senior Software Engineer
3.3k
salaries
| ₹5.2 L/yr - ₹22 L/yr |
Analyst
3.1k
salaries
| ₹1 L/yr - ₹5.5 L/yr |
Software Engineer
2.9k
salaries
| ₹3 L/yr - ₹13 L/yr |
Associate Consultant
2.7k
salaries
| ₹9 L/yr - ₹32 L/yr |
TCS
Wipro
Infosys
HCLTech