1) What is a transaction in SQL?

2) Which statement is used to commit a transaction in Oracle SQL?

3) What is PL/SQL?

4) Which PL/SQL block is used to define a function?

5) What is a materialized view in Oracle?

6) What is the purpose of the DBMS_JOB package in Oracle?

7) What is a partitioned table in Oracle?

8) What is the purpose of the RAC (Real Application Clusters) feature in Oracle?

9) What is a materialized view refresh in Oracle?

10) What is the purpose of the Oracle Data Miner (ODM) tool?

11) Which Oracle tool is used to analyze SQL statement performance?

12) What is the purpose of the EXPLAIN PLAN in Oracle?

13) What is a role in Oracle?

14) Which Oracle tool is used to manage database security?

15) What is a data warehouse?

16) What is a fact table in a data warehouse?

17) What is a materialized view refresh method in Oracle?

18) What is the purpose of the Oracle Partitioning feature?

19) What is the purpose of the AUTOTRACE feature in Oracle?

20) What is the purpose of the SQL Tuning Advisor in Oracle?