If $db_prefix is "assumed to be a string", then does Drupal automatically sort what is a sharable table in the DB?
$db_prefix can either be a string or an array, have a look at the documentation: Share a single database across multiple sites, the db_prefix_tables function take care of this job.