通过 SQL，您如何从 "Persons" 表中选取所有的列？ A: SELECT [all] FROM Persons B: SELECT Persons C: SELECT * FROM Persons D: SELECT *.Persons

通过 SQL，您如何返回 "Persons" 表中记录的数目？ A: SELECT COLUMNS() FROM Persons B: SELECT COLUMNS(*) FROM Persons C: SELECT COUNT() FROM Persons D: SELECT COUNT(*) FROM Persons

通过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" 列插入 "Wilson" ？ A: INSERT INTO Persons (LastName) VALUES ('Wilson') B: INSERT ('Wilson') INTO Persons (LastName) C: INSERT INTO Persons ('Wilson') INTO LastName D: INSERT Persons (LastName) VALUES ('Wilson')

通过 SQL，您如何向 "Persons" 表插入新的记录？ A: INSERT ('Jimmy', 'Jackson') INTO Persons B: INSERT VALUES ('Jimmy', 'Jackson') INTO Persons C: INSERT INTO Persons VALUES ('Jimmy', 'Jackson')

通过 SQL，您如何向 "Persons" 表中的 "LastName" 列插入 "Wilson" ？ A: INSERT INTO Persons (LastName) VALUES ('Wilson') B: INSERT ('Wilson') INTO Persons (LastName) C: INSERT INTO Persons ('Wilson') INTO LastName

通过 SQL，您如何根据 "FirstName" 列降序地从 "Persons" 表返回所有记录？ A: SELECT * FROM Persons SORT 'FirstName' DESC B: SELECT * FROM Persons ORDER BY FirstName DESC C: SELECT * FROM Persons ORDER FirstName DESC D: SELECT * FROM Persons SORT BY 'FirstName' DESC

通过 SQL，您如何从 "Persons" 表中选取 "FirstName" 列的值以 "a" 开头的所有记录？ A: SELECT * FROM Persons WHERE FirstName LIKE 'a%' B: SELECT * FROM Persons WHERE FirstName='a' C: SELECT * FROM Persons WHERE FirstName LIKE '%a' D: SELECT * FROM Persons WHERE FirstName='%a%'

通过 SQL，您如何在 "Persons" 表中删除 "FirstName" 等于 "Fred" 的纪录？ A: DELETE FROM Persons WHERE FirstName = 'Fred' B: DELETE FirstName='Fred' FROM Persons C: DELETE ROW FirstName='Fred' FROM Persons

通过 SQL，您如何从 "Persons" 表中选取 "FirstName" 列？ A: SELECT Persons.FirstName B: SELECT FirstName FROM Persons C: EXTRACT FirstName FROM Persons