Practice Questions
Question 1
Which SQL statement is used to retrieve data from a database?
A. INSERT
B. SELECT
C. UPDATE
D. DELETE
✅ Answer: B
Explanation:
The SELECT statement is used to query and retrieve data from tables.
Question 2
Which SQL statement adds new rows to a table?
A. INSERT
B. CREATE
C. ALTER
D. SELECT
✅ Answer: A
Explanation:
INSERT is used to add new records to a table.
Question 3
Which SQL statement modifies existing data in a table?
A. UPDATE
B. DELETE
C. SELECT
D. DROP
✅ Answer: A
Explanation:
UPDATE changes existing values in one or more rows.
Question 4
Which SQL statement removes rows from a table?
A. DROP
B. DELETE
C. ALTER
D. TRUNCATE
✅ Answer: B
Explanation:
DELETE removes specific rows based on a condition.
Question 5
Which SQL statement creates a new table?
A. ALTER
B. CREATE
C. INSERT
D. SELECT
✅ Answer: B
Explanation:
CREATE is used to define new database objects such as tables.
Question 6
Which clause is used to filter rows in a SQL query?
A. ORDER BY
B. GROUP BY
C. WHERE
D. HAVING
✅ Answer: C
Explanation:
WHERE filters rows based on conditions.
Question 7
Which SQL clause is used to sort query results?
A. ORDER BY
B. GROUP BY
C. WHERE
D. JOIN
✅ Answer: A
Explanation:
ORDER BY sorts results in ascending or descending order.
Question 8
Which SQL statement permanently removes a table and its structure?
A. DELETE
B. DROP
C. REMOVE
D. CLEAR
✅ Answer: B
Explanation:
DROP deletes the table and its structure completely.
Question 9
Which SQL operation is used to combine data from two related tables?
A. GROUP BY
B. JOIN
C. UNION
D. FILTER
✅ Answer: B
Explanation:
JOIN combines rows from multiple tables based on related columns.
Question 10
Which category of SQL statements is used to define or modify database structures?
A. DML
B. DQL
C. DDL
D. DCL
✅ Answer: C
Explanation:
DDL (Data Definition Language) includes CREATE, ALTER, and DROP.
✅ Quick Exam Takeaways
For DP-900, remember:
✔ SELECT → retrieve data
✔ INSERT → add data
✔ UPDATE → modify data
✔ DELETE → remove data
✔ CREATE / ALTER / DROP → manage structure
✔ WHERE → filter results
✔ ORDER BY → sort results
✔ JOIN → combine tables
✔ SQL categories: DDL, DML, DQL
Go to the DP-900 Exam Prep Hub main page.
The Data Community 