| 1. How will you find fragmentation? How will you rectify it ? |
| 2. What is row chain and row migration? How will you find it and rectify it ? |
| 3. Why we should analyze a table?How to check if the table/index is analyzed? What is the command to gather stats/analyze ? |
4. What is difference between ?
- spfile/pfile
- pinned buffer/dirty buffer
- latch /enqueue
- LMT/DMT
- btree/bitmap
|
| 5. When and how to rebuild index ? |
| 6. What are the types of partitions ? Explain composite partitions ? |
| 7. What is different between system/hash partition ? |
| 8. what is partition PRUNING ? |
9.How will you check the following ?
- Table/index/view size
- Free space in database/tablespace
- Used space in database/tablespace
- How many indexes present for a table ? check indexes columns and its position ? on what function the index is created ?
- How many constraints are there in the table and on what columns ? What are the constraint types ?
|
| 10. What are the types of grants ? Difference between GRANT/ADMIN Option ? |
| 11. What is password verification function ? Steps to implement it ? |
| 12. Will discuss about profiles ? Try to learn Password Resources |
| 13.What is snapshot too old error ? |
| 14. What is different between lock and deadlock ? |
| 15. What is logical and physical backup ? hot and cold backup ? |
| 16. Explain the internals of hot backup in UMB ? |
| 17. Explain the steps to take hot backup in UMB ? |
