Oracle DBA Questions asked by Expert

1) 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?

2) 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?

3) In exception handling we have some NOT_FOUND and OTHERS. In inner layer we have some NOT_FOUND and OTHERS. While executing which one whether outer layer or inner layer will check first?

4) Dual table explain. Is any data internally storing in dual table. Lot of users are accessing select sysdate from dual and they getting some millisecond differences. If we execute SELECT SYSDATE FROM EMP; what error will we get. Why?

5) How can you see the source code of the package?

6) You are regularly changing the package body part. How will you create or what will you do before creating that package?

7) How do you increase the performance of %LIKE operator?

8) Shall we create procedures to fetch more than one record?

9) If the SQL * Plus hangs for a long time, what is the reason?

10) All the users are complaining that their application is hanging. How you will resolve this situation in OLTP?

11) How to check to memory gap once the SGA is started in Restricted mode?

12) In which situation whether peak time or off peak time you will execute the ANALYZE TABLE command. Why?

13) 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?

14) What are the differences between database designing and database modeling?

15) What are the differences you have seen while installing Oracle on NT and Unix platform?

16) How to do the scheduled task/jobs in Unix platform?

17) What is bulk SQL?

18) If the entire disk is corrupted how will you and what are the steps to recover the database?

Try to answer to Question in the comments and check your ability