• 2022-06-14
    通过 SQL,向 "Actor" 表中的 "LastName" 列插入 "Wilson"表述正确的是()。
    A: INSERT INTO Actor (LastName) VALUES ('Wilson')
    B: INSERT INTO Actor ('Wilson') INTO LastName
    C: INSERT INTO Actor ('Wilson') INTO (LastName)
    D: INSERT ('Wilson') INTO Actor (LastName)
  • A

    内容

    • 0

      通过 SQL,按字母顺序选取 Actor 表中 LastName 介于 Adams 和 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'

    • 1

      通过 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'

    • 2

      通过 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'

    • 3

      通过 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'

    • 4

      通过 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'