Which columns should you place at the beginning when creating temporary join tables?A.Columns containing big number of charactersB.Columns used for joins with other tablesC.Non key columnsD.Columns containing aggregate values

Which elements of a temporary join table have a major impact on query performance? Select TWO correct answers.A. Table sortingB. Number of columnsC. Existence of table statistic

If a temporary table contains custom fields not essential for joins with other tables, you should place these fields at the beginning of the CREATE TABLE statement.A.TrueB.False

Creating a view instead of a temporary join table...A.is always wrongB.is the preferred approach because it saves the storageC.should be limited to Data Model tables only

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 do you need to consider when you make a table in SQL?a.Data typesb.Primary keysc.Default valuesd.All of the mentioned