IBM DB2 Database Admin Interview Questions.
- Name the command to find the fixpack of db2udb installed?
- Explain in brief the three steps to do a redirected restore ?
- Describe about Backup, recovery and installation ?
- Differentiate between creating buffer pool with immediate option and default option?
- What do you understand by star schema and Vertical portioned tables?
- What can you design snow flow schema?
- What do you mean by Sortheap ?
- Defines the maximum number of private memory pages to be used for private sorts, or the maximum number of shared memory pages to be used for shared sorts
- What are the utilities that do a sort?
- Explain the process of installing DB2 udb on a Linux/Unix server?
- For a newly created Database,where parameters have not been set, can you take an online back up?
- Explain what are the parameters that needs to be set to take an online back of the DB?
- Describe what is the difference between logretain and userexit?
- Can you import a file of extension WSF ?
- Can you load a file of extension WSF ?
- Describe you working experience in portioned DB?
- Differentiate between import and load in DB2?
- What do you mean by normalization? Have you been part of design?
- What do you mean by reorg ? What is runstats ?
- Explain in brief what are the activities you have done as a production support DBA ?
- If you create an index , will it sort the corresponding column in the database?
Related Posts
No comments :