Intents in Android are used to activate components such as Activities, Services, and Broadcast receivers. Intents are not used for activating or managing SQLite database connections. Database connections are typically managed using classes like SQLiteOpenHelper and ContentProvider.