Ok, what are the mandatory tablespaces in oracle 11g. My research has lead me to believe there are three of them: System, Sysaux, and Undo. However since I am taking the OCA and all the questions(and articles) I have read about mandatory spaces and answered only say two spaces are mandatory, and depending on where question came from the answer is different.
System is mandatory. That is a fact and undisputed.
The Sysaux and Undo tablespaces are the ones in question. Which one? Again my research has lead me to believe all three are, but oracles documentation is unhelpful at this point(or maybe I am using the wrong keywords in search?) and the practice questions lead me to believe that the test is looking for two tablespaces.
Best Answer
You will have to examine how the question is worded. By default 11g will create all three tablespaces. You can however create a database with only SYSTEM and SYSAUX. Technically speaking you can upgrade pre-10g database and not add SYSAUX, or remove the SYSAUX tablespace after the database is created and therefore have a database with only a SYSTEM tablespace, but you would be ill advised to do so and I really don't think they would look for that in an answer.
From the 11.2 Administration Guide:
From another section of the Administration Guide:
From the 10.2 Concepts Guide:
From the 10.1 SQL Reference:
From the 10.1 Administrators Guide:
http://oradbpedia.com/wiki/The_SYSAUX_Tablespace has this take:
Earlier versions did not have a SYSAUX tablespace: