How many types of cursors do we have and list some DBMS functions? What-s the difference between the indexes? What is a package and its parts? What is a partition? How can we partition tables?
Database Engineer Interview Questions
1,263 database engineer interview questions shared by candidates
How to improve on database performance?
different kinds of joins, indexes, postgresql config parameters, session level performance tuning parameters, Postgresql backup and restore
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
Viewing 1081 - 1090 interview questions