Oracle Database MCQs with answers Page - 1

Here, you will find a collection of MCQ questions on Oracle Database. Go through these questions to enhance your preparation for upcoming examinations and interviews.

To check the correct answer, simply click the View Answer button provided for each question.

Have your own questions to contribute? Click the button below to share your MCQs with others!

+ Add Question

A

Arogya • 3.49K Points
Extraordinary

Q. Which column in the HR.EMPLOYEES table is a primary key?

  • (A) EMAIL
  • (B) EMPLOYEE_ID
  • (C) DEPARTMENT_ID
  • (D) JOB_ID

A

Arogya • 3.49K Points
Extraordinary

Q. Which SQL retrieves employees earning more than the average salary?

  • (A) SELECT * FROM employees WHERE salary > AVG(salary);
  • (B) SELECT * FROM employees WHERE salary > (SELECT AVG(salary) FROM employees);
  • (C) SELECT AVG(salary) FROM employees;
  • (D) SELECT * FROM employees GROUP BY salary;

A

Arogya • 3.49K Points
Extraordinary

Q. Which join returns employees even if they are not assigned to any department?

  • (A) INNER JOIN
  • (B) LEFT OUTER JOIN
  • (C) RIGHT JOIN
  • (D) SELF JOIN

A

Arogya • 3.49K Points
Extraordinary

Q. Which function returns number of employees in each department?

  • (A) SUM
  • (B) COUNT
  • (C) AVG
  • (D) MAX

A

Arogya • 3.49K Points
Extraordinary

Q. Which clause is used to filter grouped results?

  • (A) WHERE
  • (B) HAVING
  • (C) GROUP BY
  • (D) ORDER BY

A

Arogya • 3.49K Points
Extraordinary

Q. Find second highest salary in EMPLOYEES table.

  • (A) SELECT MAX(salary) FROM employees;
  • (B) SELECT MAX(salary) FROM employees WHERE salary < (SELECT MAX(salary) FROM employees);
  • (C) SELECT salary FROM employees;
  • (D) SELECT MIN(salary) FROM employees;

A

Arogya • 3.49K Points
Extraordinary

Q. Which operator is used for pattern matching?

  • (A) IN
  • (B) LIKE
  • (C) BETWEEN
  • (D) EXISTS

A

Arogya • 3.49K Points
Extraordinary

Q. Which keyword removes duplicate records?

  • (A) UNIQUE
  • (B) DISTINCT
  • (C) REMOVE
  • (D) DELETE

A

Arogya • 3.49K Points
Extraordinary

Q. Which clause sorts employees by salary descending?

  • (A) ORDER BY salary ASC
  • (B) ORDER BY salary DESC
  • (C) GROUP BY salary DESC
  • (D) SORT salary

A

Arogya • 3.49K Points
Extraordinary

Q. Which constraint ensures department must exist before employee assignment?

  • (A) PRIMARY KEY
  • (B) FOREIGN KEY
  • (C) CHECK
  • (D) UNIQUE

Add MCQ in this Category

If you want to share an MCQ question in this category, it's a great idea! It will be helpful for many other students using this website.

Share Your MCQ

Browse Categories

Click on category to learn MCQs of that category.