Oracle Certification : Oracle8i SQL and PL/SQL : OCP : OCA
MCSE, CISSP, Security+, Network+, A+ Certification Practice Exams, Study Guides and Vouchers Sign Up | Login   
MCSE, CCNA, CCNP, Security+, Network+, A+ Certification
Practice Exams Exam Vouchers Video Training Free WinITPro Mag
MCSE, CCNA, CCNP, Security+, Network+, A+ Certification
MCSE, CCNA, CCNP, Security+, Network+, A+ Certification
MCSE CCNA  A+ CERTIFICATION NETWORK+ ETHICAL HACKER SECURITY+   CISSP   CCNP MORE...
MCSE, CCNA, CCNP, Security+, Network+, A+ Certification
MCSE, CCNA, CCNP, Security+, Network+, A+ Certification
Email this PageEmail this Page
SQL and PL/SQL
Exam 1Z0-001: Oracle8i Introduction to Oracle SQL and PL/SQL

Free Study Guide

E X A M   D I F F I C U L T Y
SQL and PL/SQL Exam Difficulty RatingSQL and PL/SQL Exam Difficulty RatingSQL and PL/SQL Exam Difficulty RatingSQL and PL/SQL Exam Difficulty Rating
SQL and PL/SQL Exam Difficulty Rating

• What to Know
• Oracle8i DBA OCP Articles
• Oracle9i DBA OCA Articles
• Discussion Board

  
SYNOPSIS • Oracle8i DBA OCP vs • Oracle9i DBA OCA vs

Oracle’s Oracle 8i exam 1Z0-001, “Introduction to Oracle: SQL and PL/SQL” is a core requirement for the Oracle 8i OCP (Oracle Certified Professional) certification. It is designed for all database personnel seeking Oracle certification. There is no specific prerequisite for this exam.

This exam is moderately difficult and costs $125 USD. It may be taken from Thomson Prometric.

The pass score for this form-based multiple choice exam is 68%. There are 57 scored questions (“your exam may contain unscored questions in addition to the scored questions”) and the exam lasts 2 hours.

The topics covered by this exam include:

  • Overview of Relational Databases, SQL and PL/SQL
  • Writing Basic SQL Statements
  • Restricting and Sorting Data
  • Single Row Functions
  • Displaying Data from Multiple Tables
  • Aggregating Data Using Group Functions
  • Subqueries
  • Multiple-Column Subqueries
  • Producing Readable Output with SQL*Plus
  • Manipulating Data
  • Creating and Managing Tables
  • Including Constraints
  • Create and Maintain Constraints
  • Oracle Data Dictionary
  • Other Database Objects
  • Controlling User Access
  • Declaring Variables
  • Writing Executable Statements
  • Interacting with the Oracle Server
  • Writing Control Structures
  • Working with Composite Datatypes
  • Writing Explicit Cursors
  • Advanced Explicit Cursor Concepts
  • Handing Exceptions
For more information:
http://www.oracle.com/education/certification/objectives/index.html?1.html

Helpful: Compare this exam with others.
 Subscribe to our Free Must Know News Newsletter
 Name:     Email:  

User Reviews     10 Total Comments: 10 | 25 | 50

SQL and PL/SQL Exam Difficulty RatingSQL and PL/SQLExam Difficulty RatingSQL and PL/SQL Exam Difficulty RatingSQL and PL/SQL Exam Difficulty Rating  1 down, 4 more to goalanwill81 on Saturday, January 03, 2004
1Z0-001 took 2 weeks of intense studying for me. I passed to exam after the first try however, I still can't believe I passed. For some reason it seemed pretty difficult. Nevertheless, I passed (47-57) and I'm happy. I used and would suggest Sybex Oracle8i Certification Kit and Exam Cram for 1Z0-001.
MCSE, CCNA, CCNP, Security+, Network+, A+ Certification

KEYWORD
 
What is this?
Microsoft, CompTIA, Cisco Realistic Practice Exams
Microsoft, CompTIA, Cisco Realistic Practice Exams
Microsoft, CompTIA, Cisco Realistic Practice Exams
FREE STUDY GUIDES
CISCO CCNA LAB KITS
FREE QUESTIONS >>
HOME
CERTIFICATIONS
VIDEO TRAINING
PRACTICE EXAMS
AUDIO TRAINING
EXAM VOUCHERS
FREE IT MAGAZINES
CERT COMPARISON
EXAM COMPARISON
SALARY SURVEY
CAREER TRACKS
ARTICLE DIRECTORY
WHITE PAPERS
QUESTION OF THE DAY
NEWSLETTER
ADVERTISE
Industry Updates &
Special Offers
Certification
MCSE, CCNA, CCNP, Security+, Network+, A+ Certification
MCSE, CCNA, CCNP, Security+, Network+, A+ Certification
Picks for July
Untitled Document > Persistent Group Chat: An Approach for More Profitable Team Communications : Unlike email, instant messages (IMs) do not allow group communication; nor do they persist -- you can't hold on to them for as long as you wish. Persistent group chat, however, allows businesses to organize persistent dialogue around business-critical topics, and keep them for easy retrieval later.

> Recent White Papers
> Free eLearning!

> Online Degrees for IT Professionals. Get your degree and certifications

> NetworkWorld - FREE Subscription Center

> Never Open a Book Again! LearnSmart Video Training for A+, CCNA, Network+ and more.

> Pass Guaranteed: Hundreds of practice exam questions and the most authentic exam simulation.

> Lecture Series audio: Learn at home, on your iPod or while driving to work.

> PMP: Learn everything for the Project Management Professional (PMP) certification

> Quiz Me Series Audio: Rapid-fire question and answer session training

> Opinions Needed! Click here to join the MyView Survey Panelg

> CramSession Memeber Benefit: Subscribe to Windows IT Pro for FREE!

> Suggestions on how to build a Cisco CCNA Certifcation Lab

> FREE subscription to WindowsITPro Magazine - a must for Microsoft enthusiasts



Marketplace

CramSession Memeber Benefit: Subscribe to Windows IT Pro for FREE!
Windows IT Pro is the only independent resource for managing, securing, and troubleshooting the Windows enterprise. Included in your subscription is: The inside scoop on Microsoft won't tell you about Windows Server; Access to veteran experts like Mike Otey, Mark Minasi, and Paul Thurrott; Thousands of tips and solutions to help you get more done in less time; Tips from the trenches and other nuggets of wisdom from readers like you; Comprehensive coverage of Active Directory, security, virtualization and disaster recovery, and more; Comparative, thorough, and impartial product reviews; Admission into the single largest IT community in the world!

IT Certifications may waive some degree requirements for an online degree. Free catalog!
For several of the IT degrees at WGU, if you hold a relevant IT certification (such as MCSE), you automatically clear a significant portion of the degree requirements. Don't hold an IT certification yet? Don't worry. Not every WGU degree program requires an IT certification in advance. You can earn both at the same time. Lower tuition too!

FREE subscription to Network World.
Your complimentary subscription will include 50 weekly issues jam packed with news analysis, expert industry opinion and management/career advice, all of which is packaged with your business needs in mind. We want to help you connect the technology dots and help you advance your company's business goals.

CCNA & CCNP Lab Suggestions
Many people ask me what would make a good CCNA lab? Well, that can be a tricky question based upon your budget and future Cisco aspirations. So let’s start off with a few basic concepts I hope we can all agree on. Real Routers. Read more…

Share your opinions! Speak your mind! Earn great rewards!
Join the MyView Research Community. Members will receive opportunities to take part in surveys from today's leading businesses.




Sponsored Link

MCSE, CCNA, CCNP, Security+, Network+, A+ Certification
Free Certification Training Free Certification Training Free Study Guides
   © 1999 - 2009 CramSession. All Rights Reserved. Home   Advertise   Corporate Info   Opportunities   Help