Accelya Solutions India Limited Oracle SQL and PLSQL Developer Interview Questions and Answers

Record is a composite data type that stores related fields together.

• A record is a user-defined data type that contains a group of related data items.

• It is also known as a row or tuple in a table.

• Each field in a record can have a different data type.

• Records are commonly used in PL/SQL to hold query results or to pass data between procedures.

• Example: DECLARE emp_rec employees%ROWTYPE;

• This creates a record variable emp_re...read more

Procedures are used to perform an action, while functions return a value.

• Procedures do not return values, but can have output parameters

• Functions must return a value and cannot have output parameters

• Procedures can modify data, while functions cannot

• Functions can be used in SQL queries, while procedures cannot

Collections are data structures used to store multiple values of the same data type.

• Types of collections in Oracle are Associative arrays, Nested tables, and Varrays.

• Associative arrays are indexed by string values, Nested tables are like arrays with no fixed size, and Varrays are like arrays with a fixed size.

• Collections can be used to pass multiple values to a stored procedure or function.