I am preparing for 1Z0-042 OCA certification, Oracle 10g and when doing practice exams have persistently run into question I can summarize as follows:
When creating a new Oracle 10g R2 database via script ("CREATE DATABASE" etc.) with a parameter file, if UNDO_MANAGEMENT=AUTO is in pfile and no UNDO_TABLESPACE is specified when creating the database, I get an error message: "ORA-30045: No undo tablespace name specified". This is on a RHEL 4.7 machine. Various test engines that I have used, however, insist that "...an undo tablespace named SYS_UNDOTBS will be created automatically" when the above conditions are encountered.
This strikes me as the type of question that might well occur on the certification exam; ordinarily I would go with my experience in a test environment (i.e., the error message) but I have seen the item about a default undo tablespace often enough that I am not sure - might be release 1 vs. 2, OMF vs. user manual file management or some other issue with which I am unfamiliar.
Any guidance as to the above situation would be most welcome. TIA.
Like you say, the exam is written mostly against release 1, so you really need to test the repose there. Also, the OMF issue is pretty important as most new installations assume you are using OMF.
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: https://oracle-base.com
My blog: https://oracle-base.com/blog
Who is online
Users browsing this forum: No registered users and 1 guest