1) What clause is used to filter rows in a SQL query? a) SELECT b) FROM c) WHERE d) ORDER BY 2) In SQL, which keyword is used to sort the result set in ascending order? a) ASC b) DESC c) LIKE d) ORDER BY 3) Which SQL clause is used to sort the result set based on a specific column? a) WHERE b) SORT c) GROUP BY d) ORDER BY 4) What is the purpose of the SQL LIKE operator? a) It limits the number of rows returned in a query b) It allows for pattern matching in a query c) It specifies the order of the result set d) It groups rows based on a specified criteria 5) Which SQL statement is used to select specific column(s) from a table? a) ADJUST b) SORT c) SELECT d) ORDER 6) What does the SQL keyword SELECT do? a) Deletes data from a table b) Adds a new table to the database c) Retrieves data from one or more database tables d) Modifies the structure of a table 7) In SQL, what is the purpose of the WHERE clause? a) To execute a one-time task b) To filter rows based on a specific condition c) To join multiple tables d) To order the result set 8) Which SQL clause is used to specify the order of the result set? a) ORDER BY b) GROUP BY c) SORT BY d) ARRANGE BY 9) What does the SQL keyword LIKE do? a) Combines multiple tables b) Filters rows based on a specified pattern c) Deletes data from a table d) Creates a new database 10) What is the purpose of the SQL ORDER BY clause? a) To filter rows based on a condition b) To update existing records c) To sort the result set based on a specific column d) To limit the number of rows returned in a query

SQL Basics Assessment

列印
嵌入

排行榜

視覺風格

選項

切換範本

恢復自動保存: ?