My Oracle 1Z0-007 Result

August 26, 2007




Oracle 1Z0-007 Result

Originally uploaded by markmarucot

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

August 19, 2007

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:

    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

    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
    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

    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:

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

    with

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

VBulletin SEO URL Rewriting

August 19, 2007

  1. Place the code below in the .htaccess.
    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:
    CODE:
    1. $forum['statusicon'] = fetch_forum_lightbulb($forumid, $lastpostinfo, $forum);

    and below that add

    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:
    CODE:
    1. $thread = process_thread_array($thread, $lastread, $foruminfo['allowicons']);

    and below that add

    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:
    CODE:
    1. <a href="showthread.php?$session[sessionurl]t=$thread[threadid]$thread[highlight]">

    and below that add

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

  5. Change the following template:
    Search the following:

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

    Replace with:

    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

August 18, 2007

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

Link

NoSpam! - an alternative to CAPTCHA images

August 18, 2007

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

August 18, 2007

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

August 14, 2007

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

August 14, 2007

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

August 11, 2007

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

Link

Oracle 11g Documentation

August 11, 2007

. 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 »