Have you ever worked with transactions where multiple requests must be executed as a single unit or rolled back completely?
Middle+
183
DevOps
How to optimize a query with subqueries for better readability and performance?
Middle+
169
How are errors and exceptions handled inside a PL/SQL package?
Middle+
158
How does the interaction between RS-Bank components and PL/SQL occur — what is provided as input and what is returned as output?
Middle+
155
Tell about the architecture of Oracle — the memory structures SGA and PGA, why are they separated?
Middle+
155
How to optimize a query with a JOIN between a large table (millions of records) and a small table (100-200 records)?
Middle+
142
How to ensure high read and write speed for a high-load log table simultaneously?
Middle+
138
How do you act when you discover a slow query?
Middle+
133
Tell me about team organization, development process, version control, and staging environments.
Middle+
132
Explain what a hash function is and how it is used to transform data.
Middle+
131
Tell us about bulk operations in PL/SQL — how do they differ from regular operations?
Middle+
127
What standard Oracle system packages have you used in your work?
Middle+
124
Tell me about window functions — which ones have you used and how does the LEAD function work? How to avoid NULL in the LEAD result?
Middle+
124
How do cursors work in Oracle — explicit and implicit, and how do they differ?
Middle+
121
Tell me about indexes in Oracle — what types do you use and in what cases?
Middle+
109
What hints are used in Oracle to speed up queries?
Middle+
105
How does the order of execution of SQL queries with JOIN, WHERE, and GROUP BY occur?
Middle+
99
Do you use triggers? What types of triggers have been used and how do they work in conjunction with transactions?
Middle+
82