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,263 database engineer interview questions shared by candidates
Create an employee or bank schema
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.
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
Basic questions about last experience in database development. Nothing too complicated.
performance optimization scenarios
Mention specific technical experiences.
How do you deal with performance problems.
Python Coding Database Scenarios related to partioning, sharding, etc.
Viewing 971 - 980 interview questions