Which command is used to retrieve data from a database? MCQ with Answer and Explanation

Question Report Error

Which command is used to retrieve data from a database?

A. DELETE

B. SELECT

C. INSERT

D. UPDATE

Answer: Option B

Solution (By JKExamLibrary)

The SELECT statement is used in SQL to query and retrieve data from tables.

This question belongs to: Computer Database Management System (DBMS)

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1 Report Error

Which SQL clause is used to filter groups after grouping?

A. HAVING

B. ORDER BY

C. GROUP BY

D. WHERE

View Answer & Solution Discuss

Correct Answer: Option A

Explanation:
HAVING is used to filter groups based on aggregate conditions, applied after GROUP BY.

This question belongs to: Computer Database Management System (DBMS)

Question #2 Report Error

Which of the following is a valid SQL data type for storing decimal numbers with exact precision?

A. REAL

B. DOUBLE

C. DECIMAL

D. FLOAT

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
DECIMAL (or NUMERIC) is used for exact numeric values with fixed precision and scale. FLOAT, DOUBLE, REAL are approximate.

This question belongs to: Computer Database Management System (DBMS)

Question #3 Report Error

Which SQL set operator combines the output of two queries but preserves all duplicate rows without filtering them?

A. UNION

B. INTERSECT

C. UNION ALL

D. MINUS

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
UNION ALL appends the results of multiple SELECT queries together without performing any deduplication, making it faster than UNION.

This question belongs to: Computer Database Management System (DBMS)

Explore All Database Management System (DBMS) MCQs