Mainly about work experience and typical DB development questions (transactions, indexes, partitioning, etc.)
Sr Database Engineer Interview Questions
177 sr database engineer interview questions shared by candidates
Why Morningstar?
Tell us how you would construct an Employee table. What fields? Select employees from the employee table. How do we know what their current role is (job table)? Select employees who do not have not been assigned a job. How would you load an employee list through SSIS?
More on experiences and practical scenarios rather than Q&A
1. questions on database components like sga,pga, bg processes ,undo ,redo and their internals. 2. RAC architecture and how it works. 3. postgres concepts and its internals 4. Some basic questions on python scripting
Stupid questoins were asked. Architectural differences were asked.
How does MySQL replication work? What tuning variables affect MySQL? How do you determine why a SQL query is taking a long time to run? How do you skip major version upgrades with as little downtime as possible? What status variables tell you if the buffer pool is thrashing?
Basic PLSQL use cases like user defined exception, procedures and functions. Intermediate level sql queries
All related to the profile Optimization procs complex queries partition by and all
Was quizzed mostly on my RDBMS concepts and scripting knowledge.
Viewing 91 - 100 interview questions