Oracle DBA Interview Questions by Expert 2

1. What are the different tablespaces in database?

2. How to drop the index?

3. How to drop the column in a table?

4. How to take the export and import of users level?

5. What are the new parameters in imp?

6. If the application is running very slow? At what points you need
to go about the database in order to improve the performance?

7. Specifically on Application Tuning?

8. What are the possible backups are there?

9. How to see the free spaces information in sun solaris?

10. How to find the running processes?

11. How to clone the database?

12. What is Oracle database instance?

13. What is Oracle database?

14. Name all the background processes?

15. What are LGWR, SMON, PMON, DBWR?
Explain in details?

16. What exactly happens when a user issues an UPDATE statement?

17. What are the various hit ratios in SGA? How to monitor?

18. What files form a database? Explain about control files?

19. When an UPDATE statement is very slow, what will you do?

20. What privileges are needed to connect to a database?

21. How to monitor rollback segment contention?

22. When “SNAPSHOT TOO OLD” error will occur?

23. What is the difference between logical backup and physical backup?

24. How to export Oracle tablespace?

25. What is DIRECT=Y option in export?

26. Pipe command syntax

27. How to take hot backup?

28. What third party tools, you used for sql tuning?

29. What is TRANSACTION TABLE in rollback segment?

30. What is the simplest way to collect database statistics?

31. How to generate trace file? tkprof options?

32. What is the difference between rule based optimization and
cost based optimization?

32. When will you use NESTED LOOP join and SORT MERGE join?

33. What is the difference between CHAINED ROW and MIGRATED ROW?
Rollback segment contention? How do you solve?

34. What for OPTIMAL (rollback segment) size? And tell me the syntax
how will you define it?

35. Describe the exp utility parameters andsyntax?

36. Describe the imp utility parameters and syntax?

37. Backup strategy that you followed for different clients?

38. What are the different export options?

39. How to use pipe commands in UNIX during export?

40. How to find the running processes?

41. Have you ever used any database monitoring tools?

42. If the application is running very slow? At what points you
need to go about the database in order to improve the performance?

43. How to solve the contention on Rollback segments?

44. What are the parameters you need to look at in output file (tkprof)?
How to identify that the given SQL statement is bad by looking into the
tkprof output file? How to use pipe commands in UNIX during export?

45. Tell me about your technical background?

46. What were all the problems you have faced?

47. What are the projects that you have so far involved?