Oracle Interview Questions

Oracle Interview Questions: The most crucial part of preparing for an interview is practice. Knowing what the interviewer may ask interview questions is essential – that way, you can craft your answers well in advance and feel confident in your responses when the pressure is on.

Wouldn’t it be great to know what interview questions were asked for the Test Engineer, QA for Manual & Automation Positions? Unfortunately, we can’t read minds, but we’ll give you the next best thing: a list of previously asked Oracle interview questions and answers.

Post On:	Oracle Interview Questions
Post Type:	Interview Questions
Published On:	www.softwaretestingo.com
Applicable For:	Freshers & Experience
Get Updates:	Software Testingo Telegram Group

We have tried to share some of the tricky interview questions, selenium interview questions & testing interview questions. But we are recommending spending some quality time to get comfortable with what might be asked when you go for the Oracle interview.

Still, we need you are Love and support to make this platform more helpful to our fellow testers. So please share your recent interview questions and experience with us. You Can share those details by connecting us at softwaretestingo.com@gmail.com.

Oracle Cloud Interview Questions

Interview Location: Bangalore(Virtual Interview)
Position: Sr. Quality Analyst
Experience: 6.3 yrs
Updated On: 18.05.2022

• Tell me your role and responsibilities.
• Are you comfortable working in Manual Testing?
• What tools have you used to automate the UI application?
• How to handle the bulk data in selenium. (They wanted to ask about Data-driven testing)
• How to run the test cases in bulk in TestNG?
• How to use excel and test the single test cases with multiple sets of data(@dataprovider)?
• How to do backend testing?
• What is the difference between black-box testing and white-box testing?
• What is the difference between a test strategy and Test Plan?
• Have you worked on Database testing before?
• How to build your project using Jenkins?
• How to run your test cases in a regression test?
• How to set up Jenkins and run the test cases?
• Write a program to count the occurrence of words and sort it.
• Write a program to remove the white space from the string?
• Which collection will you use when you have to delete a country from 100 values from the dropdown.
• Why do we use LinkedList for manipulation, not Arraylist?
• Some questions related to API
• What will be the output of the below program?

Class Testcase()
{
	Static
	{
		System.out.println("This is static method")
	}
	public Static void main(String args[])
	System.out.println("Main")
}

Oracle Interview Questions

Company Location: Mumbai, India
Attended on: 15.11.2021

• Which framework have you used?
• How do you have to handle failed test cases?
• If your test cases depend on previous test cases, how did you handle them & explain the syntax for that?
• What is regression testing.?
• Explain the different types of wait you have used in your framework and explain?
• What is the difference between a test plan and a test strategy..?
• I asked some queries.
• Tell me something about exceptions.
• BDD cucumber explains
• Explain your framework architecture.
• Related to database testing
• Level of testing.
• Defect bug life cycle

Oracle Automation Testing Interview Questions

Company Location: Bangalore
Experience: 6 Year

• Explain your current project framework
• How much do you rate yourself in java out of 5 and selenium out of 5
• WAP to swap two numbers without using the temp variable
• WAP to find whether the number is prime or not
• For example, explain method overloading and overriding and how you used this concept in your framework.
• How do you take screenshots in selenium
• Tell me some annotations in TestNG
• Do you know exceptions? Tell some exceptions in selenium
• Different types of XPath – she was expecting the following sibling and preceding sibling
• Which is preferred absolute or relative XPath – what is / and //
• Other ways of selecting objects from the dropdown
• What are the limitations/drawbacks of selenium – she was expecting the inability to detect captcha.

Oracle Interview Questions For Automation Testing 2 Year Exp.

Company Location: Bangalore
Interview Date: 07/07/2021(Tech Round), 09/07/2021(Managerial Round)
Experience: 2 Years 10 months
Position: QA Automation

Thanks To Kushal Gupta, For sharing below oracle Interview Questions with Us. If you also want to share your experience & questions with us then you can reach us at softwaretestingo.com@gmail.com

Experience

I got referred by my friend and got a call back after 2weeks. The entire interview process will consist of 2 seconds ( Technical Round and Managerial Round ).

• Technical Round went on for 60 Mins
• The managerial round went on for 15mins

Technical Round:

• Tell me about yourself.
• Frameworks and tools used in your experience.
• Explain the OOPS concept in detail with examples.
• They gave me a scenario to automate and asked me to write the script in VBScript and Selenium.
• Difference between severity and priority of the defects.
• They gave me a java program and asked me about the output.
• How will you establish a database connection in UFT and Selenium?
• Will you work in any other technology other than selenium?
• How did you handle exceptions in your project?

Managerial Round:

• Tell me about yourself.
• Explain different frameworks you worked on.
• Given an opportunity, are you willing to work in manual testing also?
• Willing to relocate and salary discussion.

Oracle Bangalore QA Interview Questions

Company Location: Bangalore, India
Updated on: 12.05.2021

• Tell me about your professional experience.
• What are the test methodologies you have used?
• Explain Agile methodology.
• Explain bug life cycle.
• Explain SDLC.
• Write test cases for a text box accepting 0-9 characters and alphabets.
• Write test cases for lift.
• If the title of a page is not displayed, what severity and priority do you assign to it?
• Which tool do you use for logging defects?
• Is SVN a reporting tool?
• Which Selenium version are you using currently?
• Which is the latest version of selenium?
• Why are you using Selenium 2 when the latest four are available?
• When was your framework developed?
• What is the unique feature of Selenium 2 and 3?
• Explain Polymorphism.
• Types of polymorphism.
• Where do we use method overloading in webdriver methods?
• Explain the statement : WebDriver driver = new ChromeDriver();
• What is WebDriver in the above statement?
• What is ChromeDriver() in the above statement?
• If WebDriver is an interface, how can you instantiate it?
• What is the superclass of WebDriver?
• What is Interface?
• What are the uses of the interface?
• What are the different types of Inheritance?
• Which are the types of Inheritence that Java does not support?
• Why is Multiple Inheritance not supported in java?
• What is the other way of achieving Multiple Inheritance?
• How many locators are there in selenium?
• Name the locators.
• Which is the fastest locator?
• Compare XPath and ID.
• Which locator do you use for dynamic web element on-page?
• Does the automation script fail if the ID is unique on a web page and changes the location?
• Write a small program to reverse the name without using the inbuilt method.
• Which latest java version have you worked with?
• Name a few exceptions that you have come across.
• Have you come across “Stale exception”?

Oracle Testing Interview Questions

• What is testing? Different types of testing.
• Why do we do an automation test? Please explain to me your project and its architecture.
• What is the testing strategy?
• What is the test plan document, and explain the contents briefly?
• What is regression testing? How did you perform in your project?
• How was QC useful in the testing process in your project to log & track defects?
• What are the different types of testing life cycle models? Which type of testing model does your project follow? Have you worked in agile methodology in any of your projects?
• The SQL query to find out the 4th maximum salary.
• Write the self join query to find the manager’s department of a manager whose department is ABC.
• Different types of joins, simple SQL queries like select, update, etc.
• Simple UNIX commands to list a file, find all files containing the desired word and say your name.
• What is your role in your project? How do you overcome hurdles that you might face when your immediate senior/manager is not present to attend a meeting with the client. You have an essential thing, as an application crash occurs during testing. How do you handle such circumstances?
• Explain java in layman’s terms if I don’t understand any technical stuff like private, class, or object.
• Explain automation architecture and how what kind of architecture was in your project and explain it.
• Why do we use interfaces? Why is the interface concept present when something could be achieved using classes or abstract classes?
• Tell the use of abstract classes over interfaces, and how are interfaces built in terms of methods declared and variables within it?
• Questions on collections like how do you do sorting using collections?
• Giving an example, he asked me to choose which collection I would choose for that scenario. Like getwindowhandles returns set, but can I also use a list or any other collection? Similar questions.
• TestNG and how you could initiate your automation script.
• How to connect to the database using selenium, its requirements for connection, and commands for connection.
• Differences between overloading and overriding, what is polymorphism, what is an abstraction, and write a program that shows me something I understand about these concepts.
• Write a program to check if the given input is a palindrome or not by taking input from the user at runtime.
• What are the advantages of using TestNG? Why can’t we run selenium code directly?
• Have you worked on Jenkins? What are its advantages of it? What if the developer does not use Jenkins, but the testing team has been asked to use it? Can you do so without the developer creating the build in Jenkins, and your automation code can start?
• Disadvantages and advantages of selenium, where can I not use selenium?
• Given just 2days and you have like 100 test cases to manually execute, and your colleague is on extended leave, what will you do? Do you think this situation can occur in real-time? Can you complete all test cases alone within deadlines?
• What is the code to find the active element on the web page?
• Write a selenium program to verify that the web page’s navigation is landing at the correct URL on the next page.
• Write a code to make use of assert if my username is incorrect.
• What is the skeleton of testng.xml? What all does/can it contain?
• Code for switching frames back and forth( getting into frames and out to the mainframe)
• Write a program to extract information from the excel sheet and print it to the reporting sheet(reporter.log) and console.
• How confident are you in manual testing, selenium, and java?
• Code to write the usage of actions class with an example, usage of a select class
• I am switching between the two browsers(parent and child), popup differences, and identification.
• How to use external support like AutoIT or robotium, and under what conditions?
• Can we do any mouse actions like clicking using AutoIT? If yes, how? If no, what is the alternative?

Oracle Selenium Interview Questions

• How string is different from other data types
• The difference between final, finally, and finalize
• Create a folder if it does not exists and then create a text file inside it, write the data to the text file and save it, then open the file and read the data
• Explain polymorphism in detail
• Interface declaration
• Difference between abstraction and interface
• Read the excel data from a cell
• Write the runtime data to the excel sheet
• How will you declare a class if I don’t want to change the data in it
• I have 10 test cases, and I want to execute only 3 test cases. How will you do that
• Find the largest three numbers in the array
• The reverse of an array
• Collections in Java

Oracle Financial services Interview questions

• 1st round:- Online Test Approx 20 questions
• 2nd round:- F2F round
• Which version of selenium, java, and Appium you are using
• Difference between Selenium 2 and Selenium 3
• What is the latest feature in Java 8?
• What is a lambda expression?
• How to get the data from a web table like ID: 1,2,3 is there in the 1st column and Name: Rahul, Amit, Himanshu. Find the value of ID 3
• What is bubble sort
• How to verify the color of an image

Oracle Cloud Testing Interview Questions

• write a program for the clicking element presented in the frame.
• Write a program for the clicking element, which presents in a child window.
• Write a program that should validate the calendar table.
  Scenario: suppose the march calendar table consists of all dates 1 to 31; check whether empty boxes exist in the table or not.
• What is TestNG, and how does it differ from Junit? What tests can be done with TestNG?
• Write the syntax of an opening browser in selenium.
  me: webdriver driver= new firefoxdriver();
  interviewer: what happens in dis case firefoxdriver driver= new firefoxdriver(); ?
  Why do we have two syntaxes if der purpose is the same?
  When do we use firefoxdriver and webdriver in the above syntax?
  Tell me some differences b/w both syntaxes.
• Write the syntax for firefox in selenium 3.0.
• Why have selenium people changed the syntax, and what is the difference b/w the syntaxes of selenium 2.53 and selenium 3.0?
• What is the dynamic polymorphism in java? Explain with an example.
• What is the difference between interface and abstract class?
• Why is the purpose of abstract class when we achieve abstraction through the interface?
• Why can the constructor not be inherited in java?
• Is the constructor by default final if yes/no, give a reason?
• What is the package imported for reading/writing files in java?
• What are the robot class and sikuli and AutoIt?
• What is try-catch?
• What is final, finally, finalize?
• Will finally block always executes?
• What happens if I put the system out in the catch block?
• What are the oops concepts?
• If an exception got in to try, what will execute catch or finally?
• There is one statement when we put that statement in a try; then the finally blocks won’t execute what that statement is? What happens when we write that statement, and where will the control go?
• Have you ever created a user-defined exception? What is the syntax?
• What is the difference b/w throw and throws?
• How do you run tests parallelly?
• How do you pass test data in TestNG, and which annotation will you use?
• What type of framework using in your project to explain it.
• Without using sendkeys, how will you type text in a text box? is der any method or class in java?
• What are the differences b/w list and set?
• What is a linked list?
• What is a hashmap? What will happen if I insert a duplicate in the hashmap, which will be overridden out of key or value?
• How will you do debugging in eclipse?
• How do you log bugs when a test case fails?
• What is the difference b/w severity and priority?
• In which scenarios do we get a null pointer exception?
• Where do you find difficulties in automation while writing scripts?
• Out of 1000 test cases, only 1 test case failed; how will you run that test case?
• There is a String with 100 characters in it, and characters may be in any order, and by default, that string is not a palindrome; how will you say the string can be a palindrome or not?
• What is agile? Explain the process of agile.
• Suppose in sprint ten requirements are der. Do we start testing after completing the development of all ten requirements, or how?
• How do you click on a particular date number in the calendar month table?
  Scenario: suppose today I will click on 20 dates in the month table, tomorrow 21 like so. It
  should be dynamic.
  Write a program for it.
• How do you pass a parameter into XPath?
• Suppose you have ten thousand test case files there. One element changed in the new releases, and the same element was used in 700 test case files. Now say how do you do changes for that element in those files.
• Tell me the oops concept with real-time examples. Like any software terms, you can use.
• If your script got failed and the same script works fine with the next run,  what will you do? Will you log the bug, or what kind of analysis do you do?
• The box contains 50 red socks and 50 white socks; what is the probability of getting the right pair of the same color in how many picks? Tell the worst case and best case of probability.
• If the box contains 1000 different colors and 10,000 socks, now say the probability of getting the right pair of
  the same color in how many picks? Tell the worst case and best case of probability.
• Using eight 8’s make 1000 use any operators like +,-,%,/.
• What are the differences b/w agile and other methodologies?

Oracle Testing Interview Questions

• How to abort a shell script while it is running?
• Is it possible to use the echo command instead of the ls command?
• How to remove one line from a text file using Unix commands?
• Provide logic to replace M with F and F with M in the Employees table using the single command without any temp table.
• How to pick the nth maximum salary from the employee’s table?
• Difference between two constraints – Primary key and Unique Key.
• What are various DML, DDL, and DCL commands in SQL?
• What is the following number in the sequences 9, 18, 21, 25, and 20?
• One aptitude question – If a monkey climbs 6 meters and descends 3 meters in 1 min. What is the time monkey takes to climb 60 meters?
• Explain the different steps in the SDLC model.
• What is an Agile methodology, and what are its benefits of it.
• What is the difference between the Web application and the Desktop application?
• What is the best bug you have found still date?
• What is the difference between a Defect and a Bug?
• Write a Java program to generate Random numbers from 1 to 10.
• Write Selenium webdriver code to log in to an application and check the validity of one element in the resulting page.
• What are the conditions you follow to pick test cases for automation?
• What are the conditions you follow to not select test cases for automation?
• What is XPath, and where is it used.
• What is the difference between // and / in XPath?
• What are the different types of waits in Webdriver?
• Difference between Explicit and Implicit wait in webdriver.
• Give an example of a High priority and Low severity scenario.

ORACLE Interview Questions for 2+ Years

• Tell me about Yourself
• What are Priority and Severity
• Tools used in your project
• Detail explanation of QC
• What are the stages of bug
• Given a sample Webpage to test? How will you test that webpage?
• Write HTML code for a page containing
  1. Title
  2. Image
  3. Radio Buttons
  4. Check Boxes
  5. Links
  6. Images (Again)
  7. Links (Again)
• For the above HTML code, how do you identify all the elements that are present are not?
• Explain STLC?
• What is the version of QC that you have used in your project?
• How do you identify the web page’s content without using a Tool?
• About the Project?
• Explain Priority and Severity with Example?