Here are the top SQL interview questions to prepare for your next role.
1️⃣ What does "ACID" stand for in the context of SQL databases?
- A) Atomicity, Consistency, Isolation, Durability
- B) Access, Consistency, Isolation, Dataflow
- C) Auth, Caching, Isolation, Durability
- D) Access, Control, Isolation, Durability
2️⃣ Which wildcard character matches exactly one character in an SQL LIKE pattern?
- A) %
- B) _
- C) ?
- D) [a-z]
3️⃣ Which logical operator has the highest precedence in SQL: AND, OR, or NOT?
- A) AND
- B) None of them
- C) NOT
- D) OR
4️⃣ What does the SQL pattern LIKE '%' match?
- A) Any string except NULL
- B) Only non-empty strings
- C) Only empty strings
- D) Any string including NULL
5️⃣ Is the SQL BETWEEN operator inclusive or exclusive of its boundary values?
- A) Inclusive
- B) Not defined by SQL
- C) Exclusive
- D) Depends on the DBMS