Quiz 2 9. Consider the following SQL query: SELECT title, name FROM Employee ORDER BY title, name DESC -------- ---- order, the names of In output of above query the different titles are listed in employess having same title are listed in --------- order. Fill in the blanks with the appropriate words. a) Descending, Ascending b) Ascending, Ascending c C) Ascending, Descending ) d) Descending, Descending, Leave blank Close Quiz 2 7. With SQL, how do you select all the records from a table named "Persons where the value of the column "FirstName" ends with an "a"? 1) SELECT * FROM Persons WHERE FirstName='a' II) SELECT * FROM Persons WHERE FirstName LIKE a% III) SELECT * FROM Persons WHERE FirstName LIKE '%a' IV) SELECT * FROM Persons WHERE FirstName='%a%' IV III C) 1 d) II Leave blank Close Quiz 2 8. Product and Company tables are given to you. If we run the following query what will be displayed as output? SELECT PName, Price FROM Product, Company WHERE Manufacturer=CName AND Country='Japan' AND Price