The rows of the result relation produced by a SELECT statement can be sorted, but only by one column.

Solution (By Examveda Team)

Option A: False - This option is incorrect. In SQL, the rows of the result relation produced by a SELECT statement can be sorted by multiple columns using the ORDER BY clause. The ORDER BY clause allows specifying one or more columns and their sort order (ascending or descending). This enables sorting based on multiple criteria, not just one column.

Option B: True - This option is correct. The rows returned by a SELECT statement in SQL can indeed be sorted using the ORDER BY clause. While traditionally sorting is done by one column, SQL allows specifying multiple columns in the ORDER BY clause to achieve sorting based on more than one criterion.

Conclusion:
The statement "The rows of the result relation produced by a SELECT statement can be sorted, but only by one column" is Option B: False. SQL supports sorting of result rows using the ORDER BY clause, which can specify multiple columns for sorting. Therefore, the correct answer is False.