|
| Interview Questions – II !!!!!!! |
| Saturday, January 31, 2009 |
- What is dedicated and shared server?
- Have you installed Oracle on Linux?
- What is kernel parameter ,SHMMAX
- What is ipcs?
Temporary Segment
- What is sorting operation?
Performance Tunning
- Explain Plan
- Execution Plan
- Analyze
- Cursor sharing
- TKPROF
- Hard parse and Soft parse
- What is CBO?
- What is RBO?
- Fire one sql query which perform full table scan , how can you escape the full table scan?
Backgroung Processes
- What is LGWR, DBWR?
- Updated one record then what will happen and what will be recorded in redo log buffer?
Initialization Parameters
- what is process and processes parameter?
- FAST_START_MTTR_TARGET parameter
BackUp and Recovery
RMAN
- What is crosscheck command do?
- What is difference between expired backup and obsolete backup?
Recovery
- User delete table at 8 o'clock and user come at 10 o'clock say you to recover table.How could you proceed?
- How can you recover the system datafile?
- How can you recover the non-system datafiles? |
posted by Jaswinder Singh @ 1:41 AM   |
|
|
|
|
|
