Oracle Database MCQs with answers Page - 4

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.19K Points
Extraordinary

Q. Output?
SELECT ROUND(12.345,2) FROM dual;

  • (A) 12.34
  • (B) 12.35
  • (C) 12.3
  • (D) 12

A

Arogya • 3.19K Points
Extraordinary

Q. Output?
SELECT TRUNC(12.987,2) FROM dual;

  • (A) 12.98
  • (B) 12.99
  • (C) 12.9
  • (D) 13

A

Arogya • 3.19K Points
Extraordinary

Q. Output?
SELECT 'HELLO'||'WORLD' FROM dual;

  • (A) HELLO WORLD
  • (B) HELLOWORLD
  • (C) HELLO+WORLD
  • (D) Error

A

Arogya • 3.19K Points
Extraordinary

Q. Output?
SELECT POWER(2,3) FROM dual;

  • (A) 6
  • (B) 8
  • (C) 9
  • (D) 5

A

Arogya • 3.19K Points
Extraordinary

Q. Output?
SELECT CEIL(4.2) FROM dual;

  • (A) 4
  • (B) 5
  • (C) 6
  • (D) Error

A

Arogya • 3.19K Points
Extraordinary

Q. Output?
SELECT FLOOR(4.8) FROM dual;

  • (A) 4
  • (B) 5
  • (C) 3
  • (D) Error

A

Arogya • 3.19K Points
Extraordinary

Q. Output?
SELECT SUBSTR('DATABASE',1,4) FROM dual;

  • (A) DATA
  • (B) ATAB
  • (C) BASE
  • (D) DATAB

A

Arogya • 3.19K Points
Extraordinary

Q. Output?
SELECT INSTR('ORACLE','A') FROM dual;

  • (A) 2
  • (B) 3
  • (C) 4
  • (D) 5

A

Arogya • 3.19K Points
Extraordinary

Q. Output?
SELECT ABS(-25) FROM dual;

  • (A) -25
  • (B) 25
  • (C) 0
  • (D) Error

A

Arogya • 3.19K Points
Extraordinary

Q. Output?
SELECT CASE WHEN 5>3 THEN 'YES' ELSE 'NO' END FROM dual;

  • (A) YES
  • (B) NO
  • (C) NULL
  • (D) Error

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.