Steve O'Hearn
Bowie, MD

Your Name :
Your Email :
Subject :
Message :



OCA Oracle Database SQL Certified Expert Exam Guide (Exam 1Z0-047)
Published on: 2009-12-02
Copyright: 2010
More Info

A Fully Integrated Study System for OCA Exam 1Z0-047 Prepare for the Oracle Certified Associate SQL Certified Expert exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, and a two-minute drill to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all objectives for exam 1Z0-047.

OCP Developer PL/SQL Program Units Exam Guide
Published on: 2002-04-23
Copyright: 2002
More Info

Prepare for the Oracle Certified Professional Developer PL/SQL Program Units exam using this Oracle Press study guide. Throughout each chapter, youll find in-depth details on all the material covered on this challenging exam, followed by practice questions and chapter summaries. The CD-ROM contains hundreds of practice exam questions in an adaptive format.


Apostolis Giannakidis, Apache Gora, and Oracle's NoSQL
Tue, 25 Jun 2013 10:00:00 +0000

I'm so impressed ...

Readers of this blog may remember the brilliant and gracious Apostolis Giannakidis, who I wrote about on August 21, 2012.  Apostolis tweeted some kind words about my book when he announced to the world that he nailed the Oracle SQL Expert exam with a 93 percent passing score - far in excess of what is required to establish certification!  I blogged about his tweet here, and he found my post and commented about it here.

So today I looked at his own blog, which is linked from his comment.  And WOW - Apostolis is joining the Google Summer of Code 2013 to help integrate Apache Gora with Oracle NoSQL.  This is huge stuff, folks, Apache is where all the cool cutting edge open source envelope-pushing is happening, and Gora is the project for big data persistence and in-memory data model support.  Gora is related to other cool Apache projects, like Cassandra.  Extremely cool work, and Apostolis is right in the middle of it all.

Congratulations Apostolis!


The 1981 Vision of the Internet and Newspapers
Mon, 24 Jun 2013 10:00:00 +0000

This is a great old 1981 news report from what appears to be a local San Francisco television station, talking about the then-futuristic Internet.  I love the opening line:

Imagine, if you will, sitting down to your morning coffee and turning on your home computer to read the day’s newspaper.  It’s not as far-fetched as it may seem …”

I received this video link from two friends at the National Press Club, Rick Dunham and Larry Lipman, both via Facebook.  Rick and Larry are former NPC presidents and this is making the rounds today among my friends in journalism.  Keep that in mind as you observe the focus in this news piece on the impact of the Internet on newspapers in particular.  Very interesting to see this with the hindsight of history.

Thanks to "bigdelboy" at Oracle Technology Forum
Thu, 16 May 2013 10:00:00 +0000

I just posted the following comment in a thread at the Oracle Technology Network forum, and I thought I'd repost it here, see below.

= = =

This is Steve O'Hearn, and thanks to bigdelboy for reposting the URL for the script download for my book, OCA Oracle Database SQL Expert Exam Guide: Exam 1ZO-047. I didn't realize my earlier posts providing the URL were flagged as spam. You're correct that I posted that URL in several forums at once. It's unfortunate that whoever or whatever may have deleted my entries would've done so on behavior alone without regard for the content of the message.

Anyone can visit my blog at and look for the "1ZO-047 SQL SCRIPTS" link and follow the instructions. And yes, the script download is limited to owners of the book itself. The script is worthless to anyone else anyway.

For anyone wondering about preparation for the exam, please note that my book includes 728 pages in 18 chapters, including one for each of the exam objectives, and each of those chapters includes the following:

- Text to address the exam objectives in detail
- A detailed chapter summary ("certification summary")
- A through "two minute drill" reviewing the concepts of the chapter
- A "self-test" on the chapter, including 15 questions each, and each question is designed to match the pattern of the actual certification exam. This means that many questions are based on code samples, and all offer multiple choice answers.
- Detailed explanations for each "self-test" question and each and every answer - including an explanation as to why each answer is either right or wrong

In addition to all of this, the book also includes a complete 70-question practice exam at the end of the printed book.

And in addition to that, there's another complete 70-question practice exam available online to owners of the book.

These exams are not included in the 728 pages of text. Altogether you're getting over 1,000 pages of material with which to prepare for the exam.

The book really is a complete package for exam preparation. And judging by the volume of email I get from happy readers who are now certified, I dare say its very effective.

Good luck to you if you are studying for the exam! And please feel free to contact me with any comments or questions you may have. I've read that I'm apparently not allowed to post my email address here, but my blog website is listed above, and you can contact me via the blog.

- Steve


The state of spy drone imagery: Argus
Thu, 16 May 2013 10:00:00 +0000

"This is the next generation of surveillance ... it is important for the public to know that some of these capabilites exist."

These are the words of Yiannis Antoniades, designer of Argus, the world's highest resolution camera with 1.8 billion pixels.  Antoniades is an engineer with BAE Systems and developed the camera under contract to DARPA.  The camera uses Wide Area Persistent Stare and shows an example of a 15-square-mile area video image that offers multiple drill-down capabilities.  Colored boxes highlight moving objects, including cars and people and even birds.  You can see a man waving his arms; the camera can see objects as small as six inches on the ground.

But is it being used now?  The answer to that question is "classified", says the video.

Really?  THAT is classified? So why does that remind me of this clip from the 1980 film Airplane!:

For the record, the Argus video does state that it has, "for the first time ... permission from the government to show some of these capabilities."  So unless that claim is a lie, I don't think it's some rogue video.

It's just an amazing advance in technology.

Another Great Book Review
Tue, 23 Apr 2013 10:00:00 +0000

Here's another great review of my book OCA Oracle Database SQL Expert Exam Guide, this from R.C. Roper of Topanga Canyon, California, who says:

This is a great book, covering all of the relevant topics in detail. The chapters and sections are in the order the certification objectives appear on Oracle's 'Exam Topics' page for this test, so it's easy to navigate and find your trouble spots. There are over 200 end-of-chapter questions in the book, and that's all I used to study for this exam. After only a week of study, I passed the exam with no other preparation except for the experience I've gained over the short time I've held my job. I can only imagine how well I would have done if I registered later for the test and gave myself more time.

Thanks, R.C.! The outline and overall structure was a major topic of discussion and debate in the original formation of the book, and frankly it made the job a bit challenging. It's one thing to write a book that mirrors the exam objectives outline, and it's another to create a book that conveys the information sequentially from start to finish in a way that initially made the most sense to me. Creating a single volume that does both simultaneously was tricky - but I think we did it, and did a great job. By "we", I'm including the excellent team at McGraw-Hill, including Tim Green, Meghan Manfre (formerly Meghan Riley), and Molly Sharp, as well as the outstanding and brilliant technical editor Alistair Grieve who was tremendous and really went above and beyond with this effort.  And even the legendary Kevin Loney provided some key input.  So it was quite the team effort.  (Click here for the complete Acknowledgements section from the book!)


Java: Critical Update Issued by Oracle Corporation
Wed, 17 Apr 2013 06:40:00 +0000

Oracle issued critical updates to Java on Tuesday, Reuters reports:

The patch fixes 42 vulnerabilities within Java, including "the vast majority" of those that have been rated as the most critical, said Oracle Executive Vice President Hasan Rizvi.

For more:


Author Profile
Name: Steve O'Hearn
Location: Bowie, MD

Twitter Account

Website: My Blog

Copyright © 2013 McGraw-Hill Global Education Holdings, LLC Any use is subject to the Terms of Use and Privacy Notice