Dolat Capital Market Quantitative Analyst Interview Questions and Answers

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

Asked about a case study on whom to give a loan among 1000 customers

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. 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

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. 1. Introduction
Add your answer
Q2. 2. Project description
Ans. 
Developed a predictive model to forecast sales based on historical data
• Used machine learning algorithms to analyze sales trends

• Incorporated external factors like seasonality and promotions into the model

• Validated the model using cross-validation techniques
Answered by AI
View 1 more answer
Q3. Basics for spark and scala
Add your answer