PostgreSQL foreign key
Junior Database Developer Interview Questions
5,218 junior database developer interview questions shared by candidates
What kind of locking you know in the databases
It's 1st Round of interview , video mode. Mostly they asked questions on SQL pointers,DB performance tuning,Scenario based questions, Handling large db issues, TDE encryption and few behavioural questions like why looking for change, what is expected salary, why don't you look for same change in your organisation.
How to resolve performance issues?
python memory management, shallow copy and deep copy
Instance recovery process?
Data guard basics ?
First round only I am not cleared
I wasn't asked this question but it came up. With an Internet facing application, it would make more sense to move from single node databases to clustered databases. A single node Oracle database has to be shutdown to perform upgrades and some patches. With an Oracle RAC cluster , rolling upgrades can be performed while still maintain 100 percent uptime. It seems management is favorable to this move but it just doesn't seem to be a priority.
Nothing was unexpected questions.
Viewing 3591 - 3600 interview questions