通过 SQL,在 "Actor" 表中删除 "FirstName" 等于 "Fred" 的记录的描述正确的是()。
A: DELETE FirstName='Fred' FROM Actor
B: DELETE ROW FirstName='Fred' FROM Actor
C: DELETE Actor WHERE FirstName = 'Fred'
D: DELETE FROM Actor WHERE FirstName = 'Fred'
A: DELETE FirstName='Fred' FROM Actor
B: DELETE ROW FirstName='Fred' FROM Actor
C: DELETE Actor WHERE FirstName = 'Fred'
D: DELETE FROM Actor WHERE FirstName = 'Fred'
举一反三
- 通过 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,从 "Actor" 表中选取 "FirstName" 列的值以 "a" 开头的所有记录的表述正确的是( )。 A: SELECT * FROM Actor WHERE FirstName='%a%' B: SELECT * FROM Actor WHERE FirstName='a' C: SELECT * FROM Actor WHERE FirstName LIKE '%a' D: SELECT * FROM Actor WHERE FirstName LIKE 'a%'
- 通过 SQL,从 “actor” 表中选取 "FirstName" 列的值等于"John" 的所有记录的表述正确的是( )。 A: SELECT [all] FROM Actor WHERE FirstName LIKE 'John' B: SELECT [all] FROM Actor WHERE FirstName='John' C: SELECT * FROM Actor WHERE FirstName LIKE 'John' D: SELECT * FROM Actor WHERE FirstName='John'
- 通过 SQL,在表 Actor 中选择 FirstName 等于 Jim 而 LastName 等于 Carter 的所有记录的表述正确的是( )。? SELECT * FROM Actor WHERE FirstName LIKE 'Jim' AND LastName LIKE 'Carter'|SELECT * FROM Actor WHERE FirstName='Jim' OR LastName='Carter'|SELECT FirstName='Jim', LastName='Carter' FROM Actor|SELECT * FROM Actor WHERE FirstName='Jim' AND LastName='Carter'
- 通过 SQL,在表 Actor 中选择 FirstName 等于 Jim 而 LastName 等于 Carter 的所有记录的表述正确的是( )。 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'