Which clause lists the attributes desired in answer to the query?

The correct answer is B. Select. The select clause corresponds to the projection operation of the relational algebra. It is used to list the attributes desired in the result of a query. For example, the query select name, age from student will return the name and age attributes of all tuples in the student…

IT Operations and Infrastructure Management

Question

Options

AFrom
BSelect
CEdit
DWhere

How the community answered

(62 responses)

A
3% (2)
B
85% (53)
C
10% (6)
D
2% (1)

Explanation

The select clause corresponds to the projection operation of the relational algebra. It is used to list the attributes desired in the result of a query. For example, the query select name, age from student will return the name and age attributes of all tuples in the student relation.

Topics

#SQL#SELECT clause#query language#database retrieval

Community Discussion

No community discussion yet for this question.

Full CITM-001 Practice