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

สั่งพิมพ์
ฝัง

ลีดเดอร์บอร์ด

สไตล์ภาพ

ตัวเลือก

สลับแม่แบบ

คืนค่าการบันทึกอัตโนมัติ: ใช่ไหม