Project Assignee Interview Questions and Answers

Drop deletes the table and its data while truncate deletes only the data.

• Drop is a DDL command while truncate is a DML command.

• Drop cannot be rolled back while truncate can be rolled back.

• Drop is slower than truncate as it deletes the table structure as well.

• Drop requires more permissions than truncate.

• Example: DROP TABLE table_name; TRUNCATE TABLE table_name;

Abstraction is the process of simplifying complex systems by focusing on essential features.

• Abstraction involves hiding unnecessary details and emphasizing important ones.

• It helps in managing complexity and improving efficiency.

• Examples include abstract classes and interfaces in object-oriented programming.

• Abstraction is also used in art, where artists simplify complex subjects to create a more impactful image.

• In mathematics, abstraction involves generalizing concepts to make...read more