Skip to content

Database administrator interview questions

Relational internals, performance, backup and recovery, replication and NoSQL.

244 questions · 16 topics · 32 free answers

Database Administrator roadmap4 stages from basics to interview-ready. Learn the gaps, then come back and practise.

0 of 244 practised · 0 bookmarked · saved on this device

40 questions match

Database security and operations
  1. #1How do you secure a production database?EasyConceptDatabase security and operations Pro answer

    This answer is part of Pro

    10 of 244 Database administrator answers are free. A Pro pass opens the rest, including hands-on task steps.

  2. #2What is SQL injection from a DBA's point of view?EasyConceptDatabase security and operations Pro answer

    This answer is part of Pro

    10 of 244 Database administrator answers are free. A Pro pass opens the rest, including hands-on task steps.

  3. #3What is transparent data encryption and what does it not protect against?MediumConceptDatabase security and operations Pro answer

    This answer is part of Pro

    10 of 244 Database administrator answers are free. A Pro pass opens the rest, including hands-on task steps.

  4. #4How do you audit database activity?MediumConceptDatabase security and operations Pro answer

    This answer is part of Pro

    10 of 244 Database administrator answers are free. A Pro pass opens the rest, including hands-on task steps.

  5. #5How do you mask or protect sensitive data in non-production copies?MediumConceptDatabase security and operations Pro answer

    This answer is part of Pro

    10 of 244 Database administrator answers are free. A Pro pass opens the rest, including hands-on task steps.

  6. #6How do you handle schema changes in a controlled way?MediumConceptDatabase security and operations Pro answer

    This answer is part of Pro

    10 of 244 Database administrator answers are free. A Pro pass opens the rest, including hands-on task steps.

  7. #7What are sequences and identity columns and what problems do gaps cause?MediumConceptDatabase security and operations Pro answer

    This answer is part of Pro

    10 of 244 Database administrator answers are free. A Pro pass opens the rest, including hands-on task steps.

  8. #8What is the difference between a temp table, a CTE and a table variable?MediumConceptDatabase security and operations Pro answer

    This answer is part of Pro

    10 of 244 Database administrator answers are free. A Pro pass opens the rest, including hands-on task steps.

  9. #9What are common causes of table bloat in PostgreSQL?MediumConceptDatabase security and operations Pro answer

    This answer is part of Pro

    10 of 244 Database administrator answers are free. A Pro pass opens the rest, including hands-on task steps.

  10. #10What is transaction ID wraparound in PostgreSQL?MediumConceptDatabase security and operations Pro answer

    This answer is part of Pro

    10 of 244 Database administrator answers are free. A Pro pass opens the rest, including hands-on task steps.

Hunting for a Database administrator role too? See open Database administrator jobs.