Oracle Quizzes, Questions & Answers

Recent Quizzes

Here you will find questions related to Oracle db, SQL, PL/SQL. Questions are not in specific order and their is no time limit to complete this quiz.

Questions: 7 | Attempts: 1456 | Last updated: Mar 22, 2023

Sample Question
Which Analytical Function Has Been Added In Oracle 11g?

REGEXP_SUBSTR

REGEXP_INSTR

REGEXP_COUNT

REGEXP_LIKE

Oracle Database 11g Online Test From Dbalounge

Oracle Database 11g Online Test from DBALounge

Test your knowledge on Oracle Database 11g by taking the Online Examination on 11g DBA. The Exam requires FREE Registration.

Questions: 6 | Attempts: 2277 | Last updated: Mar 21, 2023

Sample Question
Which of the following parameters is used to display an entire range of supported languages, as well as all other globalization options?

V$NLS_LANGUAGES

NLS_LANG

NLS_DATABASE_PARAMETERS

V$NLS_VALID_VALUES

NLS_INSTANCE_PARAMETERS

Oracle Test 5

Oracle Test 5 assesses knowledge in SQL queries, table operations, and data manipulation within Oracle databases. It evaluates understanding of complex SQL statements, table creation, rollback operations, and conditional data...

Questions: 50 | Attempts: 2209 | Last updated: Mar 22, 2023

Sample Question
1. Evaluate the SQL statement: 1 SELECT a.emp_name, a.sal, a.dept_id, b.maxsal 2 FROM employees a, 3 (SELECT dept_id, MAX(sal) maxsal 4. FROM employees 5 GROUP BY dept_id) b 6 WHERE a.dept_id = b.dept_id 7 AND a.sal < b.maxsal; What is the result of the statement?

The statement produces an error at line 1.

The state ment produces an error at line 3.

The statement produces an error at line 6.

The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all departments that pay less salary then the maximum salary paid in the company.

The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all employees who earn less than the maximum salary in their department.

Oracle Database MCQ Quiz Model Test

Hey, do you have a good understanding of Oracle? If yes, then you must check out this awesome 'Oracle Database MCQ Quiz' that we've created below. As you would know, Oracle is a multi-model relational...

Questions: 17 | Attempts: 2078 | Last updated: Mar 29, 2023

Sample Question
The employee table contains these columns: ID NUMBER(9) LAST_NAME VARCHAR2(25) FIRST_NAME VARCHAR2(25) COMMISSION NUMBER(7,2) You need to display the current commission for all employees. Desired results are: 1. Display the commission multiplied by 1.5 48 2. Exclude employees with zero commission. 3. Display a zero for employees with null commission value. Evaluate this SQL statement. SELECT id, last_name, first_name, commission*1. 5 FROM employee WHERE commission <>0; Which of the desired results does the statement provide?

All the desired results.

Two of the desired results.

One of the desired results

A syntax error.

Quiz Questions Over Oracle Software

Quiz questions over oracle software

This quiz focuses on Oracle software, assessing knowledge on database structures, integrity constraints, and PL\/SQL syntax. It is designed to validate understanding of Oracle database management, essential for IT professionals...

Questions: 20 | Attempts: 213 | Last updated: Mar 17, 2023

Sample Question
Databases overall structure is maintained in a file called

Redolog file

Data file

Control file

All of the above

Oracle Mock Test 1

oracle mock test 1

This Oracle mock test assesses knowledge of SQL commands, data manipulation, and database management concepts. It includes questions on SQL functions, joins, and limitations, catering to learners aiming to enhance their Oracle...

Questions: 30 | Attempts: 458 | Last updated: Mar 22, 2023

Sample Question
Evaluate the SQL statement: SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual; What will be displayed?

0

1

0.00

An error statement

Trivia Questions: Oracle Exadata Database Machine! Quiz

Do you know anything about the Oracle Database Machine? Would you like to try this quiz? The Oracle Exadata Database Machine is a processing program optimized for running Oracle Databases. Exadata is a joint hardware and...

Questions: 68 | Attempts: 457 | Last updated: Mar 20, 2023

Sample Question
What model of the Exadata Database Machine comes with 3 Infiniband switches?

Quarter Rack of X2-2

Half Rack of X2-2

Full Rack of X2-2

Full Rack of X2-8

Oracle Mock Test 2 (SQL +arch)

Oracle Mock Test 2 (SQL +Arch)

Are you learning the Oracle software? Do you want to test your knowledge about Oracle? Try this interesting and well-researched Oracle mock test 2 (SQL + Arch). With this test, you'll get the chance to test your understanding...

Questions: 23 | Attempts: 7028 | Last updated: May 10, 2023

Sample Question
Which SELECT statement should you use if you want to display unique combinations of the POSITION and MANAGER values from the EMPLOYEE table?

SELECT DISTINCT position, manager FROM employee;

SELECT position, manager DISTINCT FROM employee;

SELECT position, manager FROM employee;

SELECT position, DISTINCT manager FROM employee;

Oracle Mock Test

The 'Oracle Mock Test' assesses knowledge on Oracle SQL and database management, focusing on SQL statements, table constraints, and query functions. It's designed for learners to validate their understanding and readiness for...

Questions: 20 | Attempts: 1144 | Last updated: Mar 18, 2023

Sample Question
Which two statements are true regarding the default behavior of the ORDER BY clause? (Choose two.)

Null values are left out of the sort.

Character values are displayed from Z to A.

Date values are displayed with the earliest value first.

Null values are displayed last for descending sequences.

Numeric values are displayed with the lowest values first.

What Do You Know About Oracle?

What do you know about Oracle?

Explore your knowledge of Oracle, focusing on cloud computing, platform services, and identity management. Assess key concepts like PaaS, public cloud services, and Oracle WebCenter Suite through true\/false and multiple-choice...

Questions: 10 | Attempts: 133 | Last updated: May 2, 2024

Sample Question
Cloud computing is a term for computing platforms that provide flexible, scalable resources that are accessed over a network.

True

False

« Previous 123 Next »