The result of a SELECT statement can contain duplicate rows.Select one:a.Trueb.False

Answer

The correct answer is:

a. True

Explanation

In SQL, a SELECT statement retrieves data from a database and can return duplicate rows if there are no constraints or specifications in the query to eliminate them. By default, SQL will return all matching records, including duplicates, unless you use the DISTINCT keyword in your query to ensure that only unique records are returned. For example, the statement SELECT DISTINCT column_name FROM table_name; would return unique values from the specified column, excluding duplicates. Therefore, the presence of duplicate rows in the result set of a SELECT statement is true unless specified otherwise.