Draw the initial query tree for this query, then show how the query tree is optimized (one rule at a time) and write the SQL query for the final optimized query tree.

Problem 9 Write a query to count the number of invoices.

Composite datatypes can only have multi row &multi column values in them Answers: Yes No

Write an SQL query to fetch the different projects available from the EmployeeSalary table.

Intersection table is needed when you have a relationship     1:1     M:N     M:1     1:M

Composite main keys have prospective keys.

Why it's useful to have index that partially sort a query if it doesn't present all of the results already sorted?

A Pivot Table is the column name with its table name. O True O False

C sharp Table: Student (the headers are the field names in the Students table) StudentID Name Age Gender ProgramID 791 Stephanie Brown 19 Female BCS 236 Shannon Dawn 25 Female BA 618 Geoff Berg 24 Male ARET 256 Andrew Schilling 22 Male BSC 902 Gary Sang 23 Male DAAD Note: There is a StudentDataSet with a Student table, a StudentTableAdapter, a StudentBindingSource, and a StudentDataGridView control on the form.Note: There is an Average query, named Average, that returns the average age of the student from the Student table.Note: There is also Max query, named Highest, that returns the highest age of the student from the Student table.Write the code you would place in the AverageButton click event on your form to call the Average query and the Highest query and display in a DifferenceLabel, the difference between the highest age of a student and the average age.