Plsql collections, pragma autonomous transaction, exception init, explain plans, nested loop hash join and merge join
Junior Database Developer Interview Questions
4,184 junior database developer interview questions shared by candidates
all about job profiles
They did not drill to the lowest level but they wanted to see how well I am aware of the concepts and to what level I have worked on. Most of the questions were basics about DB architecture. Backup and recovery, Unix, Shell scripting.
what is MVCC in PostgreSQL ? Performance Tuning & Auto vacuum in Postgres.
Asked About Database Internal Architecture. Asked About DB Performance Tuning
They mostly asked few DSA questions, some real-world based OOPs problems.
What is the best that you can give?
RAC specific most of the questions and performance tuning.
Rman backup strategy How to export schema from source to target with different schema name at target. how will you act on performance issue. ASM components restoring a DB Dataguard related shell scripting Diskgroup space scenerio patch and upgrade
Performance tuning on database level and query level
Viewing 4131 - 4140 interview questions