My Oracle 1Z0-007 Result

I took the exam for 1Z0-007 Introduction to SQL yesterday (August 27). The some questions are very easy to answer as long as you know to concepts of Oracle SQL 9i. Some questions are tricky so I need to mark the questions to revisit after I completed answer all of the questions. All in all, I marked 17 questions out of 52 for review. To think the passing percentage is 71%, that means I need to have at least 37 correct answers. With 17 questions mark for review that means I only answered 35 questions correctly so I need to review the 17 marked questions so that at least I answered 2 questions correctly to passed.

In the end, after revisiting the 17 questions, I passed the exam with 47 correct answers out of 52 questions. That means I got 5 incorrect answers. My percentage is 90.4% for 1Z0-007. Now, my next step is preparation is for 1Z0-147 PL/SQL to achieve the Oracle Certified Associate.

SEO URL Rewriting for GARS

I discussed the steps to setup the URL rewriting for VBulletin. For those forums using GARS, here are the steps.

1. Edit geek/gars/mods/display/top.php
   
   Search:
   PLAIN TEXT
   CODE:

   1. $bits .= "<tr><td align=\"$stylevar[left]\"><span class=\"smallfont\"><a href=\"showthread.php?t=$value[threadid]\" title=\"$value[title]\">$value[title]</a></span></td></tr>";

   Replaced with

   PLAIN TEXT
   CODE:

   1. $thread['url'] = strtolower(str_replace(" ", "-", $value[title]));
   2. $thread['url'] = strtolower(str_replace("'", "", $value[title]));
   3. $thread['url'] = ereg_replace("[/?!.$%£()~*@#]+", "", $thread['url']);
   4. $bits .= "<tr><td align=\"$stylevar[left]\"><span class=\"smallfont\"><a href=\"t$value[threadid]-" .  $thread['url']  . ".html\" title=\"$value[title]\">$value[title]</a></span></td></tr>";

2. Edit geek/gars/mods/display/toc.php
   
   PLAIN TEXT
   CODE:

   1. $bits.="<li><div class=\"smallfont\"><a href=\"showthread.php?t=$threadinfo[threadid]&amp;garpg=" . ($toc_x + 1). "#content_start\">";
   2. $bits.=$this->navigation['pages'][$toc_x]['text'] ? $this->navigation['pages'][$toc_x]['text'] : construct_phrase($vbphrase['GARS_pagex'],($toc_x + 1));
   3. $bits.="</a></div></li>";

   Replaced with

   PLAIN TEXT
   CODE:

   1. $thread['url'] = strtolower(str_replace(" ", "-", $this->navigation['pages'][$toc_x]['text'] ? $this->navigation['pages'][$toc_x]['text'] : construct_phrase($vbphrase['GARS_pagex'],($toc_x + 1))));
   2. $thread['url'] = ereg_replace("[/?!.$%£()~*@#]+", "", $thread['url']);
   3. $bits.="<li><div class=\"smallfont\"><a href=\"a$threadinfo[threadid]-" . ($toc_x + 1). "-$thread[url].html\">";

3. Edit the following templates
   
   GARS_forumbit_level1_nopost
   GARS_forumbit_level1_post
   GARS_forumdisplay
   GARS_simple_threadbit
   GARS_subforumbit_nopost
   GARS_subforumbit_post
   GARS_threadbit

   Replace:

   PLAIN TEXT
   CODE:

   1. showthread.php?$session[sessionurl]t=$thread[threadid]

   with

   PLAIN TEXT
   CODE:

   1. t$thread[threadid]-$thread[url].html

VBulletin SEO URL Rewriting

1. Place the code below in the .htaccess.
   PLAIN TEXT
   CODE:

   1. RewriteRule ^t([0-9]+)-(.*).html$ showthread.php?t=$1 [L]
   2. RewriteRule ^lastpostinthread([0-9]+).html$ showthread.php?goto=lastpost&amp;t=$1 [L]
   3. RewriteRule ^newpostinthread([0-9]+).html$ showthread.php?goto=newpost&amp;t=$1 [L]
   4. RewriteRule ^f([0-9]+)-(.*).html$ forumdisplay.php?forumid=$1 [L]

2. Edit the functions_forumlist.phpSearch for:
   PLAIN TEXT
   CODE:

   1. $forum['statusicon'] = fetch_forum_lightbulb($forumid, $lastpostinfo, $forum);

   and below that add

   PLAIN TEXT
   CODE:

   1. $forum['url'] = strtolower(str_replace(" ", "-",str_replace("/", "-", $forum['title'])));
   2. $forum['url'] = strtolower(str_replace("'", "",str_replace("/", "-", $forum['title'])));

3. Edit the forumdisplay.php.Search for:
   PLAIN TEXT
   CODE:

   1. $thread = process_thread_array($thread, $lastread, $foruminfo['allowicons']);

   and below that add

   PLAIN TEXT
   CODE:

   1. $thread['url'] = strtolower(str_replace(" ", "-", $thread['threadtitle']));
   2. $thread['url'] = strtolower(str_replace("'", "", $thread['threadtitle']));
   3. $thread['url'] = ereg_replace("[/?!.$%£()~*@]+", "", $thread['url']);

4. Edit the threadbit template.Search for:
   PLAIN TEXT
   CODE:

   1. <a href="showthread.php?$session[sessionurl]t=$thread[threadid]$thread[highlight]">

   and below that add

   PLAIN TEXT
   CODE:

   1. </a><a href="t$thread[threadid]-$thread[url].html">

5. Change the following template:
   Search the following:
   PLAIN TEXT
   CODE:

   1. </a><a href="forumdisplay.php?$session[sessionurl]f=$forum[forumid]">

   Replace with:

   PLAIN TEXT
   CODE:

   1. </a><a href="$forum[url].html">

   forumhome_forumbit_level1_nopost
   forumhome_forumbit_level1_post
   forumhome_forumbit_level2_nopost
   forumhome_forumbit_level2_post
   forumhome_lastpostby

VBulletin URL Rewriting

This discussed how to make the VBulletin URL to a human readable format.

Link

NoSpam! - an alternative to CAPTCHA images

This simple hack is meant as a replacement for the default CAPTCHA system in vBulletin. There are two main reasons one might want to do this: firstly, new technology is constantly being developed to crack CAPTCHA images and make spam accounts anyway, and secondly, the more secure the CAPTCHA, the more difficult it is for genuine users to tell what the numbers in the image are. There is also the issue of visually impaired users, and the fact that not all servers are capable of generating CAPTCHA images.

Link

VBulletin Specific Category Icon

Find "forumhome_forumbit_level1_nopost" template:

Code:

<td class="tcat"><img src="/path/to/your/image_$forum[forumid].gif" /></td>

Then, when you're naming the images you'd like to display, add a suffix to each one with the Forum ID that you'd like it displayed for.

Ex: image.gif for Forum ID 2 becomes - image_2.gif

Edit: If you don't want to display an image for all your forums, you can wrap the above code with the following, which will only display it for specific forums:

Code:

<if condition="in_array($forum[forumid], array(X,Y,Z))">
Code Supplied Above
</if>

Replace X,Y,Z with the Forum IDs of the forums you're displaying images next to.

Restrict User From Entering More Than 100 Records

You can write following code at WHEN-CREATE-RECORD trigger of that block to restrict user entering upto 100 records.

IF to_number(:system.cursor_record) > 99 THEN
raise form_trigger_failure;
END IF;

Generating Spool File Layout

Use this simple SQL script--lay.sql--to generate the layout for the spooled file. Run the script before spooling the table to get the layout

Link

Things to do if your query is slow

This explains on what to do to investigate why your query is slow.

Link

Oracle 11g Documentation

. Download Oracle Database 11g Release 1 (11.1.0.6.0)
Standard Edition, Standard Edition One, and Enterprise Edition - Linux x86 (1.7 GB)2. Oracle Database 11g Release 1 Documentation Library
Oracle® Database Concepts 11g Release 1 (11.1)
Oracle® Database Upgrade Guide 11g Release 1 (11.1)
Oracle® Database New Features Guide 11g Release 1 (11.1)
“What’s New in 11g” search on documentation

3. Oracle Database 11g: The Top New Features for DBAs and Developers by Arup Nanda
Database Replay
Partitioning to Perfection
Schema Management

4. Installing 11g Release 1 on Xubuntu 7.04 by Howard Rogers

Next Page »