Lab 3 - SQL Quiz
1. What does SQL stand for?
Structured Query Language
Simple Query Language
Sequential Query Logic
System Query Link
2. Which SQL statement is used to retrieve data from a table?
GET
SELECT
FETCH TABLE
SHOW DATA
3. Which clause is used to filter rows?
ORDER BY
GROUP BY
WHERE
HAVING
4. Which SQL command adds a new row into a table?
ADD ROW
INSERT INTO
CREATE ROW
NEW RECORD
5. Which command updates existing data in a table?
CHANGE
MODIFY
UPDATE
EDIT
6. Which command removes rows from a table?
DELETE
REMOVE
DROP
ERASE
7. Which keyword sorts query results?
SORT BY
ORDER BY
ARRANGE BY
GROUP BY
8. What does PRIMARY KEY do?
Allows duplicate values
Identifies each row uniquely
Stores only text values
Connects to another database
9. Which JOIN returns matching rows from both tables?
LEFT JOIN
RIGHT JOIN
INNER JOIN
FULL JOIN
10. Which function returns the number of rows?
TOTAL()
ROWS()
COUNT()
SUM()
Back to Home