⟩ Explain What are the main types of TRIGGERS?
1)Block processing trigger
2)Interface event trigger
3)Message-handling trigger
4)Validation trigger
5)Navigation trigger
6)Trancation trigger
7)Query_time trigger
1)Block processing trigger
2)Interface event trigger
3)Message-handling trigger
4)Validation trigger
5)Navigation trigger
6)Trancation trigger
7)Query_time trigger
Explain What is a Package?
Explain What is Database Trigger?
Explain What are the uses of Oracle Rollback Segment?
Explain What is a Procedure?
Explain What is an Oracle Data Block?
Explain What are the differences between Database Trigger and Integrity constraints?
Explain What are the different types of PL/SQL program units that can be defined and stored in ORACLE database?
Explain If the large table contains thousands of records and the application is accessing 35% of the table which method to use index searching or full table scan?
We are regularly changing the package body part. How will we create or what will we do before creating that package?
Explain What is spooling?