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 Job Portal and was interviewed before Mar 2023. There were 3 interview rounds.
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 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 25 Jul 2023
I applied via Naukri.com and was interviewed in Jun 2023. There were 4 interview rounds.
3omins of coding knowledge testing
I appeared for an interview before May 2016.
posted on 13 Jan 2015
Single Ops tool is a software that helps businesses manage their operations from a single platform.
It streamlines processes and improves efficiency
It can include features like scheduling, inventory management, and invoicing
Examples include ServiceTitan, Jobber, and Housecall Pro
I am a dedicated and hardworking individual with a passion for learning and growth.
I have a background in marketing and have worked in the industry for 5 years.
I am currently pursuing a Master's degree in Business Administration to further my skills and knowledge.
I am a team player and enjoy collaborating with others to achieve common goals.
based on 1 interview
Interview experience
Associate Analyst
4k
salaries
| ₹1.2 L/yr - ₹5 L/yr |
Senior Software Engineer
3.4k
salaries
| ₹5.2 L/yr - ₹25.1 L/yr |
Analyst
3.2k
salaries
| ₹1.2 L/yr - ₹5.5 L/yr |
Software Engineer
3k
salaries
| ₹3.2 L/yr - ₹12.7 L/yr |
Associate Consultant
2.9k
salaries
| ₹9.2 L/yr - ₹33 L/yr |
Genpact
DXC Technology
Sutherland Global Services
Optum Global Solutions