DB2 Database Administrator Interview Questions and Answers

Offline reorg requires database to be offline, while online reorg can be done while database is still accessible.

• Offline reorg requires exclusive access to the database, while online reorg can be done concurrently with database operations.

• Offline reorg is typically faster as it doesn't have to deal with concurrent transactions, while online reorg may take longer but allows for continuous access.

• Offline reorg is usually used for larger maintenance tasks, while online reorg is ...read more

My expected CTC is negotiable based on the job responsibilities and market standards.

• My expected CTC is based on my experience, skills, and the job requirements.

• I am open to discussing the salary range during the interview process.

• I am looking for a competitive salary package that aligns with industry standards.

• I am flexible and willing to consider other benefits in addition to the salary.

Different types of backups include full, incremental, differential, and snapshot backups.

• Full backup: backs up all data in the database

• Incremental backup: backs up only the data that has changed since the last backup

• Differential backup: backs up all data that has changed since the last full backup

• Snapshot backup: creates a point-in-time copy of the database