The following table has two attributes A and C where A is the primary key and C is the foreign key referencing A with on-delete cascade. A C —– 2 4 3 4 4 3 5 2 7 2 9 5 6 4 The set of all tuples that must be additionally deleted to preserve referential integrity when ...
SIKSHAPATH Latest Questions
Consider money is transferred from (1)account-A to account-B and (2) account-B to account-A. Which form a transaction will it be? Explain.
Create a package with procedure that shows the usage of the WHILE loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
List triggers that can be used for table auditing?
Create a trigger which will work before deletion in employee table and create a duplicate copy of the record in another table employee_backup.
List % ROWTYPE and TYPE RECORD along with their applications.