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

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

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?

The following CREATE SQL statement are correct EXCEPT _____.a.CREATE TABLEb.CREATE SQLc.CREATE SCHEMAd.CREATE VIEW

The purpose of SQL joins is to combine rows from two or more tables based on a related column.a.Trueb.False