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
244 questions
#1What is a foreign key and what do cascading actions do?EasyConceptRelational fundamentals 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 a view and a materialised view?EasyConceptRelational fundamentals 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 a stored procedure and how does it differ from a function?EasyConceptRelational fundamentals 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.
#4What is a trigger and what are the risks of using them?EasyConceptRelational fundamentals 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.
#5What is the difference between a clustered and a heap table?MediumConceptRelational fundamentals 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.
#6What are isolation levels and which is the default in MySQL InnoDB and PostgreSQL?MediumConceptRelational fundamentals 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 is the difference between logical and physical backups?MediumConceptRelational fundamentals 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 a write-ahead log?MediumConceptRelational fundamentals 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 is the difference between locks and latches?MediumConceptRelational fundamentals 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 are database partitioning and sharding?MediumConceptRelational fundamentals 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.