GrowthSpree Data Scientist Interview Questions and Answers

How you handle certain situations and stuffs

Q1. Regarding Python and oops
Add your answer
Q2. SQL based questions
Add your answer
Q3. What is SQL ?
Ans. 
SQL is a programming language used for managing and manipulating relational databases.
• SQL stands for Structured Query Language.

• It is used to communicate with and manipulate databases.

• SQL can be used to retrieve data, update data, insert data, and delete data from databases.

• Examples of SQL commands include SELECT, INSERT, UPDATE, and DELETE.
Answered by AI
Add your answer
Q4. What is RDBMS ?
Ans. 
RDBMS stands for Relational Database Management System, a type of database management system that stores data in a structured format.
• Organizes data into tables with rows and columns

• Uses SQL for querying and managing data

• Supports ACID properties for data consistency

• Examples include MySQL, PostgreSQL, Oracle
Answered by AI
Add your answer
Q5. What are joins ?
Ans. 
Joins are used in databases to combine rows from two or more tables based on a related column between them.
• Joins are used to retrieve data from multiple tables based on a related column.

• Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• INNER JOIN returns rows when there is at least one match in both tables.

• LEFT JOIN returns all rows from the left table and the matched rows from the right ta...read more
Answered by AI
Add your answer