In SQL, which clause is used to specify the table(s) from which to retrieve data? MCQ with Answer and Explanation

Question

Share Report Error

In SQL, which clause is used to specify the table(s) from which to retrieve data?

A. GROUP BY

B. FROM

C. SELECT

D. WHERE

Answer: Option B

Solution (By JKSSB Mock Tests)

The FROM clause identifies the table(s) from which data is to be selected.

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

Request complete Subject PDF

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1

What is a column in a relational database table formally called?

A. Attribute

B. Degree

C. Entity

D. Tuple

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
A column in a database table represents a property or characteristic of the entity and is formally known as an attribute.

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

Question #2

What is a relation in relational database terms?

A. A key

B. A row

C. A table

D. A column

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
In the relational model, a relation is a table consisting of rows and columns.

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

Question #3

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

A. UNION

B. UNION ALL

C. MINUS

D. INTERSECT

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

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