Oracle Quizzes, Questions & Answers

Recent Quizzes

The 'Grand Test SQL' quiz assesses knowledge of SQL queries in an Oracle environment, focusing on query syntax, data manipulation, and ANSI compliance. It tests practical skills essential for database management and IT roles.

Questions: 40 | Attempts: 1085 | Last updated: Mar 22, 2023

Sample Question
) You issue the following select statement in Oracle: SQL> select e.empno, e.ename, d.loc from emp e, dept d where e.deptno = d.deptno and substr(e.ename,1,1) = 'S';Which of the following statements identifies an ANSI-compliant equivalent statement usable on the Oracle database?

Select empno, ename, loc from emp join dept on emp.deptno = dept.deptno where substr(emp.ename,1,1) = 'S';

Select empno, ename, loc from emp, dept on emp.deptno = dept.deptno where substr(emp.ename,1,1) = 'S';

Select empno, ename, loc from emp join dept where emp.deptno = dept.deptno and substr(emp.ename,1,1) = 'S';

Select empno, ename, loc from emp join dept on emp.deptno = dept.deptno and substr(emp.ename,1,1) = 'S';

Oracle Test1

Oracle Test1 assesses knowledge on SQL commands and Oracle database management. It covers table creation, data types, and table manipulation, focusing on syntax accuracy and command effects, enhancing database handling skills.

Questions: 12 | Attempts: 644 | Last updated: Mar 21, 2023

Sample Question
Evaluate the set of SQLst: CREATE TABLE dept (deptno NUMBER(2), dname VARCNAR2(14), 1oc VARCNAR2 (13)); ROLLBACK; DESCRIBE DEPT What is true about the set?

The DESCRIBE DEPT statement displays the structure of the DEPT table.

The ROLLBACK statement frees the storage space occupies by the DEPT table.

The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.

The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.

Oracle_test6

Oracle_Test6

Oracle_Test6 assesses understanding of SQL queries in Oracle, focusing on data manipulation and query outcomes. Key skills include interpreting SQL syntax and functionality, as well as precision in data handling. Ideal for...

Questions: 20 | Attempts: 1543 | 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: 24208 | 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: 1768 | 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: 2087 | 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 »