Question 1: Which SQL statement is used to retrieve data from a database?

• GET
• SELECT
• FETCH
• RETRIEVE

Question 2: Which SQL clause is used to filter records?

• FILTER BY
• WHERE
• HAVING
• CONDITION

Question 3: Which SQL keyword is used to sort the result set?

• ORDER BY
• SORT BY
• ARRANGE
• GROUP BY

Question 4: Which of the following is used to insert new data into a table?

• ADD RECORD
• INSERT INTO
• CREATE ROW
• NEW DATA

Question 5: Which SQL statement is used to update existing records in a table?

• MODIFY
• UPDATE
• ALTER
• CHANGE

Question 6: Which function is used to count the number of rows in a table?

• TOTAL()
• SUM()
• COUNT()
• NUMBER()

Question 7: Which operator is used to search for a specified pattern in a column?

• MATCH
• SIMILAR
• LIKE
• PATTERN

Question 8: Which of the following finds the highest value in a column?

• MAX()
• HIGHEST()
• TOP()
• PEAK()

Question 9: Which keyword is used to eliminate duplicate rows from the result set?

• UNIQUE
• DISTINCT
• DIFFERENT
• REMOVE DUPLICATES

Question 10: Which function calculates the average value of a numeric column?

• MEAN()
• MEDIAN()
• AVG()
• AVERAGE()

Question 11: Which join returns all records from the left table and matched records from the right table?

• INNER JOIN
• LEFT JOIN
• RIGHT JOIN
• FULL JOIN

Question 12: Which join returns only the records that have matching values in both tables?

• INNER JOIN
• LEFT JOIN
• RIGHT JOIN
• CROSS JOIN

Question 13: What is used to create a relationship between two tables?

• PRIMARY KEY
• FOREIGN KEY
• LINK KEY
• RELATION KEY

Question 14: Which constraint ensures that a column cannot have NULL values?

• NOT NULLL
• REQUIRED
• MUST HAVE
• NO NULL

Question 15: Which SQL statement is used to create a new table?

• CREATE TABLE
• BUILD TABLE
• NEW TABLE
• MAKE TABLE

Question 16: Which SQL statement is used to delete a table from a database?

• REMOVE TABLE
• DELETE TABLE
• DROP TABLE
• ERASE TABLE

Question 17: Which constraint uniquely identifies each record in a table?

• UNIQUE KEY
• PRIMARY KEY
• IDENTIFIER
• MAIN KEY

Question 18: Which clause is used to group rows that have the same values?

• GROUP BY
• COLLECT BY
• COMBINE BY
• CATEGORIZE BY

Question 19: Which clause is used to filter groups in a GROUP BY clause?

• WHERE
• FILTER
• HAVING
• GROUP

Question 20: Which wildcard character represents zero or more characters in a LIKE pattern?

• _
• *
• %
• ?