Kautilya Finance Investment Advisors Data Analyst Interview Questions and Answers

Python based EDA assignment

Q1. Nilllllllllllllllllllllllll
Add your answer

Q1. Explain Data types in SQL?
Ans. 
Data types in SQL define the type of data that can be stored in a column of a table.
• Data types include integer, float, text, date, boolean, etc.

• Each data type has specific properties and constraints.

• Examples: INT for integers, VARCHAR for variable-length character strings.
Answered by AI
Add your answer
Q2. Explain the difference between DBMS and RDBMS?
Ans. 
DBMS is a software system that manages databases, while RDBMS is a type of DBMS that stores data in a structured format using tables.
• DBMS stands for Database Management System, which is a software system that allows users to interact with a database.

• RDBMS stands for Relational Database Management System, which is a type of DBMS that stores data in a structured format using tables with relationships between them.

• RDBMS e...read more
Answered by AI
Add your answer

We started with our friends who is Business associate of Motilal Oswal finance services and those 2 friends are take brokership of financial firm, I was already there as a Tech Guy and Reasearcher for Stock Market and Fundamental Analytics , conducted more than 100 stocks analysis to advise clients to reduce the risk.

Q1. We friends just do a group discussion for the customer relationship
Add your answer
Q2. Investment and products related interview
Add your answer

Q1. What is your current role ?
Add your answer
Q2. Why are you looking for a job change?
Add your answer

Q1. Python based list iteration, SQL join based questions
Add your answer

Q1. What are the project you have worked upon ?
Add your answer

Basic apt questions. Can easily practice online

Q1. Few hypothetical questions to check your analysis knowledge
Add your answer
Q2. How much flowers were to be accumulated at the end of the day if each person offered 5 flowers a day at the temple.
Ans. 
The total number of flowers accumulated at the end of the day can be calculated by multiplying the number of people by the number of flowers each person offers.
• Multiply the number of people by 5 to get the total number of flowers accumulated

• For example, if there are 10 people, the total number of flowers accumulated would be 10 * 5 = 50
Answered by AI
Add your answer

It contained python coding questions as well as machine learning questions

Q1. Sql joins, python codes
Add your answer
Q2. Complete codes and correct erros
Add your answer
Q3. Machine learning
Add your answer

Case study related to my project and background and internship

Q1. Interview was taken in malad on interface 7 building The relationship officer Vaibhav Panchal . He assigned Interviewer the way he was talking he was not able to speak in english half of the question i was...read more
Add your answer
Q2. His english was poor How you will get the customer count who speak in english? he didn't gave me which table to fetch from ? * question changed get the customer from one table and count from the other ...read more
Add your answer