Most plugins that are installed into /wp-content/plugins need to be activated. However, it seems that if you drop scripts directly into /wp-content (object-cache.php comes to mind) they are activated automatically.