1. SQL stands for Structured Quick Language Select Query Language a. b. c. Semi-Quick Language d. Structured Query Language 2. Which of the following will select the State and Sales fields from the Stores table? a. SELECT State AND Sales FROM Stores b. SELECT State OR Sales FROM Stores c. SELECT State, Sales FROM Stores d. SELECT ONLY State, Sales FROM Stores 3. Which of the following will select the SSN field from the PayInfo table and then sort the records in descending order by the SSN field? a. SELECT SSN FROM PayInfo DESC b. SELECT SSN FROM PayInfo ORDER BY SSN DESC c. SELECT SSN FROM PayInfo WHERE SSN DESC d. SELECT SSN FROM PayInfo SORT SSN DESC Which of the following will select the Id and Status fields for records whose Status field contains only the letter F? a. SELECT Id, Status FROM Employ WHERE Status F b. SELECT Id, Status FROM Employ ORDER BY Status'F c. SELECT Id, Status FROM Employ FOR Status'F d. SELECT Id, Status FROM Employ SELECT Status 'F' 4. 5. Which of the following will select the State and Capital fields for the Kansas and Kentucky records? a. SELECT State, Capital FROM States WHERE State LIKE 'K b. SELECT State, Capital FROM States WHERE State LIKE K C. SELECT State, Capital FROM States WHERE State LIKE 'K%" d. SELECT State, Capital FROM States WHERE State LIKE 'K Which of the following will select the State and Capital fields for states with that exceed 5,000,000? (The Population field is numeric.) a. SELECT State, Capital FROM States WHERE Population5000000 b. SELECT State, Capital FROM States WHERE Population 5000000 c. SELECT State, Capital FROM States WHERE Population"5000000" d. SELECT State, Capital FROM States SELECT Population5000000 6. 7. In a SELECT statement, which clause is used to limit the records that will be selected? a. LIMIT b. ORDER BY C. ONLY d. WHERE What does the funnel symbol that appears next to a field's name in the Query Builder dialog box indicate? a. The field is used in a SELECT statement's ORDER BY clause b. The field is used in a SELECT statement's WHERE clause c. The field is the primary key. d. The field is the foreign key. 8. 9 The SQL SELECT statement performs case-sensitive comparisons. a. True b. False 10. When used in a parameter query, which of the following WHERE clauses will select the records for employees working more than 40 hours? a. WHERE Hours@Hours b. WHERE HoursHours C. WHERE Hours > #Hours d- WHERE Hours > %Hours Which of the following calculates the average of the values in the OnHand field? a. SELECT AVERAGE (OnHand) AS Available FROM dbo.Inventory b. SELECT OnHand.AVG AS Available FROM dbo.Inventory c. SELECT AVGCOnHand) AS Available FROM dbo.Inventory d. SELECT AVG.OnHand AS Available FROM dbo.Inventory 11. 12. Which ofthe following calculates a 10% commission on the values in the Sales field and then stores the results in the Commission field? a. SELECT Year, Sales, Commission Sales 0.1 FROM dbo.TrentSales b. SELECT Year, Sales, AS Commission = Sales * 0.1 FROM dbo . TrentSales c. SELECT Year, Sales, Sales0.1 Commission FROM dbo.TrentSales d. SELECT Year, Sales, Sales 0.1 AS Commission FROM dbo . TrentSales