Oracle Member Technical Staff interview questions

Technical Interview 1: I was asked about what I had done recently. I explained to the interviewer about the Cloud course that I had done. He asked me a few questions about one of my project which was on networking. As he also had been working on a similar product as the project mentioned in my resume, he asked me a few questions about cipher keys, man in the middle attack and some basic security concepts I knew about. He asked this coding question: Print the string after removing all its duplicates. (It was supposed to be case-insensitive, i.e. K and k meant the same) Technical Interview 2: I was asked to elaborate on my internship project. I was asked some questions on networking such as, difference between GET and POST, port numbers of some important ports. Next I was asked this coding question: Print the second largest element in the array in a single iteration. I was asked this standard puzzle:2 eggs and 100 floors, find out at what floor the egg actually breaks. Technical Interview 3: The interviewer asked me how good I was at DBMS. Then she asked me the following queries: If you are given Employee and Department tables, how will you find out the name of the department which has 0 employees. What is a view? What happens when I want to insert into a view? Does it get reflected in the actual table? What are the conditions under which the changes will be reflected? Explain the type of Joins She asked me to explain the project which was mentioned in my resume, in which I used DBMS and Java. She asked me to write some complex queries written in my project. She asked me to explain the ER diagram, the relations I used.