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

2min
  -  
Easy  
  -  
MCA

Oracle PL/SQL Functions Public

Consider the following code:

CREATE OR REPLACE FUNCTION count_users 
RETURN NUMBER 
IS 
  user_count NUMBER;
BEGIN
  SELECT COUNT(*) INTO user_count FROM users;
  RETURN user_count;
END;
/

Select the statements that are correct.

(Select all acceptable answers.)

Couples

2min
  -  
Easy  
  -  
MCA

Oracle PL/SQL Exceptions Public

Consider the following table definition:

CREATE TABLE couples(
  id NUMBER PRIMARY KEY NOT NULL,
  first_name VARCHAR2(50) NOT NULL,
  last_name VARCHAR2(50) NOT NULL
);

Later the following code is executed:

DECLARE
  husband_id NUMBER;
BEGIN
  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');
END;

Select the exceptions that might be raised.

(Select all acceptable answers.)

Students

3min
  -  
Easy  
  -  
CODE

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
   id INTEGER PRIMARY KEY,
   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.

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