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 ? |