drapeko

One lite practicable idea for organizing version control tree for database development  is presented below:

The example of the svn tree is presented below:

/svn
  /features
    /user
	  /enable
	    create_user.sql
		create_user_permissions.sql
		pkg_user.pkb
		pkg_user.pks
	  /disable
	    drop_user.sql
	    drop_user_permissions.sql
	/comments
	 ...
  /scripts
	create_user_all.php
    drop_user_all.php
	recreate_database.php

The root directory consists of “features” and “scripts” dirs:

• Features – Logical functional units; a list of features we have (for example, a user or comments)
  • Each feature can be divided into “enable” and “disable” SQL scripts
    • Each enable/disable dir consists of the list of SQL scripts

• Scripts – List of scripts (php/perl/bash etc) that aggregate the features files into one sql file. The output of the script is the SQL file that contains all the SQL statements you need to enable/disable the feature.

DB developers work result is a list of SQL and pl/bash scripts for different variations (e.g. creates for empty db, patches et.

I took Oracle beta 1z1-146 exam in the end of January, 2009. Several days ago I checked prometric.com and discovered that this exam was passed. Now I’m one of the first Oracle Advanced PL/SQL Developer Certified Professional all over the world!!! it’s my second OCP :)

I did not find any dumps, any mock exams or any sample questions, while I was preparing for this exam. I used only these http://rapidshare.com/files/127182353/D52601GC10_netbks.com.rar official Oracle preparation slides (remember to switch comments – it’s a book). 1z1-146 exam was really tough. 165 questions in 180 minutes. Production exam requirements: time – 90 min, questions – 68. There is a difference, is not it?

If you are going to take one of Oracle beta exams and you have time and ability to stay calm, you are not interested to economize some money I suggest waiting for a production one. Pluses: 1) You will probably get results two weeks earlier then beta-takers 2) More time, less questions 3) It’s not so  stressful 4) The probability to pass is much higher.

Do you agree? What is your experience in taking certification exams? :)