Quiz for SQL Syntax

Q1: Which character is used to terminate SQL statements?

A. Comma (,) B. Period (.) C. Semicolon (;) D. Colon (:)

Q2: Which keyword is used to retrieve data from a database?

A. GET B. FETCH C. RETRIEVE D. SELECT

Q3: What symbol is used to terminate a SQL statement?

A. . B. ; C. , D. /

Q4: Which of the following is not a valid SQL keyword?

A. WHERE B. GET C. INSERT D. UPDATE

Q5: Which clause is used to filter rows in SQL?

A. WHERE B. GROUP BY C. ORDER BY D. HAVING

Q6: Which clause is used to sort the results of a query?

A. ORDER BY B. SORT BY C. GROUP BY D. FILTER BY

Q7: What is the correct order of clauses in a SELECT query?

A. FROM, SELECT, WHERE B. SELECT, WHERE, FROM C. SELECT, FROM, WHERE D. WHERE, SELECT, FROM

Q8: Which clause is used to remove duplicates?

A. DISTINCT B. UNIQUE C. FILTER D. NO DUPLICATE

Q9: How are strings enclosed in SQL?

A. "string" B. string C. #string# D. 'string'

Q10: Which statement is used to insert data?

A. ADD B. INSERT INTO C. PUT D. CREATE

Q11: Which keyword is used to update existing data?

A. CHANGE B. MODIFY C. UPDATE D. ALTER

Q12: What is used to rename a column in SQL temporarily?

A. CHANGE B. RENAME C. AS D. MODIFY

Q13: Which clause limits the number of rows returned?

A. TOP B. LIMIT C. ROWNUM D. FETCH

Q14: What keyword is used to create a new table?

A. MAKE B. ADD TABLE C. CREATE TABLE D. NEW TABLE

Q15: What clause specifies conditions on grouped data?

A. WHERE B. ORDER BY C. HAVING D. GROUP BY

Q16: Which function returns the number of rows?

A. TOTAL() B. COUNT() C. SUM() D. ROWS()

Q17: Which operator is used for pattern matching?

A. = B. LIKE C. IN D. ==

Q18: What is the default sort order in ORDER BY?

A. Ascending B. Descending C. Random D. None

Q19: What does SELECT * do?

A. Selects all columns B. Selects specific columns C. Selects all tables D. Selects nothing

Q20: Which clause is optional in a SELECT query?

A. FROM B. SELECT C. WHERE D. None

Q21: Which symbol is used for comments in SQL?

A. -- B. ## C. // D. !!