Write a query using EXISTS clause.
Database Manager Interview Questions
5,606 database manager interview questions shared by candidates
(again, paraphrasing) - How would you go back and look into a database to see when an (application ?) problem had happened.
what is the difference between a where clause and a having clause
How to solve a particular problem in database design and development. How do you deal with others if you feel you are right but people are not.
Are you a big picture person or someone who is concerned with the details?
Write the sql for deleting duplicate rows from a table without using temporary space.
The usual stuff - a number of technical questions, reasons for leaving then current job etc ...
When would you use an full outer join?
tell about import and export and sga
Q: In depth technical questions like PostgreSQL Architecture, Performance tuning, Features in postgresql 9.5, Explain 5-7 catalog tables, Explain 5-7 parameters in postgresql.conf
Viewing 241 - 250 interview questions