W When I interviewed developers to extend my team I asked them to evaluate themselves on scale 0-10. Then I asked them following questions. At the end I compare my notes and correct answers with their self evaluation. At the end I am not looking for perfect answers, but for the attitude and how do you handle yourself when you dont know the correct answers. What is your preferred PL/SQL editor + current Oracle version? How do you get number of rows affected by DML query? Name all Oracle table constraint types. Describe syntax for adding foreign key to table. Describe differences between SQL and PL/SQL data types. Describe advantages of packages over procedures. What is difference between DROP, DELETE and TRUNCATE? What is a materialized view? What is a CROSS JOIN? What are the other types of joins? How do you select the 2nd recent row from a table? How do you traverse trees? How do you recompile invalid objects? How do you restore dropped table?
Mainly APEX, sometimes SQL, PL/SQL, clean code and certifications