⟩ What is Full load & Incremental or Refresh load?
Full Load: completely erasing the contents of one or more tables and reloading with fresh data.
Incremental Load: applying ongoing changes to one or more tables based on a predefined schedule.
Full Load: completely erasing the contents of one or more tables and reloading with fresh data.
Incremental Load: applying ongoing changes to one or more tables based on a predefined schedule.
Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger? Why?
What are two virtual tables available during database trigger execution?
What happens if a procedure that updates a column of table X is called in a database trigger of the same table?
Write the order of precedence for validation of a column in a table? I. done using Database triggers. ii. done using Integarity Constraints
What is an Exception? What are types of Exception?
What is Pragma EXECPTION_INIT? Explain the usage?
What is Raise_application_error?
What are the return values of functions SQLCODE and SQLERRM?
Where the Pre_defined_exceptions are stored?
What is an oracle stored procedure?