When addressing a table some dimension key must reflect the need for a record to get extracted. Mostly it will be from time dimension (e.g. date >= 1st of current mth) or a transaction flag (e.g. Order Invoiced Stat). Foolproof would be adding an archive flag to record which gets reset when record changes.
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?
What is a cursor for loop?
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
