The select operation
A) combines relational tables to provide the user with more information than is otherwise available.
B) creates a subset consisting of columns in a table.
C) identifies the table from which the columns will be selected.
D) creates a subset consisting of all records in the file that meet stated criteria.

Question

Quizplus · Accepted Answer

The select operation creates a subset consisting of all records in the file that meet stated criteria. This is often done using a WHERE clause to specify the criteria. Option A is referring to the join operation, option B to the project operation, and option C is referring to the FROM clause.

The Select Operation