1. How will you estimate the space required by a non-clustered tables?
2. It is possible to use
1. How will you estimate the space required by a non-clustered tables?
2. It is possible to use raw devices as data files and what is the advantages over file. system files ?
3. What is a Control file ?
4. How to implement the multiple control files for an existing database ?
5. What is meant by Redo Log file mirrorring ? How it can be achieved?
6. What is advantage of having disk shadowing/ Mirroring ?
7. What is use of Rollback Segments In Database ?
8. What is a Rollback segment entry ?
9. What is hit ratio ?
10. When will be a segment released ?
11. What are disadvanteges of having raw devices ?
12. List the factors that can affect the accuracy of the estimations ?
13. What is user Account in Oracle database ?
14. How will you enforce security using stored procedures ?
15. What are the dictionary tables used to monitor a database spaces ?
16. What are the responsibilities of a Database Administrator ?
17. What are the roles and user accounts created automatically with the database ?
18. What are the database administrators utilities avaliable ?
19. What are the minimum parameters should exist in the parameter file (init.ora) ?
20. What is a trace file and how is it created ?
21. What are roles ? How can we implement roles ?
22. What are the steps to switch a database’s archiving mode between NO ARCHIVELOG and ARCHIVELOG mode ?
23. How can you enable automatic archiving ?
24. How can we specify the Archived log file name format and destination ?
25. What is the use of ANALYZE command ?
