Cursor and refcursor. Joins Indexes
Ingeniero De Software Oracle Interview Questions
539 ingeniero de software oracle interview questions shared by candidates
They asked me several questions about Oracle APEX, including creating pages, Interactive Grids, Dynamic Actions, validations, and basic SQL/PL/SQL concepts.
Mostly asking on performance tuning
why version 1??what do you know about us?
General screening question
bind variables dynamic sql external table views mviews query to sum up pesudo columns virtual coulmns packages and advantages truncate delete exists in merge joins clustered index partitions interval partitioning puring partition loaders schema used in DB design diff between olap oltp scd collections bulk collect ref cursor unique key and primary key if base table is not present can we build the view corelated and subquery how to redirect o/p of the command in shell script
Which command is used in Unix to find 1 month older file?
performance tuning techniques and its use
Classic: describe possible execution plans for a join, their pros and cons, when each one is applicable ets.
Performance tuning of queries
Viewing 371 - 380 interview questions