Oracle Database Interview MCQs with answers Page - 1

You will find multiple-choice questions (MCQs) related to #Oracle Database Interview here. Go through these questions to prepare effectively for your upcoming exams and interviews.

To view the correct answer for any question, simply click the "Show Answer" button.

Have a question to share? Click on "Add Question" to contribute!

A

Arogya • 1.97K Points
Master

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 • 1.97K Points
Master

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 • 1.97K Points
Master

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 • 1.97K Points
Master

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

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

A

Arogya • 1.97K Points
Master

Q. Which clause is used to filter grouped results?

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

A

Arogya • 1.97K Points
Master

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 • 1.97K Points
Master

Q. Which operator is used for pattern matching?

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

A

Arogya • 1.97K Points
Master

Q. Which keyword removes duplicate records?

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

A

Arogya • 1.97K Points
Master

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 • 1.97K Points
Master

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

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

Browse More Tags

Click on tag to learn MCQs of that tag.
What's Tag

As you may know, questions are organized under broad categories. Each category can include various types of questions. For example, the "History" category might contain questions about the Revolt of 1857, Shivaji Maharaj, Ancient History, Buddhism, and more.

To further refine this organization, we've introduced tags, which act as sub-categories to group questions more specifically.

Verified users can add tags to any question. If you have any suggestions regarding this system, we'd love to hear from you. Contact Us

Learn More