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.
A D V E R T I S E M E N T
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.