Oracle Interview Questions, Process, and Tips

Q1. Count no of links in as web page
Ans. 
To count the number of links on a web page, you can use a web scraping tool or inspect the page's HTML code.
• Use a web scraping tool like BeautifulSoup or Selenium to extract all the links from the webpage.

• Inspect the HTML code of the webpage and look for anchor tags (<a>) which contain the links.

• Count the number of anchor tags to determine the total number of links on the webpage.
Answered by AI
Add your answer
Q2. Remove zeros from arrays list
Ans. 
Remove zeros from arrays list of strings
• Iterate through each string in the array

• Use filter method to remove zeros from each string

• Return the updated array without zeros
Answered by AI
Add your answer
Q3. Return type of Findelements
Ans. 
FindElements method returns a list of web elements matching the specified locator.
• Return type of FindElements is List

• It returns a list of all elements matching the specified locator

• Example: List elements = driver.findElements(By.xpath("//input[@type='text']"));
Answered by AI
Add your answer
Q4. Find second highest vowel occurance in a string
Ans. 
Find the second highest occurrence of a vowel in a string.
• Iterate through the string and count the occurrences of each vowel (a, e, i, o, u).

• Store the counts in an array and find the second highest count.

• Return the vowel with the second highest count.
Answered by AI
Add your answer
Q5. Write locator for element in webpage
Ans. 
Use CSS selector to locate element on webpage
• Use unique id or class names to locate element

• Use CSS selectors like 'id', 'class', 'name', 'tag name', etc.

• Use XPath if necessary for complex element locating
Answered by AI
Add your answer

Coding is nothing but ask about the software language like python, java, etc.,

Q1. Tell about something
Ans. 
I will tell you about my experience working on a team project to develop a mobile app.
• Collaborated with team members to brainstorm ideas and plan project milestones

• Utilized programming languages such as Java and Swift to develop app features

• Conducted testing and debugging to ensure app functionality and user experience

• Received feedback from users and made necessary improvements to the app
Answered by AI
Add your answer
Q2. How did you know the job
Ans. 
I found the job through a job search website and applied online.
• I was actively looking for software developer positions on job search websites.

• I came across the job posting for this position and it matched my skills and experience.

• I submitted my application online through the company's website.

• I received a call for an interview after my application was reviewed.
Answered by AI
Add your answer

Q1. Why we are hiring you
Ans. 
You are hiring me because of my strong technical skills, experience, and passion for software development.
• Strong technical skills in programming languages such as Java, Python, and C++

• Proven experience in developing and implementing software solutions

• Passion for staying updated with the latest technologies and trends in the industry
Answered by AI
Add your answer
Q2. Tell about your strength
Ans. 
My strength lies in my problem-solving skills, attention to detail, and ability to work well in a team.
• Strong problem-solving skills - I enjoy tackling complex issues and finding creative solutions.

• Attention to detail - I am meticulous in my work, ensuring accuracy and quality.

• Team player - I collaborate effectively with colleagues, contributing to a positive work environment.

• Adaptability - I am able to quickly learn n...read more
Answered by AI
Add your answer

Q1. Past Experience, Salary expectation, skills
Add your answer

Q1. Questions on previous project and role, Technical Question 5- 6
Add your answer
Q2. How can You optimize MySQL queries.
Ans. 
Optimizing MySQL queries involves using indexes, avoiding unnecessary joins, optimizing data types, and using query caching.
• Use indexes on columns frequently used in WHERE, ORDER BY, and GROUP BY clauses.

• Avoid using SELECT * and only fetch the columns needed.

• Optimize data types to use the smallest data type possible for each column.

• Avoid unnecessary joins and use INNER JOIN instead of OUTER JOIN when possible.

• Enable qu...read more
Answered by AI
Add your answer

Q1. Managerial Questions
Add your answer
Q2. Why want to leave the previous company
Add your answer

Core java and OOPS concepts and basic coding tricks and puzzly questions

Q1. Selenium webdriver basic
Add your answer
Q2. Automation testing
Add your answer

Q1. Salarydiscussion
Add your answer

Codility test. Data structure and algos

Q1. Greedy algrithm
Add your answer
Q2. Sorting an array
Ans. 
Sorting an array of strings
• Use built-in sorting functions like sort() in most programming languages

• Consider the case sensitivity of the strings when sorting

• You can customize the sorting order by providing a comparison function
Answered by AI
Add your answer

Q1. Question 1(Medium)
Add your answer
Q2. Question 2(medium)
Add your answer

DSA, java, previous projects