Compare the deferred-modification and immediate-modification version of the log-based recovery schemes, in terms of ease of implementation and overhead cost.
SIKSHAPATH Latest Questions
Create a row trigger which ensures that whenever salary is updated in the emp table, then some message is displayed to the user and if new salary is lesser than old salary display the difference between both the salaries.
Create a package which contains function to ask the user to enter the student’s marks and determine the GRADE according to the following criteria. >90 A >80AND 70AND 60 AND<70 D <60 F
Create a package which contains function to ask the user to enter the student’s marks and determine the GRADE according to the following criteria. >90 A >80AND <90 B >70AND <80 C >60 AND<70 D <60 F
Create a trigger which will work before deletion in employee table and print a message “Deletion started”
What is the operation when trigger is not executing ?