|
Question |
Rating |
View Answer |
|
Tell me the total process of eim?
|
|
View Answer |
|
If the entire disk is corrupted how will you and what are the steps to recover the database |
|
View Answer |
|
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 |
|
View Answer |
|
How to do the scheduled task/jobs in Unix platform |
|
View Answer |
|
You are regularly changing the package body part. How will you create or what will you do before creating that package |
|
View Answer |
|
How can you see the source code of the package |
|
View Answer |
|
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 |
|
View Answer |
|
In which situation whether peak time or off peak time you will execute the ANALYZE TABLE command. Why |
|
View Answer |
|
What is bulk SQL |
|
View Answer |
|
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 |
|
View Answer |
|
What is Testing Scenario ? What is scenario based testing? can u explain with an example ? |
|
View Answer |
|
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 |
|
View Answer |
|
What is spooling
|
|
View Answer |
|
What are the differences you have seen while installing Oracle on NT and Unix platform |
|
View Answer |
|
How do you increase the performance of %LIKE operator |
|
View Answer |
|
Shall we create procedures to fetch more than one record |
|
View Answer |
|
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 |
|
View Answer |
|
If the SQL * Plus hangs for a long time, what is the reason |
|
View Answer |
|
What are the differences between database designing and database modeling |
|
View Answer |
|
All the users are complaining that their application is hanging. How you will resolve this situation in OLTP |
|
View Answer |