Oracle Database MCQs with answers Page - 2

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 query shows department name and employee name?

  • (A) Using join between EMPLOYEES and DEPARTMENTS
  • (B) Only EMPLOYEES table
  • (C) Only DEPARTMENTS table
  • (D) Using sequence

A

Arogya • 3.49K Points
Extraordinary

Q. Which SQL function converts employee name to uppercase?

  • (A) LOWER()
  • (B) UPPER()
  • (C) INITCAP()
  • (D) CAPITAL()

A

Arogya • 3.49K Points
Extraordinary

Q. Which function returns current system date?

  • (A) NOW()
  • (B) GETDATE()
  • (C) SYSDATE
  • (D) TODAY()

A

Arogya • 3.49K Points
Extraordinary

Q. Which clause limits number of rows returned?

  • (A) ROWNUM
  • (B) LIMIT
  • (C) TOP
  • (D) FETCH

A

Arogya • 3.49K Points
Extraordinary

Q. Which function handles NULL values?

  • (A) NVL()
  • (B) NULLIF()
  • (C) COALESCE()
  • (D) ISNULL()

A

Arogya • 3.49K Points
Extraordinary

Q. Which statement increases salary of all employees by 10%?

  • (A) UPDATE employees SET salary = salary + 10;
  • (B) UPDATE employees SET salary = salary * 1.10;
  • (C) INSERT salary + 10;
  • (D) ALTER salary;

A

Arogya • 3.49K Points
Extraordinary

Q. Which command removes all rows but keeps table structure?

  • (A) DELETE
  • (B) DROP
  • (C) TRUNCATE
  • (D) REMOVE

A

Arogya • 3.49K Points
Extraordinary

Q. Which subquery operator checks existence of rows?

  • (A) IN
  • (B) EXISTS
  • (C) ANY
  • (D) ALL

A

Arogya • 3.49K Points
Extraordinary

Q. Which index improves search performance on salary column?

  • (A) Unique index
  • (B) Normal index
  • (C) Bitmap index
  • (D) Foreign index

A

Arogya • 3.49K Points
Extraordinary

Q. Which clause groups employees by department?

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

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.