w3c-SQL Quiz

 https://www.w3schools.com/sql/sql_quiz.asp

SQL Quiz（共 25 題）：

第 1 題：

■SQL 代表什麼？

What does SQL stand for?

▶Strong Question Language

▶Structured Question Language

✔▶Structured Query Language 

第 2 題：

■哪條 SQL 語句用於從數據庫中提取數據？

Which SQL statement is used to extract data from a database?

▶EXTRACT 

✔▶SELECT 

▶OPEN 

▶GET 

第 3 題

■哪個 SQL 語句用於更新數據庫中

Which SQL statement is used to update data in a database?

▶SAVE AS 

▶MODIFY 

▶SAVE 

✔▶UPDATE 

第 4 題

■哪條 SQL 語句用於從數據庫中刪除數據？

Which SQL statement is used to delete data from a database?

✔▶DELETE    

▶REMOVE

▶COLLAPSE

第 5 題

■哪條 SQL 語句用於在數據庫中插入新數據？

Which SQL statement is used to insert new data in a database?

▶ADD NEW 

▶ADD RECORD 

▶INSERT NEW 

✔▶INSERT INTO

第 6 題：

■使用 SQL，如何從名為“Persons”的表中選擇名為“FirstName”的欄位？

With SQL, how do you select a column named "FirstName" from a table named "Persons"?

✔▶SELECT FirstName FROM Persons 

▶SELECT Persons.FirstName 

▶EXTRACT FirstName FROM Persons

第 7 題：

■使用 SQL，如何從名為“Persons”的表中選擇所有欄位？

With SQL, how do you select all the columns from a table named "Persons"?

▶SELECT Persons 

▶SELECT [all] FROM Persons 

✔▶SELECT * FROM Persons 

▶SELECT *.Persons 

第 8 題：

■使用 SQL，如何從名為“Persons”的表中選擇所有記錄，其中“FirstName”欄位的值為“Peter”？

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?

✔▶SELECT * FROM Persons WHERE FirstName='Peter'  

▶SELECT * FROM Persons WHERE FirstName<>'Peter'

▶SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'

▶SELECT [all] FROM Persons WHERE FirstName='Peter'

第 9 題：

■使用 SQL，如何從名為“Persons”的表中選擇所有記錄，其中“FirstName”列的值以“a”開頭？

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"?

✔▶SELECT * FROM Persons WHERE FirstName LIKE 'a%'  

▶SELECT * FROM Persons WHERE FirstName='%a%'

▶SELECT * FROM Persons WHERE FirstName LIKE '%a'

▶SELECT * FROM Persons WHERE FirstName='a'

第 10 題：

■如果列出的任何條件為真，OR 運算符將顯示一條記錄。如果列出的所有條件都為真，AND 運算符會顯示一條記錄

The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true

▶False 

✔▶True 

第 11 題：

■使用 SQL，如何從名為“Persons”的表中選擇所有記錄，其中“FirstName”為“Peter”，“LastName”為“Jackson”？

With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"?

✔▶SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'  

▶SELECT FirstName='Peter', LastName='Jackson' FROM Persons

▶SELECT * FROM Persons WHERE FirstName<>'Peter' AND LastName<>'Jackson'

第 12 題：

■使用 SQL，如何從名為“Persons”的表中選擇所有記錄，其中“LastName”按字母順序介於（包括）“Hansen”和“Pettersen”之間？

With SQL, how do you select all the records from a table named "Persons" where the "LastName" is alphabetically between (and including) "Hansen" and "Pettersen"?

▶SELECT LastName>'Hansen' AND LastName<'Pettersen' FROM Persons ▶SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName<'Pettersen' 

✔▶SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'

第 13 題：

■哪個 SQL 語句用於只返回不同的值？

Which SQL statement is used to return only different values?

✔▶SELECT DISTINCT     

▶SELECT UNIQUE

▶SELECT DIFFERENT

第 14 題：

■哪個 SQL 關鍵字用於對結果集進行排序？

Which SQL keyword is used to sort the result-set?

▶ORDER 

▶SORT 

✔▶ORDER BY 

▶SORT BY 

第 15 題：

■使用 SQL，如何從名為“Persons”的表中返回按“FirstName”降序排序的所有記錄？

With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?

✔▶SELECT * FROM Persons ORDER BY FirstName DESC 

▶SELECT * FROM Persons ORDER FirstName DESC 

▶SELECT * FROM Persons SORT 'FirstName' DESC 

▶SELECT * FROM Persons SORT BY 'FirstName' DESC 

第 16 題：

■使用 SQL，如何在“Persons”表中插入一條新記錄？

With SQL, how can you insert a new record into the "Persons" table?

✔▶INSERT INTO Persons VALUES ('Jimmy', 'Jackson') 

▶INSERT VALUES ('Jimmy', 'Jackson') INTO Persons 

▶INSERT ('Jimmy', 'Jackson') INTO Persons 

第 17 題：

■使用 SQL，如何在“Persons”表中插入“Olsen”作為“LastName”？

With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?

With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?

▶INSERT INTO Persons ('Olsen') INTO LastName 

✔▶INSERT INTO Persons (LastName) VALUES ('Olsen') 

▶INSERT ('Olsen') INTO Persons (LastName)

第 18 題：

■如何在 Persons 表的“LastName”欄位中將“Hansen”更改為“Nilsen”？

How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?

▶MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen' ▶UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen' 

▶MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen 

✔▶UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen' 

第 19 題：

■使用 SQL，如何刪除 Persons 表中“FirstName”為“Peter”的記錄？

With SQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table?

✔▶DELETE FROM Persons WHERE FirstName = 'Peter'   

▶DELETE FirstName='Peter' FROM Persons

▶DELETE ROW FirstName='Peter' FROM Persons

第20 題：

■使用 SQL，如何返回“Persons”表中的記錄筆數？

With SQL, how can you return the number of records in the "Persons" table?

▶SELECT NO(*) FROM Persons 

✔▶SELECT COUNT(*) FROM Persons 

▶SELECT COLUMNS(*) FROM Persons 

▶SELECT LEN(*) FROM Persons 

第21 題：

■最常見的連接類型是什麼？

What is the most common type of join?

▶JOINED 

▶JOINED TABLE 

▶INSIDE JOIN 

✔▶INNER JOIN 

第 22 題：

■哪個運算符用於選擇範圍內的值？

Which operator is used to select values within a range?

✔▶BETWEEN 

▶WITHIN 

▶RANGE 

第 23 題：

■NOT NULL 約束強制欄位內不接受 NULL 值。

The NOT NULL constraint enforces a column to not accept NULL values.

✔▶True     

▶False

第 24 題：

■哪個運算符用於搜索列中的指定模式？

Which operator is used to search for a specified pattern in a column?

✔▶LIKE

▶GET

▶FROM 

第 25 題：

■哪個 SQL 語句用於創建名為“客戶”的數據庫表？

Which SQL statement is used to create a database table called 'Customers'?

✔▶CREATE TABLE Customers 

▶CREATE DATABASE TAB Customers 

▶CREATE DB Customers 

▶CREATE DATABASE TABLE Customers