Oracle PL/SQL and SQL Online Test

TestDome skill assessments are used by more than 4,000 companies and 450,000 individual test takers.

Companies: Try First, Pay Later

Sign Up To Use This Test

Jobseekers: Get a Certificate

Take a Practice Test
 Used by: 

The Oracle PL/SQL and SQL online test assesses candidates' knowledge of SQL queries, relational database concepts, and specific Oracle PL/SQL features.

It's an ideal test for pre-employment screening. A good database admin or back-end developer working exclusively on an Oracle SQL Server database layer needs to be able to use Oracle's PL/SQL to create custom procedures and objects to interface efficiently with a database.

This online test requires candidates answer multiple-choice questions about PL/SQL, features of the Oracle SQL Engine, and write SQL queries that extract, combine, and manipulate data.

Recommended Job Roles
Data Analyst
Oracle Database Administrator
PL/SQL Developer
Sample Candidate Report

Sample Free Questions

Count Users


Oracle PL/SQL Functions Public

Consider the following code:

  user_count NUMBER;
  SELECT COUNT(*) INTO user_count FROM users;
  RETURN user_count;

Select the statements that are correct.

(Select all acceptable answers.)



Oracle PL/SQL Exceptions Public

Consider the following table definition:

  first_name VARCHAR2(50) NOT NULL,
  last_name VARCHAR2(50) NOT NULL

Later the following code is executed:

  husband_id NUMBER;
  SELECT id INTO husband_id FROM couples WHERE first_name = 'John' AND last_name = 'Johnson';
  INSERT INTO couples(id, first_name, last_name) VALUES(husband_id + 1, 'Jane', 'Johnson');

Select the exceptions that might be raised.

(Select all acceptable answers.)



SQL Aggregation Public

Given the following data definition, write a query that returns the number of students whose first name is John. String comparisons should be case sensitive.

TABLE students
   firstName VARCHAR(30) NOT NULL,
   lastName VARCHAR(30) NOT NULL
Use Free Questions On a Trial Plan

Premium Questions

The premium question library contains our unique, hand-crafted questions. We offer a refund if you find any of them answered online.

Movies, Index Performance, Poll, Rectangles, Retirees, Authors, Countries, Employee Manager, Merge Stock Index, Cheapest Product, Movies Live, Bind Variables, Merge Lists, Insert Employee, Query Performance, Savepoint, Lap Times, Remove Element, ATM Locations, Department Report, Developers, Delete Orders, Restaurant Menu, Roads, Sales, Student Activities, Transactions, Projects, User Statistics, Employee Salary, Youngest Child, Tasks, Ingredients, Autocomplete, Bank Branches, Hospital Patients, Menu Items, Ban Users, SMS Messages
SQL Aggregation Subqueries Indexes Conditions Insertion Language Joins Union Oracle PL/SQL Bind Variables Set Exceptions Performance tuning Transactions Built-in functions Tables Constraints Database Schema Bug fixing Delete Update Views Collections Cursors
Score Distribution
Pricing For Premium Questions

Fully Customizable Tests
Add questions from our question library.
Create your own questions.
Customize test duration, number of questions, passing score, web proctoring, and more.
Create Free Account
Private Concierge

Send us an email with an explanation of your testing needs and a list of candidates. We will create an appropriate test, invite your candidates, review their results, and send you a detailed report.

What Others Say
TestDome user reviews on G2 Crowd
Simple, straight-forward technical testing

TestDome is simple, provides a reasonable (though not extensive) battery of tests to choose from, and doesn't take the candidate an inordinate amount of time. It also simulates working pressure with the time limits.

Jan Opperman, Grindrod Bank

Very smooth, well supported, great for assessing candidates

Very Prompt and helpful support when needed, we were looking to work with a third party to write and set up new tests, TestDome was able to quickly set up and support a method to do this, allowing us to start testing candidates straight away.

George Offer, Guided Solutions

Easy to use and efficient for testing developers of different levels

It provides us an opportunity to set our own timing policy, to choose from variety of questions from different areas and with difficulty gradation. Also it is great that TestDome provides free of charge tests for candidates to prepare and check how online IDE works. And support is always ready to help:)

Alexandra Bulka, WorkFusion

On the TestDome Blog

Screening Applicants: The Good, the Bad and the Ugly

Since we’re all biased and we use incorrect proxies, why not just outsource hiring to experts or recruitment agencies? After all, they’ve been screening people for many years, so they must know how to do it right?

Not really. I was surprised to discover that many experts disagree with each other. Everybody praises their pet method and criticizes the others. Many of these methods look legitimate, but are based on...

How TestDome Works
How TestDome Works

Want to know more? Check out our tour or contact us below.

Check Tour
Schedule a Demo
The TestDome Advantage
500+ premium, hand-crafted questions for 30+ job skills and 10+ coding languages.
Proctored tests, API access, and Applicant Tracking System (ATS) Integration.
Questions with small samples of actual work instead of academic problems.
Flexible Pricing

No monthly subscription or setup fee. No minimum contract period. You only pay for the candidates you test.

View Pricing

Not exactly what you're looking for?

Related Programming Tests: