Hive and HCatalog require a database to use as a metadata store and come with an embedded Derby database by default.
Oozie requires a database to use as a metadata store and comes with an embedded Derby database by default.
Ambari requires a database to use for storing cluster configuration information and comes with an embedded PostgreSQL database by default.