1. Brief about yourself (walk through your resume) 2. Why are you interested for this position 3. Question on projects mentioned in the resume 4. If there is a cube of 5cm and you want to divide it into cubes of size 1cm each, how many cubes can be formed? 5. If there are two buckets, 3l and 5l resp., How will you fill a bucket with 4l of water? 6. What is RANK() in sql? 7. What is Foreign Key?

Question

Accepted Answer

Answering interview questions for an Analyst position

Briefly introduce yourself and highlight key experiences from your resume
Explain your interest in the position and how it aligns with your career goals
Discuss projects mentioned in your resume and provide specific details or outcomes
For the cube question, calculate the total number of 1cm cubes that can fit in a 5cm cube (125 cubes)
For the bucket question, explain the process of filling the 3l bucket twice and transferring water to the 5l bucket until 4l is reached
In SQL, RANK() is a function that assigns a rank to each row within a partition of a result set
A foreign key is a column or a set of columns in a database table that refers to the primary key of another table, establishing a link between the two tables