SET clause in CREATE statement allows duplicate rows whereas MULTISET will not
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- The result of a SELECT statement can contain duplicate rows.
- The UNION ALL operator does not eliminate duplicate selected rows from the result set
- The UNION ALL operator does not eliminate duplicate selected rows from the result set.
- which table supports duplicate rows insertion?
- Fast Load can load the duplicate record in a multiset table.
- IGNORE DUPLICATE ROWS does not apply if there are any unique indexes in the table.
- Which of the following exception is raised when an insert or update attempts to create two rows with duplic...
- UNION query returns only distinct rows and UNION ALL may return duplicates.