SQL Fundamentals Quiz Practice Questions - SQL

Question 1

What does SQL stand for?

Accepted Answer

A) Structured Query Language

Answer

B) Simple Query Language

Answer

C) Standard Query Language

Answer

D) Sequential Query Language

Question 2

Which SQL command is used to retrieve data from a database?

Accepted Answer

B) SELECT

Answer

A) GET

Answer

C) RETRIEVE

Answer

D) FIND

Question 3

What is the purpose of the WHERE clause in SQL?

Accepted Answer

B) To filter records based on a condition

Answer

A) To specify which columns to select

Answer

C) To sort the results

Answer

D) To group records together

Question 4

Which SQL statement is used to insert new data into a database table?

Accepted Answer

B) INSERT

Answer

A) ADD

Answer

C) CREATE

Answer

D) UPDATE

Question 5

What does the PRIMARY KEY constraint do in SQL?

Accepted Answer

D) Both A and B

Answer

A) Ensures all values in a column are unique

Answer

B) Links two tables together

Answer

C) Automatically increments values

Question 6

Which SQL function is used to count the number of rows in a table?

Accepted Answer

C) COUNT()

Answer

A) TOTAL()

Answer

B) SUM()

Answer

D) NUMBER()

Question 7

What is the correct SQL syntax to sort results in descending order?

Accepted Answer

B) ORDER BY column_name DESC

Answer

A) ORDER BY column_name ASC

Answer

C) SORT BY column_name DESC

Answer

D) SORT column_name DESC

Question 8

Which SQL keyword is used to combine rows from two or more tables?

Accepted Answer

C) JOIN

Answer

A) MERGE

Answer

B) COMBINE

Answer

D) UNION

Question 9

What does the GROUP BY clause do in SQL?

Accepted Answer

A) Groups rows that have the same values in specified columns

Answer

B) Combines multiple tables into one

Answer

C) Filters groups based on a condition

Answer

D) Sorts the results by multiple columns

Question 10

Which SQL statement is used to modify existing records in a table?

Accepted Answer

C) UPDATE

Answer

A) MODIFY

Answer

B) CHANGE

Answer

D) ALTER