…………….. is used to determine whether of a table contains duplicate rows.

Related MCQs

• Consider a hash table of size seven, with starting index zero, and a hash function (3x + 4)mod7. Assuming the hash table is initially empty, which of the following is the contents of the table when the sequence 1, 3, 8, 10 is inserted into the table using closed hashing? Note that ‘_’ denotes an empty location in the table.
• To eliminate duplicate rows ……………… is used
• Which of the following retains duplicate rows in the result of a query or in an Aggregate expression?
• In the SQL Cursor, which attribute is TRUE when a cursor has some remaining rows to fetch, and FALSE when a cursor has no rows left to fetch?
• A lock that allows concurrent transactions to access different rows of the same table is known as a
• A lock that allows concurrent transactions to access different rows of the same table is known as a
• A           is a query that retrieves rows from more than one table or view:
• A lock that allows concurrent transactions to access different rows of the same table is known as a
• ___________removes all rows from a table without logging the individual row deletions.
• The command to remove rows from a table ‘CUSTOMER’ is __________________