Quote Originally Posted by carslm View Post
I'm looking to do the Oracle 10g OCP exam and I am using the book OCP Certification All-in-one Exam Guide by John Watson and Damir Bersinic.

In Chapter 3: Creating an Oracle Database, there is a question as follows:

8. If you do not specify an UNDO tablespace on your CREATE DATABASE command, what will happen? (Choose the best answer.)

A. The command will fail because an UNDO tablespace is required.
B. The command will succeed, and a default UNDO tablespace will be created for you.
C. The command will succeed, but you must create an UNDO tablespace later.
D. The command will succeed, and you may create an UNDO tablespace later.

I answered B because I have tried doing this on a Sun server and just issued CREATE DATABASE. A default tablespace called SYS_UNDOTS is created.

However the book gived the answer as D. It states. "Unlike the SYSAUX tablespace, an UNDO tablespace really is optional, though as you'll see, it is a great performance and manageability feature." This is a load of bull.

Now my question is this typical in the real OCP exam whereby some Questions have a Answer that is blatantly wrong but is for OCP purposes decided as the correct answer.
your choice and the answer D are both true, database can have more than one undo tablespace but one of the them can be active at any time.If you do not create tablespace explicitly tablespace Oracle creates SYS_UNDOTBS undo tablespace for you.

As far as I recognize the sybex is very useable books on certification.