Capgemini Engineering Consultant Interview Questions and Answers

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.

• Examples of user-defined exceptions include INVALID_INPUT...read more

We are using the Agile framework in our project.

• Agile framework focuses on iterative development and collaboration.

• It involves breaking down the project into smaller tasks called sprints.

• Regular feedback and adaptation are key components of Agile.

• Examples of Agile methodologies include Scrum, Kanban, and XP.

Selenium advantages include cross-browser compatibility testing, support for multiple programming languages, and integration with various testing frameworks.

• Cross-browser compatibility testing: Selenium allows for testing on different browsers to ensure consistent functionality.

• Support for multiple programming languages: Selenium supports languages like Java, Python, and C#, making it versatile for different teams.

• Integration with various testing frameworks: Selenium can be i...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 and SQL statements.

• Collections can also be used to simplify ...read more

let is block scoped, var is function scoped, const is immutable

• let: block scoped, can be reassigned

• var: function scoped, can be reassigned

• const: block scoped, cannot be reassigned, but properties can be modified