Answer & Solution
Answer: Option
E
Solution:
The PROJECT command is like taking that big table and saying:
"I only want to see these specific columns (fields) from it."
It creates a BRAND NEW TABLE that only contains the columns you asked for.
Let's look at the options:
Option A: more fields than the original table
This is INCORRECT. When you use PROJECT, you are *selecting* fields that already exist. You can choose to see *fewer* fields or *all* fields from the original table, but you can never magically create *new* fields that weren't there before. So, it will never have *more* fields.
Option B: more rows than the original table
This is also INCORRECT. The PROJECT command focuses on which *columns* you see. It doesn't add new entries (rows) to your table. In fact, if selecting fewer columns makes some rows look exactly the same, the PROJECT command usually removes those duplicate rows. This means the new table might even have *fewer* rows, but never *more*.
Option C: both (a) and (b)
Since both (a) and (b) are incorrect, this option is also INCORRECT.
Option D: all the fields of master table
This is partially true in a specific scenario, but it's NOT generally what PROJECT does or its defining characteristic. You *can* use PROJECT to select *all* fields from the original table, but its main purpose is to let you pick a *subset* of fields. If you always wanted all fields, you wouldn't need a special command to "project" them; you'd just use a simple selection of everything. The command's flexibility means it *can* select all, but it doesn't *always* do so, and it doesn't *have* to. It's about *choosing* fields.
Option E: None of the above
This is the CORRECT answer.
The PROJECT command creates a new table that has:
* Fewer or the same number of fields as the original table (never more).
* Fewer or the same number of rows as the original table (never more, due to duplicate removal).
So, none of the options A, B, or D accurately describe the general outcome of the PROJECT command.
