1) In Oracle SQL, which keyword is used to add new rows to a table?

2) Which SQL function is used to find the highest value in a column?

3) Which SQL statement is used to delete permanently all records from a table?

4) Which SQL clause is used to specify the conditions for groups of rows?

5) In Oracle SQL, which data type would you use to store fixed-length character strings?

6) In Oracle SQL, which function is used to round a number to a specified decimal place?

7) Which SQL statement revokes previously granted permissions on a database object?

8) In Oracle SQL, which keyword joins tables based on a common column?

9) Which SQL function returns the number of rows in a table?

10) In Oracle SQL, which operator tests for the absence of a value?

11) Which SQL command is used to create a new table?

12) Which SQL clause is used to sort the result set in descending order?

13) Which SQL command is used to add a unique constraint to a column in a table?

14) In Oracle SQL, which command is used to make a transaction permanent and visible to other users?

15) Which Oracle tool is used for backup and recovery purposes?

16) What does PL/SQL stand for in Oracle?

17) Which Oracle feature is used to ensure data integrity by enforcing a set of rules on a table?

18) with’ statement in SQL is called?

19) Which one will provide consecutive ranking when duplicate values exist? Rank() Dense_Rank() Rownumber()

20) How do you retrieve the top N rows from a table in Oracle?