Oracle Interview Experience for Applications Engineer | On-Campus

**Round 1: **Online test was conducted. It had 4 sections

1. Verbal
2. Aptitude
3. Programming skills (flowcharts etc.)
4. Computer science concepts (DBMS, OS, questions on trees )

44 students were shortlisted for further process.

**Round 2 (Technical Interview): **Started at 10:45 AM. The whole process happened on ZOOM, the host assigned us to interview rooms and waiting rooms. This level of interview only focused on the most basic questions, they just wanted to know if we can code. A link was shared with an online code editor, and I was asked to share my screen and code.

I chose to code in C++, we were given the option to either write the whole program/only that particular function/ even pseudo-code.

Also, because I am from EEE I wasn’t asked questions on DBMS, OS, etc, I told them I was comfortable with Data Structures and Algorithm, so I was only asked questions related to that

#interview experiences #marketing #on-campus #oracle

What is GEEK

Buddha Community

Oracle Interview Experience for Applications Engineer | On-Campus

**Round 1: **Online test was conducted. It had 4 sections

1. Verbal
2. Aptitude
3. Programming skills (flowcharts etc.)
4. Computer science concepts (DBMS, OS, questions on trees )

44 students were shortlisted for further process.

**Round 2 (Technical Interview): **Started at 10:45 AM. The whole process happened on ZOOM, the host assigned us to interview rooms and waiting rooms. This level of interview only focused on the most basic questions, they just wanted to know if we can code. A link was shared with an online code editor, and I was asked to share my screen and code.

I chose to code in C++, we were given the option to either write the whole program/only that particular function/ even pseudo-code.

Also, because I am from EEE I wasn’t asked questions on DBMS, OS, etc, I told them I was comfortable with Data Structures and Algorithm, so I was only asked questions related to that

#interview experiences #marketing #on-campus #oracle

Oracle Kills 402 Bugs in Massive October Patch Update

Business software giant Oracle is urging customers to update their systems in the October release of its quarterly Critical Patch Update (CPU), which fixes 402 vulnerabilities across various product families.

Well over half (272) of these vulnerabilities open products up to remote exploitation without authentication. That means that the flaw may be exploited over a network without requiring user credentials.

The majority of the flaws are in Oracle Financial Services Applications (53), Oracle MySQL (53), Oracle Communications (52), Oracle Fusion Middleware (46), Oracle Retail Applications (28) and Oracle E-Business Suite (27). But overall, 27 Oracle product families are affected by the flaws. Users can find a patch availability document for each product, available here.

“Oracle continues to periodically receive reports of attempts to maliciously exploit vulnerabilities for which Oracle has already released security patches,” according to the company’s release on Tuesday. “In some instances, it has been reported that attackers have been successful because targeted customers had failed to apply available Oracle patches. Oracle therefore strongly recommends that customers remain on actively-supported versions and apply Critical Patch Update security patches without delay.”

While details of the flaws themselves are scant, two of the critical vulnerabilities disclosed by Oracle rank the highest severity score – 10 out of 10 – on the CVSS scale.

These include a flaw in the self-service analytics component of Oracle Healthcare Foundation, which is a unified healthcare-analytics platform that is part of the Oracle Health Science Applications suite. The flaw (CVE-2020-1953), which can be remotely exploited without requiring any user credentials, requires no user interaction and is easy to exploit, according to Oracle. Affected supported versions include 7.1.1, 7.2.0, 7.2.1 and 7.3.0.

The second severe flaw (CVE-2020-14871) exists in the pluggable authentication module of Oracle Solaris, its enterprise operating system for Oracle Database and Java applications (part of the Oracle Systems risk matrix). The flaw is also remotely exploitable without user credentials, requires no user interaction and is a “low-complexity” attack. Versions 10 and 11 are affected.

Sixty-five of the vulnerabilities also had a CVSS base score of 9.8 (and six had a score of 9.4) out of 10, making them critical in severity.

Oracle did offer some workarounds, advising that for attacks that require certain privileges or access to certain packages, removing the privileges or the ability to access the packages from users that do not need the privileges may help reduce the risk of successful attack. Users can also reduce the risk of successful attack by blocking network protocols required by an attack.

However, both these approaches may break application functionality, and Oracle does not recommend that either approach be considered a long-term solution as neither corrects the underlying problem.

“Due to the threat posed by a successful attack, Oracle strongly recommends that customers apply Critical Patch Update security patches as soon as possible,” according to the company.

Oracle releases its CPUs on the Tuesday closest to the 17th day of January, April, July and October.

Previous quarterly updates have stomped out hundreds of bugs across the company’s product lines, including one in April that patched 405. There are also out-of-band updates; in June for instance, Oracle warned of a critical remote code-execution flaw in its WebLogic Server being actively exploited in the wild.

#vulnerabilities #web security #cpu #critical patch update #cve-2020-14871 #cve-2020-1953 #oracle #oracle communications #oracle e-business suite #oracle financial services applications #oracle fusion middleware #oracle mysql #oracle retail applications #quarterly patch update #remote code execution #security update

Oracle Interview Experience for Application Developer | On-Campus Virtual

Oracle visited our college on 11 September 2020. It offered two profiles : i) Application Developer ii) Server Technology.

ONLINE TEST : The Online test was of 107 minutes. It consisted of four sections.

Section 1 – Aptitude : It was having question on time & work, speed, Data Interpretation, etc.

Section 2 & 3 : Questions on CS core subjects like OS, DSA, DATABASE, CN.

Mainly the question were on AVL trees, Stack, Queue, Linked List, Output based question on Recursion, etc.

Section 4 – Verbal Ability : This sections consists of questions on Sentence Completion, Comprehension, Arranging Sentences in correct order to form a meaningful Paragraph, etc.

Each Section is further divided into 3-4 subsections with each subsection having its time limit. Eg – A subjection containing 7 question with 5 minutes, 4 question with 6 minutes, etc.

You are allowed to take a gap of 1-2 minutes between each section but no time gap between subsections.

After 4 days results declared and 40 students got shortlisted for Application Developer and 51 students got shortlisted for Server Technology. I got shortlisted for Application Developer Profile.

ROUND 1 ( TECHNICAL ~ 45 – 50 min) :

1. The interviewer started by asking how your lockdown is going on. Just asked to put in comfort zone.

2. Tell me about yourself.

3. Given a array containing 1’s and 0’s. Write a code to find maximum subsequence containing equal no. of 1’s and 0’s. https://www.geeksforgeeks.org/largest-subarray-with-equal-number-of-0s-and-1s/

4. Tell me about any incidence where you face some problem in academics and then how you overcome it. Eg – You can talk about difficulties you faced while completing you project and how you found a solution for it.

5. Now he asked me if i have any questions to ask. I asked 4-5 questions. It is always good to ask questions.

ROUND 2 ( TECHNICAL ~ 1:10 – 1:20 Hr ) :

1. Then interviewer told me that you know a about NETFLIX. Now you have design ORAFLIX same as NETFLIX, how you will design it. I started explaining him then he told me explain it in terms of SDLC. I explained all the steps of SDLC i.e requirement, design, coding, testing, deployment, maintenance. He asked few question in between while i am answering, i.e what will we different users, you will select the technology, database, OS, etc. you will use in design phase or coding phase, how you will deploy you project and have you ever deployed any project. I talked about heroku and pythonanywhere.com where i deployed my project.

2. Given a stack how you will reverse its content without using any other data structure.

https://www.geeksforgeeks.org/reverse-stack-without-using-extra-space/

3. Given a BST and a low and high value how will you print all value between low and high. Refer DSA by Narashima karumanchi book Tress Chapter.

4. Given a string how you will remove consecutive repeating characters. Eg: ‘abbac’ should return ‘c’.

5. There were 5-6 more coding questions which i can’t remember. Means a total of 8-10 coding questions were there with average to hard difficulty level.

6. Now he asked me few SQL Queries :

a) Write a Query to copy one table into another table i) with data ii) without data i.e only schema

b) Write a Query to delete all employees having salary > 1000.

c) Write a Query to delete all data of a table preserving Schema.

6. He asked me what is your favourite subject ans i answer OS. Now it followed questions on OS.

7. What is boot loader.

8. What is virtualization.

9. What is Virtual Machine and how it works.

10. As you are using Linux, so what file system does Linux users.

11. What is Iaas, Paas, Saas. Give examples of each.

12. 1-2 more question on OS which i can’t remember.

13. Diff between Set and List.

14. What is MAC and its full form.

15. What is OSI Model. Explain each layer.

In this round i was able to answer nearly 70% coding questions and for remaining questions i formed partially correct answers with the help of interviewer. The interviewer was very supportive.

I answered almost all the theory questions.

#interview experiences #marketing #on-campus #oracle

Oracle Interview Experience(Campus Placement - Application Engineer)

**Round 1 (Online Test): **It was conducted on their platform. 4 sections covered General Aptitude, English, Reasoning, basics of Coding in C++, and flow diagram of certain codes were given with some missing blocks, and we were to identify the missing blocks. There were a few questions on AVL Trees so revise it very well before the test.

They shortlist many students for the interview, so even if you haven’t given your best, there are chances that you may get shortlisted for the interview, so start preparing early, do not wait for the results to be declared.

**Round 2 (Technical Interview 1): **This was the HR + Technical round for me. First, he gave his introduction and then asked me to give my introduction. After that, he told me to explain my project/s. So I explained one project which I did on the Graph Database.

Then he gave one coding question. In input, a matrix of size N*N was given. At each cell a character was present. Along with the matrix, a string was given. My task was to develop a function that takes matrix and string as input and return ‘True’ if that string is present in it, return ‘False’ otherwise. A string may be present in the row, column, or in any of the diagonal. (Basically, it was word finding game that we used to play in childhood)

#interview experiences #marketing #oracle

Oracle Financials Interview Experience(On-Campus)

My Interview Experience (OFSS On-campus drive 2020)

**1st Round (Online Test): **An online test was conducted, which included 5 Sections. All the sections had MCQ questions.

• Section 1: QUANTS, DI, REASONING, VERBAL
• Section 2: COMPUTER ABILITY QUESTIONS: OS, DS, HTML, NETWORKING, DATABASE.
• Section 3: AVL TREE BASED QUESTIONS
• Section 4: Pattern Matching Questions
• Section 5:: Behavioral Questions

**Tip: **Try to keep cool while solving questions as this will be a 2-hour test. Also, the questions asked were basic and anyone can easily solve if he has knowledge of the above CS subjects. Understand binary trees including BST and AVL trees thoroughly as most of the DSA questions were based on that.

Around 48 students were selected for interviews including M.Tech.

**2nd Round (Technical Interview): **The interviewer asked me to introduce myself. Asked me to write a code of 2 coding questions, which were

#interview experiences #marketing #on-campus #oracle