DBA / Database

Difference between a procedure and a function.

What are window functions and how are they advantageous over aggregate functions?

Tell me about partitioning in Oracle: what types are there and how have you used it?

How to approach designing tables with hundreds of millions of records?

Properties of transactions (ACID)

What is the purpose of the PRAGMA AUTONOMOUS_TRANSACTION directive?

What is the default transaction isolation level in Oracle?

What are hints and which specific hints have you used?

How do you differentiate between system and user exceptions? What is the difference in their usage?

Can you give an example of when recursive CTEs are used?

Tell us about your experience with Oracle and your overall project experience.

What are LAG and LEAD?

What is BULK COLLECT and FORALL, and why do they work faster?

Tell about packages in Oracle: package specification and body, differences, can one be without the other?

What do you look at first when it comes to query planning? What bottlenecks can you see?

What types of indexes are there in Oracle and which ones have you used?

The difference between dynamic and static SQL, advantages and disadvantages of dynamic SQL

What other types of indexes do you know?

Explicit and implicit cursors — when are they used?

What type were subpartitions when range partitioning by month?