通过SQL语句，如何往表“Persons”插入一条新纪录？ A: INSERT ('Jimmy', 'Jackson') INTO Persons B: INSERT INTO Persons VALUES ('Jimmy', 'Jackson') C: INSERT VALUES ('Jimmy', 'Jackson') INTO Persons D: INSERT ('Jimmy', 'Jackson') INTO Persons Values

通过 SQL，您如何按字母顺序选取 Persons 表中 LastName 介于 Adams 和 Carter 之间（含其本身）的所有记录？ A: SELECT * FROM Persons WHERE LastName BETWEEN 'Adams' AND 'Carter' B: SELECT * FROM Persons WHERE LastName>'Adams' AND LastName C: SELECT LastName>'Adams' AND LastName

通过 SQL，您如何在表 Persons 中选择 FirstName 等于 Thomas ，并 且LastName 等于 Carter 的所有记录？ A: SELECT * FROM Persons WHERE FirstName LIKE 'Thomas' AND LastName LIKE 'Carter' B: SELECT FirstName='Thomas', LastName='Carter' FROM Persons C: SELECT * FROM Persons WHERE FirstName='Thomas' AND LastName='Carter'

通过SQL，将"Actor"表中"LastName"列的"Gates"改为"Wilson"正确的是（）。 A: UPDATEActorSETLastName='Wilson'WHERELastName='Gates' B: UPDATEActorSETLastName='Wilson'INTOLastName='Gates' C: MODIFYActorSETLastName='Wilson'WHERELastName='Gates' D: MODIFYActorSETLastName='Wilson'INTOLastName='Gates'

通过 SQL，将'Actor' 表中 'LastName' 列的 'Gates' 改为 'Wilson' 正确的是（ ）。