Samsung MIS Analyst Interview Questions and Answers

Q1. What is cap rate
Ans. 
Cap rate, or capitalization rate, is a measure used to evaluate the potential return on investment for a real estate property.
• Cap rate is calculated by dividing the property's net operating income (NOI) by its current market value.

• It is expressed as a percentage and is used by investors to compare different investment opportunities.

• A higher cap rate indicates a higher potential return, but may also come with higher ris...read more
Answered by AI
Add your answer

Q1. Why should we hire you
Add your answer
Q2. Why did you choose Dell
Add your answer
Q3. Why different would you bring to the table
Add your answer

Q1. Tell me about yourself
Ans. 
I am a dedicated and detail-oriented analyst with a strong background in data analysis and problem-solving.
• I have a Bachelor's degree in Statistics and have completed multiple data analysis projects during my studies.

• I am proficient in using statistical software such as R and Python for data analysis.

• I have experience in conducting market research and creating reports to help businesses make informed decisions.

• I am a q...read more
Answered by AI
Add your answer
Q2. Sql basic question from oracle
Add your answer

There were three python based interview questions

There were three Aptitude based interview questions

Q1. Tell me yourself
Add your answer

Q1. Discussion about salary
Add your answer

Q1. Sql rank order explain
Ans. 
SQL rank order function explanation
• Rank order function in SQL assigns a rank to each row based on a specified column

• It can be used to determine the top or bottom N records in a dataset

• Example: SELECT column1, column2, RANK() OVER (ORDER BY column3 DESC) AS rank_order FROM table_name
Answered by AI
Add your answer
Q2. Merging two tables
Ans. 
Merging two tables involves combining data from both tables based on a common key.
• Identify a common key between the two tables

• Use SQL JOIN statements to merge the tables

• Choose the appropriate type of join (e.g. inner join, outer join)

• Consider the size of the tables and the performance implications of the merge
Answered by AI
Add your answer

Q1. Growth of sales between the years
Ans. 
The sales growth between the years is calculated by comparing the sales figures from one year to another.
• Calculate the difference in sales between the two years

• Divide the difference by the sales figure of the initial year

• Multiply the result by 100 to get the percentage growth

• For example, if sales were $100 in year 1 and $120 in year 2, the growth would be (120-100)/100 * 100 = 20%
Answered by AI
Add your answer

Q1. Tell me about yourself
Add your answer

Q1. About yourself n work profile
Add your answer