(40-60 words) in response to each of the following questions.Why do you think JOIN statements are important for working with databases? What are the consequences of choosing the wrong type of JOIN for your application?For what types of activities will aliasing be most useful?

In this activity, you used JOIN statements to combine data from multiple tables. In the text box below, write 2-3 sentences (40-60 words) in response to each of the following questions.Why do you think JOIN statements are important for working with databases? What are the consequences of choosing the wrong type of JOIN for your application?For what types of activities will aliasing be most useful?

What are Joins? Discuss all types of Joins with the help of suitable examples.

Question 2In this activity, you created a temporary table to run calculations without needing to make modifications to the primary tables in your database. In the text box below, write 2-3 sentences (40-60 words) in response to each of the following questions:Why was the JOIN statement necessary to use in this activity? What is the benefit of executing a query in a temporary table rather than a primary table in a database?

Which of the following about JOIN operations is/are correct?Question 9Select one or more:Select one or more:a.The lack of JOIN operations in a NoSQL database leads to the issues of data redundancy and data integrity.b.MongoDB supports a JOIN operator, similar to relational databases.c.The JOIN operations are essential for developing efficient autosharding technologies.d.The JOIN operations are not common in NoSQL databases because they could make the query processing slow.

Question 20When creating a SQL query, which JOIN clause returns all matching records in two or more database tables?1 pointLEFTRIGHTINNEROUTER