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

2) What is the purpose of the HAVING clause in SQL?

3) What is a join in SQL used for?

4) How do you join two tables in SQL using the INNER JOIN clause?

5) What is a subquery in SQL?

6) What happens if you leave off the ELSE clause in an SQL CASE statement and not conditions are met?

7) The ‘LEAD & LAG’ functions belong to which categories in SQL?

8) The ‘COUNT’ keyword belongs to which categories in SQL?

9) Views are also known as

10) How many Primary keys can have in a table?

11) Which of the following is not a DDL command?

12) Which of the following is NOT a VALID Data type in PL/SQL?

13) Which of the following is not a grouping function?

14) Where do you declare an explicit cursor in the PL/SQL language?

15) What is a subquery in SQL?

16) What is the result of this statement? SELECT FLOOR (-1234.321) from dual;

17) What is the result of this query? SELECT 1 / 2 AS Result from dual;

18) What is the result of this query? SELECT 'abc\def' AS Result from dual;

19) The result of a CROSS JOIN between a table with 4 rows, and one with 5 rows, will give with _ rows.

20) To remove all of the content from the students table but keep the structure, which statement should you use?