Not a SINGLE
Database Programmer Interview Questions
785 database programmer interview questions shared by candidates
Performance tuning ,Procedure, function, Package, Queries, trigger
Cursors
In a SELECT statement over multiple tables, does moving WHERE conditions into the JOIN clause make the SELECT statement faster?
what is the diff between the primary key and the unique key?
1. Introduce yourself 2. What are your strengths and weakness 3. Why do you choose this role 4. How do you justify this position if we hire you 5. How you can automate the file processing 6. Tell me couple of scenarios where you have used the triggers 7. Write the general syntax for procedure 8. How do you implement equi-width histograms 9. Usage of aggregate functions 10. CASE vs DECODE with examples
questions related to the topics cursors,triggers,packages,sql functions,views and materialized views exceptions and other few questions
Plsql performane tuning techs
About my prior experience and work related basic knowledge.
Was asked a technical question about an actual issue they had and how to figure out what went wrong.
Viewing 101 - 110 interview questions