All questions related to Oracle database.
Database Engineer Interview Questions
1,263 database engineer interview questions shared by candidates
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?
SQL Questions, Coding, Performance.
which background processes are part of an Oracle instance
what you know for active directory
Stupid questoins were asked. Architectural differences were asked.
Viewing 641 - 650 interview questions