different kinds of joins, indexes, postgresql config parameters, session level performance tuning parameters, Postgresql backup and restore
Database Engineer Interview Questions
1,262 database engineer interview questions shared by candidates
If I was OK to take a trip to a Eastern European country for training.
What is Indexes? And there types. Difference between truncate and delete. Local and global temperory table. Recursive cte. Find 2nd highest salary. Find 2nd highest no in array .(Data structure) Difference between stored procedure and function. What are the types of stored function? Basically this questions depends upon person to person. Anything they can ask. But there main interest was in data structures algo and query optimisation. Although you have sound knowledge of Database you should know Data structure and query optimisation.
What is you professional experience in Data?
Talk about your experience with advanced database replication.
Various SQL Queries
Terminology
Joins, Aggregate functions, Stored procedues, functions,triggers,cursor,views, basics of sql
asked about primary key, foreign key
not many technically question just talk about yourself.
Viewing 1081 - 1090 interview questions