Specialilzed SQL database functions are brought up: What does coalesce do? When is a good time to use cross apply? Explain how you would use row_number() to remove duplicates from a table?
Database Designer Interview Questions
5,220 database designer interview questions shared by candidates
The most basic stuff I've been asked. Ever.
joins,rdbms,subquery,and other SQL topics
difference between Row num & Row id, deterministic and undeterministic functions
Technical questions related to the position. Not too difficult.
Experience in database administration
Star related practical situation solved in the past
They asked how I worked under pressure.
Most of the discussions during the interview were technical.
Will you be willing to support Postgres database? (although the position they are looking for is Oracle DBA)
Viewing 1721 - 1730 interview questions
See Interview Questions for Similar Jobs
Developer AdvisorDatabase AdminDatabase DeveloperPrincipal Database AdministratorSenior Database AdministratorDatabase AdministratorLead Database AdministratorProgrammer AnalystDevelopment SpecialistOracle Database AdministratorDatabase AdministrationSenior Sql Server Database AdministratorJunior Database AdministratorSystems AnalystSolutions DeveloperUi DeveloperDatabase Administrator IiSenior Sql Database Administrator