项目四单元测试
- 通过 SQL,如何从 Students表中选取所有的列?( )
- 通过 SQL,如何从 Students表中选取FirstName列的值等于"Peter" 的所有记录?( )
- 通过SQL,如何根据 FirstName列降序地从 "Persons" 表返回所有记录?( )
- 通过 SQL,如何向 Persons表插入新的记录?( )
- 如何把 Persons表中 "LastName" 列的 "Gates" 改为 "Wilson" ?( )
【SQL习题2】
请根据附件要求,完成作业。
A:SELECT [all] FROM Students B:SELECT *. Students C:SELECT * FROM Students D:SELECT Students
答案:SELECT * FROM Students
A:SELECT * FROM Students WHERE FirstName LIKE 'Peter‘ B:SELECT [all] FROM Students WHERE FirstName=’Peter’ C:SELECT * FROM Students WHERE FirstName='Peter’ D:SELECT [all] FROM Students WHERE FirstName LIKE 'Peter‘
A:SELECT * FROM Persons SORT BY 'FirstName' DESC B:SELECT * FROM Persons ORDER FirstName DESC C:SELECT * FROM Persons SORT 'FirstName' DESC D:SELECT * FROM Persons ORDER BY FirstName DESC
A:INSERT VALUES ('Jimmy', 'Jackson') B:INSERT VALUES ('Jimmy', 'Jackson') INTO Persons C:INSERT ('Jimmy', 'Jackson') INTO Persons D:INSERT INTO Persons VALUES ('Jimmy', 'Jackson')
A:MODIFY Persons SET LastName='Wilson' WHERE LastName='Gates‘ B:MODIFY Persons SET LastName='Wilson' INTO LastName='Gates‘ C:UPDATE Persons SET LastName='Wilson' WHERE LastName='Gates‘ D:UPDATE Persons SET LastName='Wilson' INTO LastName='Gates‘
温馨提示支付 ¥3.00 元后可查看付费内容,请先翻页预览!