McAfee Oracle SQL and PLSQL Developer Interview Questions and Answers

Truncate is a DDL command that removes all rows from a table, while delete is a DML command that removes specific rows.

• Truncate is faster than delete as it does not generate undo logs.

• Truncate resets the high water mark of the table, while delete does not.

• Truncate cannot be rolled back, while delete can be rolled back using a transaction.

• Truncate does not fire any triggers, while delete does.

• Truncate does not require a

Set operators are used to combine the result sets of two or more SELECT statements.

• Set operators include UNION, UNION ALL, INTERSECT, and MINUS.

• UNION combines the result sets of two SELECT statements, removing duplicates.

• UNION ALL combines the result sets of two SELECT statements, including duplicates.

• INTERSECT returns only the rows that appear in both result sets.

• MINUS returns only the rows that appear in the first re