DBA Basics

• View common db properties

SELECT Property_Name, Property_Value, Description
FROM Database_Properties

• Oracle Apps Release/Version from backend?

SELECT Release_name FROM Fnd_Product_Groups

• Multi-Org enabled?

SELECT Multi_Org_Flag FROM Fnd_Product_Groups

• Multilingual?

SELECT Multi_Lingual_Flag FROM Fnd_Product_Groups

• MRC Implemented?

SELECT Multi_Currency_Flag FROM Fnd_Product_Groups

• How do I find the tablespace name where I need to create the table in xyz schema?
  

Get the tablespace name using the below query:
SELECT * FROM dba_users WHERE username = 'xyz'
Tablespace details if required, can be viewed from dba_tablespaces table.