Skip to content

Oracle Software Testing Interview Questions & Answers

Curated interview practice questions with answers. These are practice scenarios, not a verified list of past interview questions.

Solved for OracleStart practicing
3 QUESTIONS FREESign up or log in to unlock the full question bank and track your progress.Unlock every question and answer, then continue practising company-wise and package-wise.
3 questions free Unlock the rest in seconds
01

What are the boundary values for an age field that accepts 18–60?

Save to ▾
Show answer
Test 17, 18, 19, 59, 60 and 61.
02

How would you test a login page for security?

Save to ▾
Show answer
Check SQL injection, brute-force lockout, password masking, session timeout, HTTPS, cookie flags, error messages not revealing users and password reset flow.
03

What is the difference between smoke testing in CI and full regression?

OracleMedium
Save to ▾
Show answer
Smoke tests run on every build for quick feedback; full regression runs less often, such as nightly or before release.
04

What is compatibility testing?

OracleMedium
Save to ▾
Show answer
Checking the application works across browsers, devices, operating systems, screen sizes and network conditions.
05

What is the difference between a test suite and a test run?

OracleMedium
Save to ▾
Show answer
A suite is a collection of related test cases; a run is one execution of a set of tests against a build.
06

How do you write a good bug title?

OracleMedium
Save to ▾
Show answer
State the problem, location and condition briefly, for example 'Checkout button disabled after applying a coupon on the cart page'.
07

What is the difference between DELETE and TRUNCATE?

OracleMedium
Save to ▾
Show answer
DELETE removes selected rows and can be rolled back; TRUNCATE quickly removes all rows and resets the table.
08

How do you test a REST API with authentication?

OracleMedium
Save to ▾
Show answer
Check access with valid, expired and missing tokens, role-based permissions, error codes and that sensitive data is never exposed.
09

What are positive and negative test cases?

OracleMedium
Save to ▾
Show answer
Positive cases use valid inputs to confirm expected behaviour; negative cases use invalid inputs to confirm the system handles errors gracefully.
10

What are the levels of testing?

Save to ▾
Show answer
Unit, integration, system and acceptance testing, moving from individual components to the complete product in front of users.
11

What is the use of SQL GROUP BY and HAVING in test validation?

OracleMedium
Save to ▾
Show answer
They let testers verify totals and counts per category, such as the number of orders per customer, and compare them with the UI or reports.
12

What is SQL and why do testers use it?

Save to ▾
Show answer
A language to query databases. Testers use it to verify data saved by the application, prepare test data and check backend results.
13

What is the testing pyramid?

OracleMedium
Save to ▾
Show answer
A model with many fast unit tests at the base, fewer API or integration tests in the middle and a small number of UI tests at the top.
14

What is localisation and internationalisation testing?

OracleMedium
Save to ▾
Show answer
Internationalisation tests that the product can support many languages and formats; localisation tests that a specific locale is correct for text, currency, date and layout.
15

What makes a good bug report?

Save to ▾
Show answer
A clear title, steps to reproduce, expected vs actual result, environment/build, severity and priority, and evidence (screenshot, video, logs).
16

What is the difference between static and dynamic testing?

OracleMedium
Save to ▾
Show answer
Static testing reviews documents and code without executing; dynamic testing executes the software to observe behaviour.
17

Give an example of equivalence partitioning.

Save to ▾
Show answer
For a field accepting 1–100: valid class 1–100 (test 50), invalid below 1 (test −5), invalid above 100 (test 150). One value represents each class.
18

What do you check when testing an API in Postman?

OracleMedium
Save to ▾
Show answer
Status code, response body and schema, headers, response time, error messages for invalid input, authentication (401/403) and that data is saved in the database.
19

What is defect density?

OracleMedium
Save to ▾
Show answer
The number of defects per size of software, for example defects per thousand lines of code or per module, used to compare quality.
20

What is defect clustering?

OracleMedium
Save to ▾
Show answer
The observation that a small number of modules contain most defects, so testing should focus on those areas.
21

What are the typical JIRA workflows for bugs?

OracleMedium
Save to ▾
Show answer
Statuses like To Do, In Progress, In Review, Ready for QA, Done and Reopened, with transitions that depend on the team's configuration.
22

Functional vs non-functional testing?

Save to ▾
Show answer
Functional testing checks what the system does (login, checkout). Non-functional testing checks how well it does it (performance, security, usability, compatibility).
23

What is the difference between an error, a defect and a failure?

Save to ▾
Show answer
A human error causes a defect in the code, and when that defect is executed it produces a failure visible to users.
24

How do you test an API using Postman?

OracleMedium
Save to ▾
Show answer
Create a request with method, URL, headers and body, send it, check status and body, add test scripts and save it in a collection.
25

Write test cases for a file upload feature.

OracleMedium
Save to ▾
Show answer
Allowed and disallowed formats, size limits, empty file, duplicate names, special-character names, cancel upload, slow network and multiple files.
26

What is TDD vs BDD?

OracleMedium
Save to ▾
Show answer
TDD writes unit tests before code to drive design; BDD describes behaviour in business language scenarios that become automated acceptance tests.
27

Write test cases for a login page.

Save to ▾
Show answer
Valid login, wrong password, empty fields, case sensitivity, max length, SQL-injection strings, password masking, 'remember me', lock-out after N attempts and the forgot-password link.
28

What are the seven principles of testing?

OracleMedium
Save to ▾
Show answer
Testing shows presence of defects, exhaustive testing is impossible, test early, defects cluster, the pesticide paradox, testing is context-dependent and absence-of-errors is a fallacy.
29

How do you handle a bug found late in a release cycle?

OracleMedium
Save to ▾
Show answer
Assess impact and risk, discuss with product and dev, decide to fix, defer with a workaround or delay release, and document the decision.
30

What is usability testing?

OracleMedium
Save to ▾
Show answer
Evaluating how easy and pleasant a product is to use by observing real users complete tasks and noting confusion.
31

What is boundary value analysis?

OracleMedium
Save to ▾
Show answer
Testing at the edges of input ranges, such as 17, 18 and 19 for an age limit of 18, since errors cluster at boundaries.
32

Explain the bug life cycle.

Save to ▾
Show answer
New → Assigned → Open → Fixed → Retest → Verified → Closed, with Reopened, Rejected, Deferred and Duplicate as side paths.
33

Write test cases for a search box.

OracleMedium
Save to ▾
Show answer
Valid keyword, partial match, no results, special characters, very long text, empty search, case sensitivity, spelling errors, suggestions and speed of results.
34

What is a traceability matrix?

OracleMedium
Save to ▾
Show answer
A grid mapping requirements to test cases and defects, proving every requirement is tested.
35

What is the definition of done?

OracleMedium
Save to ▾
Show answer
A shared checklist for when a story is complete, usually including code review, tests passing, no open critical bugs and documentation updated.
36

What is error guessing?

OracleMedium
Save to ▾
Show answer
Using experience to guess where defects likely hide, such as empty fields, special characters or unexpected sequences, and designing tests for them.
37

What is a bug triage meeting?

OracleMedium
Save to ▾
Show answer
A regular review where QA, development and product assess new bugs and decide severity, priority, owner and target release.
38

What is a test closure report?

Save to ▾
Show answer
A final document summarising what was tested, defects found and open, metrics, lessons learned and the recommendation for release.
39

What is a test scenario for the login functionality at a high level?

Save to ▾
Show answer
Valid login, invalid login, forgot password, locked account and session handling are the main scenarios to cover.
40

Write test cases for a signup form.

OracleMedium
Save to ▾
Show answer
Mandatory fields, email format, password rules, duplicate email, terms checkbox, captcha, confirmation email and field length limits.
41

What are common HTTP status codes?

OracleMedium
Save to ▾
Show answer
200 OK, 201 Created, 204 No Content, 400 Bad Request, 401 Unauthorized, 403 Forbidden, 404 Not Found, 500 Internal Server Error.
42

What is the difference between a bug and an enhancement?

OracleMedium
Save to ▾
Show answer
A bug is behaviour that deviates from agreed requirements; an enhancement is a new or improved capability beyond the current requirements.
43

What is a blocker bug?

OracleMedium
Save to ▾
Show answer
A defect that stops testing or release of a feature because no workaround exists, so it is highest priority.
44

How do you test database integrity using SQL?

OracleMedium
Save to ▾
Show answer
Verify inserted, updated and deleted rows match UI actions, check constraints, duplicates, NULLs and totals with COUNT and SUM queries.
45

What is accessibility testing?

OracleMedium
Save to ▾
Show answer
Checking that people with disabilities can use the product, using screen readers, keyboard navigation, colour contrast and WCAG guidelines.
46

What is risk-based testing?

OracleMedium
Save to ▾
Show answer
Prioritising tests by the likelihood and impact of failure, so critical areas get the most coverage when time is limited.
47

Write test cases for a calculator app.

OracleMedium
Save to ▾
Show answer
Basic operations, division by zero, decimals, large numbers, order of operations, clear and backspace, repeated operations and memory keys.
48

What are test data and how do you prepare them?

OracleMedium
Save to ▾
Show answer
The inputs used in tests. Prepare using valid, invalid and boundary values from production-like but masked data, spreadsheets or generators.
49

What is a sprint retrospective?

OracleMedium
Save to ▾
Show answer
A team meeting at the end of a sprint to discuss what went well, what did not and what to improve next.
50

What is API testing and why is it important?

OracleMedium
Save to ▾
Show answer
Testing services directly without the UI, checking status codes, responses, security and performance. It finds issues early and is faster than UI tests.
51

Production has a critical bug. What are your steps?

Save to ▾
Show answer
Reproduce and assess impact, inform stakeholders, help developers fix and verify in staging, run regression and check monitoring after the hotfix, then do a post-mortem.
52

What is the difference between a test case and a test scenario?

Save to ▾
Show answer
A scenario is a high-level thing to test (user logs in); test cases are the detailed steps and data that verify it.
53

What is use case testing?

OracleMedium
Save to ▾
Show answer
Designing tests from user flows described in use cases to verify complete real-world interactions.
54

What are entry and exit criteria?

OracleMedium
Save to ▾
Show answer
Entry criteria are conditions that must be met to start testing (build ready, environment set); exit criteria define when testing can stop (pass rate, no critical defects).
55

How do you test an application with no documentation?

Save to ▾
Show answer
Talk to developers and users, explore the product, review similar systems, create notes and mind maps, confirm assumptions and write test cases as you learn.
56

What is a test case and its components?

Save to ▾
Show answer
A set of steps with inputs and expected results. Components: ID, title, preconditions, steps, test data, expected result, actual result and status.
57

How do you test a REST API that is not ready yet?

Save to ▾
Show answer
Use mocks or stubs from the API contract such as Swagger, write test cases early and validate again when the real service is available.
58

What are the characteristics of a good test case?

OracleMedium
Save to ▾
Show answer
Clear, concise, independent, repeatable, traceable to a requirement, with precise expected results and tested data.
59

Write test cases for an ATM withdrawal.

OracleMedium
Save to ▾
Show answer
Valid card and PIN, wrong PIN, three failed attempts, amount above balance, amount above daily limit, invalid denomination, machine out of cash, network failure and receipt printing.
60

What is configuration testing?

OracleMedium
Save to ▾
Show answer
Verifying the application works across different hardware, software and settings combinations.
61

What is test coverage and how do you measure it?

OracleMedium
Save to ▾
Show answer
The extent of requirements or code exercised by tests. Measure requirement coverage with a traceability matrix and code coverage with tools.
62

How do you decide the priority of test cases?

OracleMedium
Save to ▾
Show answer
By business criticality, usage frequency, defect history, risk and dependencies, running high-priority cases first.
63

What is UAT?

Save to ▾
Show answer
User Acceptance Testing — end users or the client verify that the system meets business needs in a production-like environment before go-live.
64

What are severity and priority? Give examples.

OracleMedium
Save to ▾
Show answer
Severity is impact on the system; priority is urgency of the fix. A crash in a rare report is high severity, low priority; a spelling mistake in the logo is low severity, high priority.
65

How do you use JIRA in testing?

OracleMedium
Save to ▾
Show answer
Log and track bugs, link them to stories, build dashboards and filters with JQL, manage sprints and generate reports.
66

What is a hotfix?

OracleMedium
Save to ▾
Show answer
An urgent patch released outside the normal schedule to fix a critical production defect, followed by regression testing and merge back to the main branch.
67

What metrics do QA teams track?

OracleMedium
Save to ▾
Show answer
Test execution rate, pass percentage, defect density, defect leakage, defect rejection ratio, requirement coverage and automation coverage.
68

What is pairwise testing?

OracleMedium
Save to ▾
Show answer
A technique that tests all pairs of input values instead of every combination, greatly reducing test cases while catching most defects.
69

A bug is not reproducible. What next?

OracleMedium
Save to ▾
Show answer
Re-check environment, data, browser and steps; check the logs; try the reporter's setup; add video and console logs; mark it 'cannot reproduce' only after discussing with the developer, and keep monitoring.
70

What is a test plan and what does it contain?

Save to ▾
Show answer
A document defining scope, approach, resources, schedule, entry and exit criteria, risks and deliverables of testing.
71

What is the difference between a story, epic, task and bug in JIRA?

OracleMedium
Save to ▾
Show answer
An epic is a large body of work; stories are user-facing slices of it; tasks are technical work items; bugs are defects.