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
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
Latest Answer: SELECT TEXT FROM USER_SOURCE/ALL_SOURCE/DBA_SOURCEWHERE NAME= AND TYPE='PACKAGE';HERE THE TYPE MAY BE PACKAGE,PROCEDURE,.... ...
If the large table contains thousands of records and the application is accessing 35% of the table which method to use: index searching or full table scan
Latest Answer: when we try access a table which is locked or manipulated by another user ...
Latest Answer: The wildcard char % can be placed in one of three ways: %searchwordhere% searchwordhere% %searchwordhere The searchwordhere% is the fastest because it can use an index if one is specified on that column. The other two ...
You are regularly changing the package body part. How will you create or what will you do before creating that package
All the users are complaining that their application is hanging. How you will resolve this situation in OLTP
In which situation whether peak time or off peak time you will execute the ANALYZE TABLE command. Why
Latest Answer: The two available options are1. CRONTAB2. AT (One time scheduling) ...
View page << Previous 1 [2] 3 Next >>
Go Top
