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. WHERE

B. FROM

C. GROUP BY

D. SELECT

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

Share Report

In an Entity-Relationship (ER) diagram, what geometric shape is used to represent an entity type?

A. Rectangle

B. Ellipse

C. Triangle

D. Diamond

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
In standard ER modeling notation, rectangles are used to represent entity sets or entity types.

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

Question #2

Share Report

Which of the following is a non-aggregate function in SQL?

A. LENGTH()

B. COUNT()

C. SUM()

D. AVG()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
LENGTH() (or LEN()) is a string function that returns the length of a string, not an aggregate. SUM, COUNT, AVG are aggregates.

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

Question #3

Share Report

In SQL, what does the 'IS NULL' operator check?

A. Whether a value is empty string

B. Whether a value equals NULL

C. Whether a value is missing (null)

D. Whether a value is zero

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
IS NULL is used to test for NULL values, because NULL is not equal to anything.

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

Explore All Database Management System (DBMS) MCQs