SQL MCQs - Class 12

What is the purpose of an INNER JOIN in SQL?

• To update records in a table.

• To create a new table from existing tables.

• To delete records from a table.

• To retrieve matching records from two or more tables.

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

• MAX()

• COUNT()

• AVG()

• SUM()

What data type would you use for a column that stores dates?

• INTEGER

• DATE or DATETIME

• BOOLEAN

• STRING

How do you select all columns from a table named 'employees'?

• GET * FROM employees;

• FETCH * FROM employees;

• SELECT * FROM employees;

• SELECT ALL FROM employees;

What is the function of the WHERE clause in an SQL statement?

• To filter records based on specified conditions.

• To create new records in the database.

• To sort records in ascending order.

• To join multiple tables together.

What type of JOIN returns all records from the left table and matched records from the right table?

• FULL OUTER JOIN

• LEFT JOIN

• RIGHT JOIN

• INNER JOIN

Which SQL function is used to find the maximum value in a column?

• COUNT()

• MIN()

• SUM()

• MAX()

What is the default data type for a column that stores text in SQL?

• CHAR

• TEXT

• STRING

• VARCHAR

How do you filter records in SQL using a specific condition?

• Utilize the JOIN clause to combine multiple tables.

• Apply the GROUP BY clause to summarize data.

• Use the WHERE clause to filter records based on a specific condition.

• Use the SELECT statement to retrieve all records.

What is the purpose of the GROUP BY clause in SQL?

• To group rows that have the same values in specified columns and perform aggregate functions on them.

• To sort rows in ascending or descending order.

• To create new tables from existing data.

• To filter rows based on specific conditions.