In a relational database, the three basic operations used to develop useful sets of data are
A) select, project, and where.
B) select, join, and where.
C) select, project, and join.
D) select, from, and join.

Question

Quizplus · Accepted Answer

In a relational database, the three basic operations are:

1. Select: It retrieves a subset of rows from a table based on a specified condition.
2. Project: It retrieves a subset of columns from a table, which is useful when you want to view specific columns of data only.
3. Join: It combines two or more tables into a single table based on a related column between them.

Therefore, the correct choice is C, which includes all three of these basic operations.

In a Relational Database, the Three Basic Operations Used to Develop