Databases can be deleted like any other object, using the DROP SQL statement.
In order to drop the database it must be mounted and closed, mounted
exclusively (not in shared mode) and flagged as RESTRICTED.
The easiest way to do this is using EM (but then most things are). Once
your database is in the proper state, just issuing the SQL "drop test"
will destroy the test database we created.