SQL Intermediate

🏷️ Basic

SQL 🆓 100% Free Certificate ❓ 15 Questions 8 minutes 4 Views

This test evaluates your intermediate knowledge of SQL, focusing on subqueries, advanced joins, grouping, aggregate functions, and data manipulation techniques. To enhance your skills, check out LearnSQL Intermediate Guide, explore SQL Tutorials on GeeksforGeeks, and dive into this intermediate SQL Training Video.

1 Which type of join returns all records when there is a match in either left or right table?

2 What does the GROUP BY clause do?

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

4 What is the purpose of the HAVING clause?

5 Which SQL statement is used to create an index on a table?

6 What is a subquery in SQL?

7 Which SQL constraint ensures that a column cannot have NULL values?

8 What does the COALESCE() function do?

9 Which SQL statement is used to create a view?

10 What is the purpose of the UNION operator?

11 Which SQL function is used to find the current date and time?

12 What is a stored procedure?

13 Which SQL statement is used to grant privileges to a user?

14 What is the purpose of the TRUNCATE TABLE statement?

15 Which SQL function is used to extract a part of a string?