Question

When combining the results of two SELECT statements with the MINUS keyword, duplicate rows are suppressed in the results.

a) EXCEPT
b) NOT IN
c) UNIQUE
d) DIFFERENCE

Answer 1

The correct keyword to combine the results of two SELECT statements and suppress duplicate rows is A)'EXCEPT', known in some databases as 'MINUS'.

Step-by-step explanation:

The question pertains to SQL, a programming language used for managing and manipulating databases. When combining the results of two SELECT statements, to make sure that the resulting set does not include duplicate rows from the subtraction of the two sets, we use a specific SQL keyword. The correct keyword is a) EXCEPT, in some database systems known as MINUS. The words b) NOT IN, c) UNIQUE, and d) DIFFERENCE serve different purposes in SQL.

The EXCEPT keyword returns the distinct rows from the first SELECT statement that are not in the results of the second SELECT statement. If the intention is to use a keyword that suppresses duplicate rows in the results when combining two SELECT statements, EXCEPT or MINUS (depending on the database system) would be employed.