Oracle Quizzes, Questions & Answers

Recent Quizzes

Are you an avid coder? We have a special Oracle quiz for you! Test your DDL and DML Knowledge with this super informative, interesting quiz! We are here to challenge your knowledge! Let's see how well you perform in this...

Questions: 10 | Attempts: 3865 | Last updated: Mar 13, 2024

Sample Question
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) Which three statements inserts a row into the table?

INSERT INTO employees VALUES (NULL, 'JOHN','Smith');

INSERT INTO employees( first_name, last_name) VALUES ('JOHN','Smith');

INSERT INTO employees VALUES ('1000','JOHN','NULL');

INSERT INTO employees(first_name,last_name, employee_id) VALUES ('1000, 'john','Smith');

INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'john',");

Oracle_test6

Oracle_Test6

This is a basic SQL test

Questions: 20 | Attempts: 1540 | Last updated: Mar 20, 2023

Sample Question
You issue the following query: SELECT salary "Employee Salary" FROM employees; How will the column heading appear in the result?

EMPLOYEE SALARY

EMPLOYEE_SALARY

Employee Salary

Employee_salary

Oracle Pl/SQL Quiz Questions And Answers!

Oracle PL/SQL Quiz Questions And Answers!

PL/SQL is a procedural language extension to Structured Query Language. You can take this Oracle PL/SQL quiz questions and answers and check your knowledge. The purpose of PL/SQL is to combine database language and procedural...

Questions: 30 | Attempts: 24121 | Last updated: Apr 29, 2024

Sample Question
Select incorrect variable declarations.

Foo_number varchar2(10);

Foo_text number(10);

Foo_char char(1) := 'Y';

Foo_time date;

Foo_text varchar2(10) := 'hello world';

Oracle Certified Associate Practice Quiz!

Do you want to become an Oracle Certified Associate (OCA)? Want to check how good is your practice level? The quiz below will help you to measure your competency level. So, what are you waiting for? Take this practice test and...

Questions: 30 | Attempts: 1764 | Last updated: Aug 21, 2023

Sample Question
Examine this procedure: CREATE PROCEDURE add_theater IS BEGIN INSERT INTO theater VALUES (35, 'Riverplace Theatre', '1222 River Drive, Austin, Tx.'); END; Which three statements about this procedure are true? (Choose three.)

The ADD_THEATER procedure is written in SQL.

The ADD_THEATER procedure can be shared by multiple programs.

The ADD_THEATER procedure will be stored in the database as a schema object.

The ADD_THEATER procedure will execute with the privileges of its owner, by default.

The ADD_THEATER procedure has three parts: the specification, the body, and the exception handler.

Oracle Basic Test! Trivia Questions Quiz

Oracle is a relational database management system (RDBMS) officially known as Oracle Database. This software is used by many Corporate IT companies which supports in keeping track and maintaining the database. This application...

Questions: 10 | Attempts: 2049 | Last updated: May 29, 2024

Sample Question
What is wrong with these statements?

Cursor cursor_name is

Select first-name into first_name1 from emp

Declare begin

Null; end;

None of above

« Previous 1 23Next »