Birlasoft Senior Consultant Interview Questions and Answers

Cursors declared in procedures are local to the procedure, while those declared in package specifications can be accessed by multiple procedures within the package.

• Cursors declared in procedures are only visible within that specific procedure.

• Cursors declared in package specifications can be shared and accessed by multiple procedures within the package.

• Package-level cursors can be useful for reusing the same query logic across multiple procedures.

Triggers are automatically executed in response to certain events, while stored procedures are pre-written scripts that can be manually executed.

• Triggers are event-driven and automatically executed when a specified event occurs in the database.

• Stored procedures are pre-written scripts that can be manually executed by users or applications.

• Triggers can be used to enforce data integrity rules or audit changes in the database.

• Stored procedures can be used to encapsulate complex ...read more

A trigger in a database management system is a set of instructions that automatically execute in response to certain events on a table or view.

• Triggers are used to enforce business rules, perform data validation, and maintain data integrity.

• They can be set to execute before or after INSERT, UPDATE, or DELETE operations on a table.

• Examples of triggers include auditing changes to a table, updating related tables when a record is modified, or enforcing referential integrity.

ROWID is a unique identifier for a row in a table, while ROWNUM is a pseudo-column that assigns a unique number to each row retrieved from a query.

• ROWID is a physical address of a row in a table, while ROWNUM is a virtual column generated by a query result set.

• ROWID remains constant for a row even if the row is updated, while ROWNUM changes based on the order of rows retrieved from a query.

• ROWID is unique within a table, while ROWNUM is unique within a result set.

SQL join queries are used to combine rows from two or more tables based on a related column between them.

• Different types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• INNER JOIN returns rows when there is at least one match in both tables.

• LEFT JOIN returns all rows from the left table and the matched rows from the right table.

• RIGHT JOIN returns all rows from the right table and the matched rows from the left table.

• FULL JOIN returns rows when there is a mat...read more

A PL/SQL cursor is a pointer used to fetch and manipulate data in a database table.

• PL/SQL cursor is used to retrieve data row by row from a result set.

• It allows for processing individual rows returned by a query.

• Cursors are typically used in loops to iterate through query results.

• Example: DECLARE cursor_name CURSOR FOR SELECT * FROM table_name;

I have 5 years of project experience in implementing and optimizing SCM modules.

• Implemented end-to-end supply chain solutions for a global manufacturing company

• Optimized inventory management processes to reduce costs and improve efficiency

• Led cross-functional teams in implementing new SCM software systems

• Developed and implemented KPIs to measure supply chain performance