Srijan Services Oracle Developer Interview Questions and Answers

Creating procedures with user defined exceptions and handling errors when updating at end of month.

• Create a procedure with a user defined exception using 'RAISE_APPLICATION_ERROR' and 'EXCEPTION' keywords.

• Use 'TO_CHAR(SYSDATE, 'DD')' to check if it is the end of the month before updating.

• Handle the error by raising an exception if the update is attempted at the end of the month.

• Example: CREATE OR REPLACE PROCEDURE upda...read more

A cursor is a database object used to manipulate data in a result set.

• A cursor is used to retrieve and manipulate data row by row.

• Types of cursors include implicit, explicit, and forward-only cursors.

• Implicit cursors are automatically created by Oracle when executing a SQL statement.

• Explicit cursors are created by the developer and allow for more control over the result set.

• Forward-only cursors only allow for iterating

I joined inm because of the company's reputation for innovation and growth in the tech industry.

• Attracted to company's reputation for innovation

• Excited about opportunities for growth in tech industry

• Impressed by company culture and values

Yes, items with different ship sets can be in different inventory

• Items with different ship sets can be stored in different locations or warehouses

• This allows for better organization and tracking of inventory

• For example, high-demand items can be stored in a warehouse closer to customers for faster shipping