Protocol Marine Services Junior Accounts Executive Interview Questions and Answers

Truncate removes all records from a table, while drop deletes the table itself.

• Truncate is a DDL command, while drop is a DDL command.

• Truncate is faster than drop as it does not log individual row deletions.

• Truncate can be rolled back, while drop cannot be rolled back.

• Truncate resets the identity seed of the table, while drop does not.

• Example: TRUNCATE TABLE TableName; DROP TABLE TableName;

I am currently earning $60,000 per year.

• My present salary is $60,000 per year

• I am currently earning $5,000 per month

• I received a 10% raise last year, bringing my salary to $60,000