OCP Example question from the book OCP Certification All-in-one Exam Guide
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.