Creating Databases

When you design a web site that requires a database(s) and you’re using a hosting company, do you upload the database with the web site, or is it already on the server? If so, is it configured and accessed through MySQL or SQL? Do I need to know MySQL to test my site on a virtual server?

Thank You!
Beth