Capgemini Engineering Consultant Interview Questions, Process, and Tips

There are three types of exceptions in PL/SQL: predefined exceptions, user-defined exceptions, and system-defined exceptions.

• Predefined exceptions are errors that are raised by the PL/SQL runtime system.

• User-defined exceptions are created by the developer to handle specific errors.

• System-defined exceptions are raised by the Oracle database system.

• Examples of predefined exceptions include NO_DATA_FOUND and TOO_MANY_ROWS...read more

PL/SQL supports three types of collections: associative arrays, nested tables, and VARRAYs.

• Associative arrays are also known as index-by tables and use a key-value pair to store data.

• Nested tables are similar to arrays and can store multiple values in a single column.

• VARRAYs are also similar to arrays but have a fixed size and can store a maximum number of elements.

• Collections can be used to pass data between PL/SQL an...read more