Blog Blog 齋

The real name of the exam is “Oracle E-Business Suite R12: Install, Patch and Maintain Applications“, and the certificate is called “Oracle EBS R12 Applications Database Administrator Certified Professional“. What long names!!

If you were looking for “brain dumps”, you came to a wrong page. There will be no sample questions / answers here. Instead, these are tips based-on the self-study for the exam. 

The book was divided into 4 parts, tackling 4 areas of Oracle tuning:”Data Model”, “SQL Code”, “Physical and Configuration” and “Database Statistics”. Personally, I would think the book has two main parts: application-level (part 1-2) and system-level (part 3-4).

When I read the application-level parts, I thought this is definitely one of the worst Oracle book I've seen. Actually, it is very likely the worst computer-related book in the universe. The book is filled with misconceptions, false facts and over-simplifications. If I were not intended to write this review, I would have given up reading it after at most 6 chapters. It seemed I was proof-reading the book. Fortunately I didn't buy the book, but borrowed it from the library.

上年九月考的試，成績尚未正式公佈，但剛在 prometric 網頁查到已經合格。換言之我將成為全球首批取得「Oracle EBS R12 Applications Database Administrator Certified Professional」（好長！）認證的其中一人。 恭喜恭喜！！

以往經驗，沒考的 cert 自動送上門，考了的卻三催四請才寄來，相信今次都不會例外。（尤其 Oracle 據說剛大裁員）

下一目標︰重考 Oracle 11g OCP（繼而一氣呵成考 OCM）？PMP？CISSP？MSc？MBA？…點好呢？

又或就此收咧。

拖延了差不多半年，昨天終於考了個試。

何解會拖延半年？說話我考的是所謂的 Beta Exam。正如電腦軟件，電腦考試也要經過測試，以找出有蟲、過深、過淺的問題。可能太少人報考關係，這個試原定四月頭完成 beta，經過再三延期，改了為十月尾完場。而小弟的溫書進度也跟隨著延期。

Don't be silly… You still need to install something. But not in Windows.

This article discuss how to run a virtual machine on a windows machine under a Linux LiveCD, using a virtualization software like VMWare or VirtualBox. As a result, it is possible to do whatever you want in the virtual machine, including run Oracle. Perfect when you are not allowed (or not preferred) to install something in your windows, but allowed reboot with CD and create some huge files.

Q: You have a table storing the materials and another table storing the consumer requests on the materials. Materials are stored in different batches, each containing a different quantity of stock. Both the material and consumer tables have a sequence field, indicating which material is to be consumed first and which request is to be served first respectively. You need to allocate the material to the consumers, allocating enough quantity. For example:

Material Table

Consumer Table

Expected Output

Summary:

Although dbca (Database Configuration Assistant) in Oracle 11g allow you to enable Database Vault during database creation. It seems to missed something and leave the database barely usable. This document discuss what's wrong and how to remedy (in my case).