Oracle Programador interview questions

Explain how garbage collection works in Java. How can you optimize memory management in Java applications? Describe the differences between SQL and NoSQL databases. When would you choose one over the other? How does Oracle’s PL/SQL differ from standard SQL? Can you explain some advantages of PL/SQL? Write a function to find the second-largest element in an array. Explain ACID properties in database transactions. Why are they important? Describe the difference between clustered and non-clustered indexes in SQL. Explain REST vs. SOAP APIs. When would you choose one over the other?