Oracle 选择题

1. 题目

1. SQL 指的是？

   A. Strong Question Language

   B. Structured Question Language

   C. Structured Query Language

2. 哪个 SQL 语句用于从数据库中提取数据？

   A. SELECT

   B. OPEN

   C. GET

   D. EXTRACT

3. 哪条 SQL 语句用于更新数据库中的数据？

   A. UPDATE

   B. SAVE

   C. SAVE AS

   D. MODIFY

4. 哪条 SQL 语句用于删除数据库中的数据？

   A. REMOVE

   B. DELETE

   C. COLLAPSE

5. 哪条 SQL 语句用于在数据库中插入新数据？

   A. ADD NEW

   B. INSERT NEW

   C. INSERT INTO

   D. ADD RECORD

6. 使用 SQL，如何从名为Persons的表中选择名为FirstName的列？

   A. EXTRACT FirstName FROM Persons

   B. SELECT FirstName FROM Persons

   C. SELECT Persons.FirstName

7. 使用 SQL，如何从名为Persons的表中选择所有列？

   A. SELECT Persons

   B. SELECT *.Persons

   C. SELECT [all] FROM Persons

   D. SELECT * FROM Persons

8. 使用 SQL，如何从名为Persons的表中选择FirstName列的值为Peter的所有记录？

   A. SELECT [all] FROM Persons WHERE FirstName ='Peter'

   B. SELECT [all] FROM Persons WHERE FirstName LIKE'Peter'

   C. SELECT * FROM Persons WHERE FirstName ='Peter'

   D. SELECT * FROM Persons WHERE FirstName <>'Peter'

9. 使用 SQL，如何从名为Persons的表中选择所有记录，其中FirstName列的值以a开头？

   A. SELECT * FROM Persons WHERE FirstName LIKE'％a'

   B. SELECT * FROM Persons WHERE FirstName ='％a％'

   C. SELECT * FROM Persons WHERE FirstName ='a'

   D. SELECT * FROM Persons WHERE FirstName LIKE'a％'

10. 如果列出的任何条件为真，OR 运算符将显示一条记录。如果列出的所有条件都为真，AND 运算符将显示一条记录

    A. True

    B. False

11. 使用 SQL，如何在表 Persons 中选择 FirstName 等于 Peter 而 LastName 等于 Jackson 的所有记录？

    A. SELECT FirstName='Peter', LastName='Jackson' FROM Persons

    B. SELECT * FROM Persons WHERE FirstName='Peter' AND Last-Name='Jackson'

    C. SELECT * FROM Persons WHERE FirstName<>'Peter' AND Last-Name<>'Jackson'

12. 使用 SQL，如何按字母顺序选取 Persons 表中 LastName 介于（包含） Hansen 和 Pettersen 的所有记录？

    A. SELECT LastName>'Hansen' AND LastName<'Pettersen' FROM Persons

    B. SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pet-tersen'

    C. SELECT * FROM Persons WHERE LastName>'Hansen' AND Last-Name<'Pettersen'

13. 哪条 SQL 语句可返回唯一不同的值？

    A. SELECT DISTINCT

    B. SELECT DIFFERENT

14. 哪个 SQL 关键词用于对结果集进行排序？

    A. SORT

    B. ORDER

    C. ORDER BY

    D. SORT BY

15. 使用 SQL，如何根据 "FirstName" 列降序地从 "Persons" 表返回所有记录？

    A. SELECT * FROM Persons SORT BY 'FirstName' DESC

    B. SELECT * FROM Persons SORT 'FirstName' DESC

    C. SELECT * FROM Persons ORDER FirstName DESC

    D. SELECT * FROM Persons ORDER BY FirstName DESC

16. 使用 SQL，如何向 "Persons" 表插入新的记录？

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

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

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

17. 使用 SQL，如何向 "Persons" 表中的 "LastName" 列插入 "Olsen" ？

    A. INSERT INTO Persons (LastName) VALUES ('Olsen')

    B. INSERT ('Olsen') INTO Persons (LastName)

    C. INSERT INTO Persons ('Olsen') INTO LastName

18. 使用 SQL，如何把 "Persons" 表中 "LastName" 列的 "Hansen" 改为 "Nilsen" ？

    A. UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen'

    B. MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen

    C. UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'

    D. MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'

19. 使用 SQL，如何在 "Persons" 表中删除 "FirstName" 等于 "Peter" 的纪录？

    A. DELETE FirstName='Peter' FROM Persons

    B. DELETE ROW FirstName='Peter' FROM Persons

    C. DELETE FROM Persons WHERE FirstName = 'Peter'

20. 使用 SQL，如何返回 "Persons" 表中记录的数目？

    A. SELECT NO(*) FROM Persons

    B. SELECT COUNT(*) FROM Persons

    C. SELECT LEN(*) FROM Persons

    D. SELECT COLUMNS(*) FROM Persons

21. 哪个操作符用于选择范围内的值？

    A. BETWEEN

    B. RANGE

    C. WITHIN

22. NOT NULL 约束强制约束列不接受空值。

    A. False

    B. True

23. 哪个操作符用于在列中模糊搜索？

    A. GET

    B. LIKE

    C. FROM

24. 哪个 SQL 语句用于在数据库中创建表？

    A. CREATE DATABASE TABLE

    B. CREATE DB

    C. CREATE DATABASE TAB

    D. CREATE TABLE

2. 答案