What is a view? What are the advantages and disadvantages of views in a database? What is the difference between Cluster and Non cluster Index? What are properties of a transaction?
Database Engineer Interview Questions
1,262 database engineer interview questions shared by candidates
To write more advanced SQL DB statement, for which you have to train well your SQL knowledge (don't rely only on your daily work - it won't be sufficient). There was a task to implement data structure in Java (from what I remember was BlockingQueue), for which I didn't have the time and a bunch of small other easy java related questions.
PL/SQL Challenges, Solutions, Performance Tuning.
Basic questions about last experience in database development. Nothing too complicated.
performance optimization scenarios
Explain isolation levels, indexes, joins, physical joins, how to handle server level issue, Problems to solve on screen share, why you want to change old job
How do you deal with performance problems.
Mention specific technical experiences.
Python Coding Database Scenarios related to partioning, sharding, etc.
About yourself Visual Analysis Database Queries
Viewing 971 - 980 interview questions