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 = " "