Graph search problems with multiple data structures and BFS
Database Engineer Interview Questions
1,263 database engineer interview questions shared by candidates
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?
day to day dB work question s!!
Background info on myself and work experience, some softball SQL questions, a lot about how much data I had worked with in the past
All questions related to Oracle database.
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
Salary queries CTE vs Table variable Vs Temp table Manager hierarchy Where vs Having How to remove duplicate records - Different ways? Indexing - Can we add primary constraint and cluster index on different columns? Index seek, table scan, key lookup, row look up, Views - can we Update, types, Indexed view, materialized view Department-wise highest salaries - Queries How will you design car showroom maintenance DB? Image datatypes Window functions Second round - Indexes Projects you worked on which procedures you have worked on, and what logic have you written? Temp tables, CTE, table variable Cursor Views Integer pattern Functions and stored procedures Nested stored procedure Query optimization How it works Why cursors should not be used. Cursor ka workaround Wild cards and ways of implementation without using like operator. Filter vowels from string, count of vowel. The composite index, Index seek and scan, SQL injection Linked server
Do you have any questions regarding the interview
Most recent issue handled; how it was investigated and resolved end to end?
Viewing 641 - 650 interview questions