Oracle Database MCQs with answers Page - 3

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 • 2.57K Points
Extraordinary

Q. EMP table salaries: 1000, 2000, 3000, 4000. What is output?
SELECT AVG(salary) FROM emp;

  • (A) 2500
  • (B) 2000
  • (C) 3000
  • (D) 1000

A

Arogya • 2.57K Points
Extraordinary

Q. What will be output?
SELECT COUNT(*) FROM emp WHERE salary > 2000; (salaries:1000,2000,3000,4000)

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

A

Arogya • 2.57K Points
Extraordinary

Q. What is output?
SELECT NVL(NULL,5) FROM dual;

  • (A) NULL
  • (B) 5
  • (C) 0
  • (D) Error

A

Arogya • 2.57K Points
Extraordinary

Q. What is output?
SELECT LENGTH('ORACLE') FROM dual;

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

A

Arogya • 2.57K Points
Extraordinary

Q. Output?
SELECT UPPER('oracle') FROM dual;

  • (A) oracle
  • (B) ORACLE
  • (C) Oracle
  • (D) error

A

Arogya • 2.57K Points
Extraordinary

Q. Output?
SELECT 10/2 FROM dual;

  • (A) 2
  • (B) 5
  • (C) 10
  • (D) 0

A

Arogya • 2.57K Points
Extraordinary

Q. Output?
SELECT MOD(10,3) FROM dual;

  • (A) 1
  • (B) 2
  • (C) 3
  • (D) 0

A

Arogya • 2.57K Points
Extraordinary

Q. Output?
SELECT SYSDATE FROM dual;

  • (A) System date and time
  • (B) Error
  • (C) Only date
  • (D) NULL

A

Arogya • 2.57K Points
Extraordinary

Q. Output?
SELECT 5*NULL FROM dual;

  • (A) 0
  • (B) 5
  • (C) NULL
  • (D) Error

A

Arogya • 2.57K Points
Extraordinary

Q. Output?
SELECT COUNT(NULL) FROM dual;

  • (A) 1
  • (B) 0
  • (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.