Real Time Oracle database interview Questions - Free latest PlacementPapers, Interview Questions ....

sai6606 · 09-12-08, 04:48 PM

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. If you disable the index, can you use it or not?

3. What are the differences you have seen while installing Oracle on NT and Unix platform

4. 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

5. If the SQL * Plus hangs for a long time, what is the reason

6. Very next day on the prodction box It looks some procedres/packages got invlidated. What command I should give to know how many packges are invalidated. If suppose thousands are the packages invalidated then what command I should Issut to get then validated.

7. All the users are complaining that their application is hanging. How you will resolve this situation in OLTP
8. time or off peak time you will execute the ANALYZE TABLE command. W
In which situation whether peak time or off peak time you will execute the ANALYZE TABLE command. Why

9. How to do the scheduled task/jobs in Unix platform

10. Explain few Real time scenarios related to deadlock, flashback queries and autonomous transaction
11. The DBA has added STATE column to the CUSTOMERS table and has asked you to add acorresponding State item to the Customers block of the Orders form. You want to make it easier for order entry clerks to enter the correct state abbreviation. Most customers are located in five southeastern states, although on very rare occasions there will be customers from outside that area. You decide to implement a list item with five values for the State item and allow clerks to enter the state abbreviation dir

12. 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

13. If the entire disk is corrupted how will you and what are the steps to recover the database

14. What are the differences between database designing and database modeling

15. 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

16. What is bulk SQL

17. See, If the export dump is in one characterset and the target database which has to be imported is in another characterset how could we import that particular dumpfile into target database ?

18. How can you see the source code of the package

19. Need to create a short tax book from Nov-Jan.Corp book runs from Feb-Jan and Tax book from Nov-Oct.Only some retired Assets must be copied on the new tax book.what steps need to be necessiated...?

20. Shall we create procedures to fetch more than one record

22. How do you increase the performance of %LIKE operator

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

24. How to check to memory gap once the SGA is started in Restricted mode

09-12-08, 04:48 PM	#1 (permalink)
sai6606 Senior Member Join Date: Nov 2008 Posts: 311	Real Time Oracle database interview Questions 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. If you disable the index, can you use it or not? 3. What are the differences you have seen while installing Oracle on NT and Unix platform 4. 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 5. If the SQL * Plus hangs for a long time, what is the reason 6. Very next day on the prodction box It looks some procedres/packages got invlidated. What command I should give to know how many packges are invalidated. If suppose thousands are the packages invalidated then what command I should Issut to get then validated. 7. All the users are complaining that their application is hanging. How you will resolve this situation in OLTP 8. time or off peak time you will execute the ANALYZE TABLE command. W In which situation whether peak time or off peak time you will execute the ANALYZE TABLE command. Why 9. How to do the scheduled task/jobs in Unix platform 10. Explain few Real time scenarios related to deadlock, flashback queries and autonomous transaction 11. The DBA has added STATE column to the CUSTOMERS table and has asked you to add acorresponding State item to the Customers block of the Orders form. You want to make it easier for order entry clerks to enter the correct state abbreviation. Most customers are located in five southeastern states, although on very rare occasions there will be customers from outside that area. You decide to implement a list item with five values for the State item and allow clerks to enter the state abbreviation dir 12. 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 13. If the entire disk is corrupted how will you and what are the steps to recover the database 14. What are the differences between database designing and database modeling 15. 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 16. What is bulk SQL 17. See, If the export dump is in one characterset and the target database which has to be imported is in another characterset how could we import that particular dumpfile into target database ? 18. How can you see the source code of the package 19. Need to create a short tax book from Nov-Jan.Corp book runs from Feb-Jan and Tax book from Nov-Oct.Only some retired Assets must be copied on the new tax book.what steps need to be necessiated...? 20. Shall we create procedures to fetch more than one record 22. How do you increase the performance of %LIKE operator 23. You are regularly changing the package body part. How will you create or what will you do before creating that package 24. How to check to memory gap once the SGA is started in Restricted mode __________________ Sai Prepaid Mobile Recharge Online - Airtel, Vodafone, Idea, BSNL Cellone, Reliance Mobile, Tata Indicom.