ORACLE SQL- PL/SQL Question Set 1

1. Why SQL is called a ‘Query Language?’ define.
2. What is ACID property in a database?
3. Why Excel is not a database?
4. What are the three basic sections of a PL/SQL block?
5. What is a trigger?
6. What are the uses of triggers?
7. What are the different datatypes available in PL/SQL?
8. What is a difference between Commit, Rollback and Savepoint?

1. What are the advantages of COMMIT and ROLLBACK statements?

10. What is a difference between Truncate and Delete?
11. What is a main difference between CHAR and VARCHAR2?
12. Define
    1. UNIQUE KEY
    2. PRIMARY KEY
    3. FOREIGN KEY
13. What are Views and why they are used?
14. What are joins in SQL?
15. What are Constraints?
16. Define with Example
    1. DML Statement
    2. DDL Statement
    3. TCL Statement
    4. DCL Statement
17. Define Order by Clause
18. What is Group by clause
19. Define any 3 Group functions with proper example.
20. What is table?
21. What is server? Example.
22. Define ROWNUM operator with example
23. What is database?
24. Define the difference between the DBMS and RDBMS
25. What is normalization?
26. What is a query?
27. Define Operator.
28. What is the difference between Primary key and Not Null?
29. What is the difference between Primary key and Not Null?
30. What is sub query? Define its usage.
31. What is cursor?
32. How many types of cursor in RDBMS?
33. Define the difference between implicit and explicit cursor.
34. What is trigger?
35. What are the difference between function and procedure?
36. What is data type?
37. What is Savepoint? Differ it with commit.
38. Is It Possible To Label A Loop? If Yes, Then What Is Its Benefit?

Thanks reading.