WHERE number = 4 or number = 8 WHERE number BETWEEN 4 and 8 WHERE number = ' 4 or 8 ' Where number = ' 4 ' or ' 8 '
5.( TCO 1) Assume you want to associate a TaxpayerTable with a PrincipalResidenceTable. The PrincipalResidentTable contains the address where each taxpayer lives. Assume that each taxpayer can have only one residence; however, more than one person at the address can be considered a taxpayer. What is the relationship between the TaxpayerTable and PrincipalResidenceTable?( Points: 5) Many-To-One One-To-Many Many-to-Many One-to-One
6.( TCO 1) Which of the following would display values from the city field in the Professor table, removing all duplicate city names?( Points: 5) SELECT City DISTINCT FROM Professor SELECT City FROM DISTINCT Professor SELECT DISTINCT City FROM Professor SELECT DISTINCT FROM Professor
7.( TCO 1) Assume you have a table called StudentTable. You would like to extract the lastname of all students who have not yet declared their major. Which of the following WHERE clauses would accomplish this?( Points: 5) WHERE major = " " WHERE major = ' ' WHERE major IS NULL WHERE major = ' NULL '
8.( TCO 3) Which of the following statements would count the number of customers within each state? Assume you have a table with the following columns:( Points: 5)