Oracle Scenarios Interview Questions

 
1.
Explain 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?
2.
We are regularly changing the package body part. How will we create or what will we do before creating that package?
3.
Explain What is spooling?
4.
Can we create procedures to fetch more than one record?
5.
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?
6.
Explain If the entire disk is corrupted how will you and what are the steps to recover the database?
7.
If All the users are complaining that their application is hanging. How we will resolve this situation in OLTP?
8.
Explain the total process of eim?
9.
Explain How do we increase the performance of %LIKE operator?
10.
Explain If the SQL * Plus hangs for a long time, what is the reason?
11.
Tell us In which situation whether peak time or off peak time we will execute the ANALYZE TABLE command and Why?
12.
Explain What is bulk SQL?
13.
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?
14.
Explain How to do the scheduled task/jobs in Unix platform?
15.
Explain the Dual table. 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 and Why?
16.
Explain What are the differences you have seen while installing Oracle on NT and Unix platform?
17.
Explain What are the differences between database designing and database modeling?
18.
Explain 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?
19.
Explain How can we see the source code of the package?
20.
Explain What is Testing Scenario? What is scenario based testing? can u explain with an example?
21.
Explain about the oracle disaster recovery scenarios?
22.
Explain 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?
23.
We are regularly changing the package body part. How will we create or what will we do before creating that package?
24.
Explain What is spooling?
25.
Can we create procedures to fetch more than one record?
26.
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?
27.
Explain If the entire disk is corrupted how will you and what are the steps to recover the database?
28.
If All the users are complaining that their application is hanging. How we will resolve this situation in OLTP?
29.
Explain the total process of eim?
30.
Explain How do we increase the performance of %LIKE operator?
31.
Explain If the SQL * Plus hangs for a long time, what is the reason?
32.
Tell us In which situation whether peak time or off peak time we will execute the ANALYZE TABLE command and Why?
33.
Explain What is bulk SQL?
34.
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?
35.
Explain How to do the scheduled task/jobs in Unix platform?
36.
Explain the Dual table. 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 and Why?
37.
Explain What are the differences you have seen while installing Oracle on NT and Unix platform?
38.
Explain What are the differences between database designing and database modeling?
39.
Explain 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?
40.
Explain How can we see the source code of the package?
41.
Explain What is Testing Scenario? What is scenario based testing? can u explain with an example?
42.
Explain about the oracle disaster recovery scenarios?
43.
Explain 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?
44.
We are regularly changing the package body part. How will we create or what will we do before creating that package?
45.
Explain What is spooling?
46.
Can we create procedures to fetch more than one record?
47.
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?
48.
Explain If the entire disk is corrupted how will you and what are the steps to recover the database?
49.
If All the users are complaining that their application is hanging. How we will resolve this situation in OLTP?
50.
Explain the total process of eim?
51.
Explain How do we increase the performance of %LIKE operator?
52.
Explain If the SQL * Plus hangs for a long time, what is the reason?
53.
Tell us In which situation whether peak time or off peak time we will execute the ANALYZE TABLE command and Why?
54.
Explain What is bulk SQL?
55.
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?
56.
Explain How to do the scheduled task/jobs in Unix platform?
57.
Explain the Dual table. 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 and Why?
58.
Explain What are the differences you have seen while installing Oracle on NT and Unix platform?
59.
Explain What are the differences between database designing and database modeling?
60.
Explain 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?
61.
Explain How can we see the source code of the package?
62.
Explain What is Testing Scenario? What is scenario based testing? can u explain with an example?
63.
Explain about the oracle disaster recovery scenarios?
64.
Explain 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?
65.
We are regularly changing the package body part. How will we create or what will we do before creating that package?
66.
Explain What is spooling?
67.
Can we create procedures to fetch more than one record?
68.
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?
69.
Explain If the entire disk is corrupted how will you and what are the steps to recover the database?
70.
If All the users are complaining that their application is hanging. How we will resolve this situation in OLTP?
71.
Explain the total process of eim?
72.
Explain How do we increase the performance of %LIKE operator?
73.
Explain If the SQL * Plus hangs for a long time, what is the reason?
74.
Tell us In which situation whether peak time or off peak time we will execute the ANALYZE TABLE command and Why?
75.
Explain What is bulk SQL?
76.
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?
77.
Explain How to do the scheduled task/jobs in Unix platform?
78.
Explain the Dual table. 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 and Why?
79.
Explain What are the differences you have seen while installing Oracle on NT and Unix platform?
80.
Explain What are the differences between database designing and database modeling?
81.
Explain 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?
82.
Explain How can we see the source code of the package?
83.
Explain What is Testing Scenario? What is scenario based testing? can u explain with an example?
84.
Explain about the oracle disaster recovery scenarios?