通过 SQL,您如何向 "Persons" 表中的 "LastName" 列插入 "Wilson" ( )。
A.INSERT ('Wilson') INTO Persons (LastName)
B.INSERT INTO Persons VALUES('Wilson'
C.INSERT INTO Persons (LastName) VALUES ('Wilson')
D.INSERT INTO Persons ('Wilson') INTO LastName
A.INSERT ('Wilson') INTO Persons (LastName)
B.INSERT INTO Persons VALUES('Wilson'
C.INSERT INTO Persons (LastName) VALUES ('Wilson')
D.INSERT INTO Persons ('Wilson') INTO LastName
第1题
A.SELECTPersons.FirstName
B.SELECTFirstNameFROMPersons
C.EXTRACTFirstNameFROMPersons
D.SELECTFirstName
第2题
A.SELECT*.Persons
B.SELECT*FROMPersons
C.SELECTPersons
D.SELECT[all]FROMPersons
第3题
A.SELECTCOLUMNS(*)FROMPersons
B.SELECTCOUNT()FROMPersons
C.SELECTCOLUMNS()FROMPersons
D.SELECTCOUNT(*)FROMPersons
第4题
A.SELECT*FROMPersonsWHEREFirstName='%a%'
B.SELECT*FROMPersonsWHEREFirstName='a'
C.SELECT*FROMPersonsWHEREFirstNameLIKE'%a'
D.SELECT*FROMPersonsWHEREFirstNameLIKE'a%'
第5题
A.SELECT*FROMPersonsORDERFirstNameDESC
B.SELECT*FROMPersonsORDERBYFirstNameDESC
C.SELECT*FROMPersonsSORTBY'FirstName'DESC
D.SELECT*FROMPersonsSORT'FirstName'DESC
第6题
A.SELECT[all]FROMPersonsWHEREFirstName='Peter'
B.SELECT*FROMPersonsWHEREFirstName='Peter'
C.SELECT*FROMPersonsWHEREFirstNameLIKE'Peter'
D.SELECT[all]FROMPersonsWHEREFirstNameLIKE'Peter'
第7题
A.SELECT*FROMPersonsWHERELastName>'Adams'ORLastName<'Carter'
B.SELECT*FROMPersonsWHERELastName>'Adams'ANDLastName<'Carter'
C.SELECT*FROMPersonsWHERELastNameBETWEEN'Adams'AND'Carter'
D.SELECTLastName>'Adams'ANDLastName<'Carter'FROMPersons
第8题
A.DELETE FirstName='Fred' FROM Persons
B.DELETE ROW FirstName='Fred' FROM Persons
C.DELETE FROM Persons
D.DELETE FROM Persons WHERE FirstName='Fred'
第9题
A.选择FirstName等于'Thomas',LastName等于'Carter'FROMPersons
B.选择*FROMPersonsWHEREFirstName等于'Thomas'ANDLastName等于'Carter'
C.SELECT*FROMPersonsWHEREFirstNameLIKE'Thomas'ANDLastNameLIKE'Carter'
D.选择*FROMPersonsWHEREFirstName等于'Thomas'ORLastName等于'Carter'
第10题
A.UPDATE Persons SET LastName='Wilson' INTO LastName='Gates'
B.MODIFY Persons SET LastName='Wilson' INTO LastName='Gates'
C.UPDATE Persons SET LastName='Wilson' WHERE LastName='Gates'
D.MODIFY Persons SET LastName='Wilson' WHERE LastName='Gates'
为了保护您的账号安全,请在“赏学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!