⟩ Explain How image_items can be populate to field in forms 4.0?
A fetch from a long raw database column PL/Sql assignment to executing the read_image_file built_in procedure to get an image from the file system.
A fetch from a long raw database column PL/Sql assignment to executing the read_image_file built_in procedure to get an image from the file system.
Schema A has some objects and created one procedure and granted to Schema B. Schema B has the same objects like schema A. Schema B executed the procedure like inserting some records. In this case where the data will be stored whether in Schema A or Schema B?
Explain If the entire disk is corrupted how will you and what are the steps to recover the database?
If All the users are complaining that their application is hanging. How we will resolve this situation in OLTP?
Explain the total process of eim?
Explain How do we increase the performance of %LIKE operator?
Explain If the SQL * Plus hangs for a long time, what is the reason?
Tell us In which situation whether peak time or off peak time we will execute the ANALYZE TABLE command and Why?
Explain What is bulk SQL?
Explain What is mutated trigger, is it the problem of locks. In single user mode we got mutated error, as a DBA how you will resolve it?
Explain How to do the scheduled task/jobs in Unix platform?