台大研所備考 | 資管所 & 資工所

106年

第 3 題

2.5 分

答案已完成可重現的技術覆核；非官方答案。查看原始試卷

Which of the following SQL command selects all the records in the "Customers" table whose "Country" field is "Taiwan" and "City" field is either "Taipei" or "Kaohsiung"?

a.SELECT * FROM Customers WHERE Country='Taiwan' AND (City='Taipei' OR City='Kaohsiung');b.SELECT ALL FROM Customers WITH Country='Taiwan' AND (City='Taipei' OR City='Kaohsiung');c.SELECT * FROM Customers WHERE Country='Taiwan', City='Taipei' OR 'Kaohsiung';d.SELECT ALL FROM Customers AND Country='Taiwan' AND (City='Taipei' OR City='Kaohsiung')e.none of the above.