JLL Technologies Interview Questions, Process, and Tips

Nklrgn ij iojt hohoihcnjoh uth hd afbc heigf oj

Q1. Ffefjewk f fhe fui fy efge fuef9 euf fj
Add your answer
Q2. Fejfb f hue fui fui e ifgif beiu
Add your answer

Q1. Difference between a dictionary and a list
Ans. 
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']
Answered by AI
Add your answer
Q2. Write SQL quiries
Ans. 
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
Answered by AI
Add your answer
Q3. Int & Float data types and their uses
Ans. 
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
Answered by AI
Add your answer
Q4. Outputs of left join, right join & full join
Ans. 
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
Answered by AI
Add your answer

Q1. Explain your projects
Ans. 
I have worked on various projects including developing mobile applications, creating websites, and implementing data analysis solutions.
• Developed a mobile application for tracking daily water intake

• Created a website for a local non-profit organization to showcase their work

• Implemented a data analysis solution to optimize inventory management for a retail company
Answered by AI
Add your answer
Q2. How can we delete duplicate record from table in SQL table
Ans. 
Duplicate records can be deleted from a SQL table by using the DELETE statement with a subquery to identify and remove the duplicates.
• Use a subquery to identify the duplicate records based on specific criteria

• Use the DELETE statement with the subquery to remove the duplicate records

• Ensure to backup the data before deleting any records
Answered by AI
Add your answer
Q3. Code for python fibonacci series
Ans. 
Python code to generate Fibonacci series
• Use a loop to iterate and calculate the next Fibonacci number

• Start with 0 and 1 as the first two numbers

• Add the previous two numbers to get the next number
Answered by AI
Add your answer

Q1. Are you ready to move to the location?
Ans. 
Yes, I am ready to move to the location for the job.
• I am excited about the opportunity to relocate for this position.

• I have already researched the location and feel comfortable moving there.

• I have discussed the potential move with my family and we are all on board.

• I am prepared to make the necessary arrangements to move smoothly.
Answered by AI
Add your answer
Q2. Salary descussion
Add your answer

Q1. Do you have any experience handling client issue?
Ans. 
Yes, I have experience handling client issues in my previous role as a Technical Analyst.
• Managed and resolved technical issues reported by clients

• Communicated effectively with clients to understand their concerns and provide solutions

• Prioritized and escalated urgent client issues to ensure timely resolution
Answered by AI
Add your answer