BRANDROOT MEDIA Media Interview Questions and Answers

Valid parentheses in python

Q1. Types of joins in sql
Ans. 
Types of joins in SQL include inner join, left join, right join, and full outer join.
• Inner join: returns rows when there is a match in both tables

• Left join: returns all rows from the left table and the matched rows from the right table

• Right join: returns all rows from the right table and the matched rows from the left table

• Full outer join: returns all rows when there is a match in either table
Answered by AI
Add your answer
Q2. Best practices used in sql
Ans. 
Best practices in SQL include using indexes, optimizing queries, normalizing data, and using stored procedures.
• Use indexes to improve query performance

• Optimize queries by avoiding unnecessary joins and using appropriate WHERE clauses

• Normalize data to reduce redundancy and improve data integrity

• Use stored procedures for frequently executed tasks to improve performance
Answered by AI
Add your answer

Q1. Spark rddd , data frame and data set difference
Add your answer