Take Quiz - ⚡ Mixed Aptitude Test

1. What does SQL stand for?

Structured Question Language Simple Query Language Structured Query Language Statement Query Language

2. Which SQL command is used to retrieve data from a table?

GET SELECT FETCH VIEW

3. Which clause is used to filter rows before grouping?

WHERE ORDER HAVING ORDER BY

4. What does COUNT(*) return?

Number of rows Number of columns Number of table Number of nulls

5. What does this query return? SELECT AVG(salary) FROM employees WHERE department_id = 10;

Total salary of dept 10 Highest salary in dept 10 Average salary in dept 10 Count of employees in dept 10

6. Which symbol is used for a wildcard in SQL LIKE?

# * @ %

7. What is the function of PRIMARY KEY?

Allows nulls Accepts duplicates Uniquely identifies a row Creates a view

8. Which JOIN returns only matching rows from both tables?

FULL JOIN RIGHT JOIN LEFT JOIN INNER JOIN

9. What does ORDER BY name DESC do?

Sorts names in A-Z Filters name Sorts names in Z-A Sorts names in A-Z

10. What does GROUP BY do in SQL?

Sorts rows Combines rows with same values Splits rows Deletes duplicates