Capgemini Engineer Trainee Interview Questions and Answers

Python is a high-level, interpreted programming language known for its simplicity and ease of use.

• Python is dynamically typed and garbage-collected.

• It supports multiple programming paradigms, including procedural, object-oriented, and functional programming.

• Python has a large standard library and a vast collection of third-party libraries.

• It is widely used in scientific computing, data analysis, web development, and ar...read more

Libraries and modules are pre-written code that can be imported and used in Python programs.

• Libraries are collections of modules that provide additional functionality to Python programs.

• Modules are individual Python files that contain reusable code.

• Libraries and modules can be imported using the 'import' statement.

• Examples of libraries include NumPy, Pandas, and Matplotlib.

• Examples of modules include math, random, and

Lists are mutable while tuples are immutable in Python.

• Lists use square brackets [] while tuples use parentheses ().

• Elements in a list can be added, removed, or modified while tuples cannot be modified.

• Lists are used for collections of data that need to be changed while tuples are used for collections of data that should not be changed.

• Lists are slower than tuples in terms of performance.

• Example: my_list = [1, 2, 3] an

Primary key uniquely identifies a record while foreign key establishes a link between two tables.

• Primary key is a column or set of columns that uniquely identifies each record in a table.

• Foreign key is a column or set of columns in one table that refers to the primary key in another table.

• Primary key cannot have null values while foreign key can have null values.

• Primary key is used to create relationships between table...read more

Joins in SQL are used to combine data from two or more tables based on a related column.

• Joins are used to retrieve data from multiple tables in a single query.

• There are different types of joins such as inner join, left join, right join, and full outer join.

• Inner join returns only the matching rows from both tables.

• Left join returns all the rows from the left table and matching rows from the right table.

• Right join retur...read more