JLL Technologies Data Engineer 1 Interview Questions and Answers

A dictionary is a collection of key-value pairs, while a list is a collection of ordered elements.

• A dictionary is accessed by keys, while a list is accessed by index.

• Dictionaries are unordered, while lists are ordered.

• Example: dict = {'name': 'John', 'age': 30}, list = ['apple', 'banana', 'cherry']

I have experience writing SQL queries for data manipulation and analysis.

• Use SELECT statement to retrieve data from a database

• Use WHERE clause to filter results based on specific conditions

• Use JOIN clause to combine data from multiple tables

Int & Float data types are used to represent whole numbers and decimal numbers respectively in programming.

• Int data type is used for whole numbers without any decimal points, such as 5, -10, 1000

• Float data type is used for numbers with decimal points, such as 3.14, -0.5, 10.75

• Int data type is typically used for counting or indexing, while Float data type is used for calculations involving fractions or decimals

Left join includes all records from the left table and matching records from the right table. Right join includes all records from the right table and matching records from the left table. Full join includes all records when there is a match in either left or right table.

• Left join: includes all records from the left table and matching records from the right table

• Right join: includes all records from the right table and...read more