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 update_data AS BEGIN IF TO_CHAR(SYSDATE, 'DD') = '31' THEN RAI...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 through the result set in one direction.

Constraints are rules that are applied to the data in a database to ensure its integrity and consistency.

• Constraints define the limits or conditions that must be met for data to be valid.

• They can be applied to individual columns or entire tables.

• Common types of constraints include primary key, foreign key, unique, and check constraints.

• Primary key constraints ensure that each row in a table is uniquely identified.

• Foreign key constraints enforce referential integrity between t...read more