Oracle PL/SQL interview questions

Want to become an expert in cracking Oracle PL/SQL interview questions?

Start with practicing the questions below. Whether a question involves multiple choice or live coding, we will give you hints as you go and tell you if your answers are correct or incorrect.

After that, take our timed public Oracle PL/SQL interview questions test.

To use our service for testing developers, purchase one of the paid plans for companies.


1. Patient
Oracle PL/SQL Conditional statements Language features Public

A hospital stores the names of patients and doctors in the following table:

TABLE patients
  id INTEGER NOT NULL PRIMARY KEY
  patient VARCHAR(100)
  doctor VARCHAR(100) NOT NULL

The hospital refers to a patient whose name is unknown as 'John Doe'. These patients are represented as null in the patients table.

Which of the following queries can be used to select a list of patients ('John Doe' if patient is null) and their doctors?

Easy  
2min
Solve question

If you feel ready, take one of our timed public Oracle PL/SQL interview questions tests:

  • Oracle PL/SQL (15-min test) ( Easy )
Not exactly what you are looking for? Go to our For developers section.