View Oracle database properties

To check database properties, for example: default tablespace type, various nls parameters,
timezone etc run the following query:

SELECT *
FROM DATABASE_PROPERTIES;