Common use cases for using an Intent in Android include:

Starting Activities: Launching a new screen or activity.
Passing Data: Sending data between activities.
Starting Services: Initiating background tasks.
Broadcasting Messages: Sending notifications to multiple components.
Receiving Results: Starting an activity for a result.
Implicit Intents: Requesting actions from other apps, like sharing content.

The main purpose of a Fragment in Android development is to represent a reusable portion of the user interface within an activity. Fragments allow for more modular UI design, enabling dynamic UI changes, better management of screen space, and the ability to create multi-pane layouts for different screen sizes, such as tablets and phones.

The main differences between the TRUNCATE and DELETE commands in SQL are:

Purpose:

DELETE: Removes specific rows from a table based on a condition (WHERE clause).
TRUNCATE: Removes all rows from a table without any conditions.
Performance:

DELETE: Slower, especially for large datasets, because it logs individual row deletions and can trigger triggers.
TRUNCATE: Faster, as it deallocates data pages and does not log individual row deletions.
Transaction Control:

DELETE: Can be rolled back if used within a transaction.
TRUNCATE: Cannot be rolled back in some database systems once executed, although it may be part of a transaction in others.
Identity Reset:

DELETE: Does not reset any identity columns.
TRUNCATE: Resets identity columns to the seed value.
Table Structure:

DELETE: Does not affect the table structure; constraints and triggers remain in place.
TRUNCATE: Maintains the table structure but removes all data.
In summary, use DELETE for conditional row removal and TRUNCATE for efficiently clearing a table’s data.