Given the explanation of the project and the system we work on, how do you think you fit in this role?
Database Programmer Interview Questions
785 database programmer interview questions shared by candidates
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?
Triggers, Collections, Cusrsors, Packages, Procedures, Indexes
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
Viewing 671 - 680 interview questions