You can restrict the output from a join to include only certain columns by using the ____ command.
A) DELETE
B) UNION
C) PROJECT
D) INTERSECT

Question

You can restrict the output from a join to include only certain columns by using the ____ command.​
A) ​DELETE
B) ​UNION
C) ​PROJECT
D) ​INTERSECT

Quizplus · Accepted Answer

The PROJECT command is used to restrict the output from a join to include only certain columns. It selects specified columns from a table and returns a new table with the selected columns. The DELETE command is used to delete rows from a table. The UNION command is used to combine the results of two or more SELECT statements into a single result set. The INTERSECT command is used to return the common rows between two SELECT statements.

You Can Restrict the Output from a Join to Include