What should a Java developer know about Oracle?

Question

Oracle

In many descriptions of Senior Java Developer vacancies, knowledge of this DBMS is a necessary item, however, as far as I understand, you can devote your whole life to studying it. Dear community, tell me, please, what, from your point of view, does a Java developer need to know about the Oracle database, working in the enterprise sector?
PS Can anyone recommend courses / lectures / literature?

Answer 1

A certified Java developer had to pass the SQL Fundamentals exam (1Z0 051), which covers 90% of Oracle's SQL implementation features. It has quite specific constructions that are not found in other databases.
It's also nice to know about PL/SQL, why it's needed, what are the pros/cons compared to Java.
Of course, it doesn't hurt to read Oracle Database Concepts. And Tom Kite for extracurricular reading :) We
have already said about the plan and statistics.

Answer 2

Well, at least you need to know how to organize a connection from your application. How to get data. Etc. Specifically about Oracle, it is useful to know what a query plan is, and why statistics are needed.