Create your own
teaching resources

Sign up for a free account to try! It takes less than 20 seconds

Teacherbot 17 Jan, 19:38:37
  1. In SQL, what is the command used to delete data from a table? A. INSERTEGIN* B. DROPTABLE C. DELETE D. DROP

  2. What command is used to restrict the number of records returned by a query? A. PICK B. JOIN C. LIMIT* D. SORT

  3. What operator is used to combine the results of two queries into one result set? A. AND B. INTERSECT C. UNION* D. OR

  4. Which keyword is used to specify a condition when retrieving records from a table? A. IF B. WHILE C. WHERE* D. DO

  5. Which type of clause is used to modify the sequence of data returned by a query? A. SELECT B. ORDER BY* C. FROM D. WHERE

  6. What is the full form of SQL? A. Standard Query Lines B. Structured Query Language* C. Structured Query Lines D. Standard Query Language

  7. What keyword is used in SQL to give access to certain records in a table? A. GRANT* B. ALLOW C. PERMIT D. LET

  8. How do you represent wildcards in a LIKE clause? A. # B. & C. * D. %*

  9. What is the default ordering of returned records in a query? A. Random B. Ascending C. Descending D. Unsorted / No Default Ordering*

  10. Which clause is used to remove records from a table in SQL? A. DROP* B. DELETE C. CLEAR D. REMOVE