Database administrator interview questions
Relational internals, performance, backup and recovery, replication and NoSQL.
244 questions · 16 topics · 32 free answers
0 of 244 practised · 0 bookmarked · saved on this device
40 questions match
Database security and operations#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.
#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.
#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.
#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.
#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.
#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.
#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.
#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.
#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.
#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.