通过 SQL，从 “actor” 表中选取 "FirstName" 列的值等于"John" 的所有记录的表述正确的是（）。

A.SELECT * FROM Actor WHERE FirstName LIKE 'a%'

B.SELECT * FROM Actor WHERE FirstName='a'

C.SELECT * FROM Actor WHERE FirstName LIKE '%a'

D.SELECT * FROM Actor WHERE FirstName='%a%'

A.SELECT * FROM Actor SORT 'FirstName' DESC

B.SELECT * FROM Actor ORDER BY FirstName DESC

C.SELECT * FROM Actor ORDER FirstName DESC

D.SELECT * FROM Actor SORT BY 'FirstName' DESC

A.select actor.FirstName

B.extract FirstName from actor

C.select FirstName from actor

D.update FirstName from actor

A.SELECT * FROM Actor WHERE FirstName LIKE 'Jim' AND LastName LIKE 'Carter'

B.SELECT FirstName='Jim', LastName='Carter' FROM Actor

C.SELECT * FROM Actor WHERE FirstName='Jim' AND LastName='Carter'

D.SELECT * FROM Actor WHERE FirstName='Jim' OR LastName='Carter'

A.SELECT * FROM Actor WHERE LastName BETWEEN 'Adams' AND 'Carter'

B.SELECT * FROM Actor WHERE LastName>'Adams' AND LastName<'Carter'

C.SELECT LastName>'Adams' AND LastName<'Carter' FROM Actor

D.SELECT * FROM Actor WHERE LastName>'Adams' OR LastName<'Carter'

A.SELECT COLUMNS() FROM Actor

B.SELECT COLUMNS(*) FROM Actor

C.SELECT COUNT() FROM Actor

D.SELECT COUNT(*) FROM Actor

A.INSERT ('Jimmy', 'Jackson') INTO Actor

B.INSERT VALUES ('Jimmy', 'Jackson') INTO Actor

C.INSERT INTO Actor VALUES ('Jimmy', 'Jackson')

D.INSERT INTO Actor VALUE ('Jimmy', 'Jackson')