Oracle Palcement Paper

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 ?

Leave a Reply

Your email address will not be published. Required fields are marked *

  ⁄  2  =  4