Oracle8i Certified Professional DBA Upgrade Exam Guide

( 1 )

Overview

Prepare to pass the OCP DBA Upgrade Exam. Officially authorized by Oracle Corporation,this book/CD-ROM package offers comprehensive coverage of all material on this exam. Chapter self-tests complete with in-depth explanations are included. The CD-ROM contains more than 250 practice questions that link further information on the subject in the electronic version of the book.

Get Certified with Official Exam Prep Material from Oracle Press The IT industry's top DBAs must be ready ...

See more details below
Available through our Marketplace sellers.
Other sellers (Hardcover)
  • All (7) from $1.99   
  • New (4) from $49.08   
  • Used (3) from $1.99   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$49.08
Seller since 2005

Feedback rating:

(1544)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
New

Ships from: Fort Worth, TX

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$125.00
Seller since 2013

Feedback rating:

(39)

Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
$125.00
Seller since 2013

Feedback rating:

(39)

Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
$930.80
Seller since 2008

Feedback rating:

(154)

Condition: New
0072192658 BRAND NEW NEVER USED IN STOCK 125,000+ HAPPY CUSTOMERS SHIP EVERY DAY WITH FREE TRACKING NUMBER

Ships from: fallbrook, CA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

Overview

Prepare to pass the OCP DBA Upgrade Exam. Officially authorized by Oracle Corporation,this book/CD-ROM package offers comprehensive coverage of all material on this exam. Chapter self-tests complete with in-depth explanations are included. The CD-ROM contains more than 250 practice questions that link further information on the subject in the electronic version of the book.

Get Certified with Official Exam Prep Material from Oracle Press The IT industry's top DBAs must be ready to deliver optimal performance in the face of extreme system demands. Upgrade your abilities and demonstrate your expertise by becoming Oracle8i certified. This exam guide contains 250 practice questions—fully supported with detailed answers—designed to upgrade the skills of Oracle7 and Oracle8 certification holders. Get full coverage of Oracle8i Database and object management,Java enhancements,and internals—plus a detailed review of all features and advanced functionality of Oracle8i including OLAP functionality,index enhancements and partitioning improvements,Oracle Universal Installer,and Database Resource Manager. Featuring a logical methodology designed to reinforce your learning experience,this guide offers the following study aids:

  • 100% complete coverage of all official exam objectives
  • Examples and exercises for every topic,designed to help you learn and retain key concepts
  • Two minute drills—end-of-chapter summaries perfect for last minute review of the material
  • Chapter self-tests—detailed question-and-answer sessions designed to help you retain information from each chapter
  • Extensive coverage of exam objectives,such asenhancements for archive duplexing and multiplexing,improved statistics gathering,top-N queries,LogMiner,and defining new constraint features.
  • Interactive exam on CD-ROM that lets you hyperlink directly to explanations in the electronic book

Fully endorsed by Oracle Corporation,this book and CD-ROM package is a powerful preparation tool for DBAs seeking to upgrade their certification. Absorb the material and prepare for the real thing with this study guide,officially endorsed by Oracle Corporation.

Read More Show Less

Product Details

  • ISBN-13: 9780072192650
  • Publisher: McGraw-Hill Companies, The
  • Publication date: 6/28/2001
  • Series: Oracle Press Series
  • Pages: 557
  • Product dimensions: 7.67 (w) x 9.43 (h) x 1.94 (d)

Meet the Author

Jason S. Couchman is a database consultant and the author of Oracle8i Certified Professional D8A Certification Exam Guide, also from Oracle Press. He is a regular presenter on Oracle and OCP at international Oracle user conferences and meetings. His work has been published by Oracle Magazine, Harvard Business School Publishing, and Gannett Newspapers, among others.
Read More Show Less

Read an Excerpt

Chapter 1: Performance and Java Enhancements

This chapter introduces you to several of the new features in Oracle8i related to performance and Java enhancements that are tested on the Oracle8i: New Features for Administrators Upgrade exam. The areas we will discuss are as follows:
  • Java in the database
  • Optimizer and query improvements
  • Summary management
Our coverage of Oracle8i in preparation for the New Features for Administrators OCP exam starts with the topics listed in this chapter. You will learn how Oracle incorporates Java into the database in several different areas. You will also cover the optimizer and query improvements available in the Oracle database, including improvements for statistics gathering, top-N queries, OLAP functionality, and other areas. After that, the text will guide you through a treatment on summary management, another aspect of OLAP processing built into the database.

Java in the Database

In this section, you will cover the following new features resulting from the incorporation of Java in the Oracle8i database:
  • Describing Oracle Java components
  • Describing )Server installation
  • Tuning )Server
Extensive use of Java in the database is perhaps the most exciting of the new features available in Oracle8i. This section will cover the new features for using Java in your Oracle8i applications to enhance usage of your Oracle databases by incorporating them with your corporate intranet or with the Internet. In this section you will cover the various methods for using Java in Oracle8i. You will learn how to install JServer, Oracle's name for the server-side components allowing use of Java in the database, as well as how to tune JServer.

Describing Oracle Java Components

You probably already know about the prevalence of Java for use in cross-platform development and on the Internet. Developed by Sun Microsystems, the Java programming language offers platform independence via virtual machine architecture, allowing developers a "write once, use everywhere" approach to code design essential in a Web-enabled marketplace. As a programming language, Java offers many automated storage management features (including garbage collection) that simplify the coding process as well.

If you've ever written C code, you'll find that Java code looks a bit familiar. Programmers proficient in the everpopular C programming language adapt to Java quickly because of its structural similarity to C. Although Java offers many differences from C, programmers often cite use of strongly typed variables in Java as the feature to pay the most attention to. Since many C programmers are used to weak typing, the use of strong typing in Java causes those programmers to pay particular attention to type definition along with regular variable declaration. For the record, PL/SQL also uses strongly typed variable declaration.

Java Features at a Glance
Here is a laundry list of features cited by Java developers as features of the programming language to know for the OCP exam:
  • Java is simple to use, once you master the concepts of OO programming.
  • The same compiled Java program can run on many different machines through the use of the Java virtual machine.
  • Automatic storage management relieves you from explicitly allocating and deallocating memory for variables in your program.
  • Java is a strongly typed programming language, so there's little chance of data conversion problems when passing data between Java programs and PL/SQL programs.
  • Java doesn't allow pointers. Objects are referenced by name, not by value, so no need to worry about data corruption or memory leaks.
  • Like PL/SQL, Java uses exception handling for error management, which greatly simplifies the resolution of errors in the Java program.
  • Java applications can be distributed across multiple systems because of its use of the class hierarchy. Names of objects are easily resolved using the flexible namespace feature in a way similar to the way Web site names are resolved on the Internet.
  • Security can be made tight both for data in a Java application through the restriction of visibility for attributes and for the program itself to ensure that the Java binary hasn't been altered.
  • Java supports multithreading in your application, which offers tremendous application scalability for vast user audiences.
  • Java can communicate with Oracle8i data in a standardized way using JDBC and SQLJ drivers.
A Primer on Java Programming
Chances are, as the DBA you won't necessarily get much opportunity to write Java code. But, you're probably interested in gaining at least a conceptual understanding of how to program in Java. Java is an object-oriented programming language (object-oriented is often abbreviated as OO), and as such, Java supports the notion of a class. Classes are to Java what tables and program units are to Oracle-but instead of existing separately, OO programming uses the class paradigm to marry data and process together.

Think of a conventional example-an employee application. If you're used to the RDBMS mentality, this application probably evokes images of tables called EMP and DEPT for storing employee and department data, respectively. The application probably also consists of some PL/SQL routines for manipulating the data. If you, say, want to manipulate data in the EMP table, you have to either issue some SQL using EMP or write a PL/SQL program that uses EMP. In either case, your code exists as something separate from the EMP table that you have to know about.

Thinking about the employee application from the OO perspective requires you to marry employee data and manipulation processes together into one logical unit called the employee class. This class defines the relevant fields of employee data to store, which we call attributes in OO parlance. Attributes are like columns in a table. The class identifies the name of the attribute as well as its datatype. However, the class also defines some rules of visibility for attributes in the class. Fields in Java can have static access, meaning that the field is globally available to every instance of that class. Alternately, fields in Java can be defined at the instance level using public, private, protected, or default access. With this emphasis on visibility at a low level, you can enforce better security in OO applications at the object level than you can in relational applications at the table level. To get the same kind of rowlevel security in relational database programming, you have to use fine-grained access control, which we'll discuss later in the book. The class also defines some processes for manipulating data-perhaps a routine for randomly generating a unique employee ID number, for example. These processes for manipulating the attributes are called methods by OO developers, and they are also stored in the class. Methods in a class often manipulate attributes of the class, and the rules of visibility can be controlled further by only showing data from the class via methods of that class to prevent misuse of the object....

Read More Show Less

Table of Contents

Oracle8i New Features Exam Guide.
Performance and Java Enhancements.
Partitioning and Object Management.
Database Administration in Oracle8i.
Manageability Enhancements.
Availability and Recoverability Enhancements.
Other Enhancements in Oracle8i.
Oracle8i Certified Professional New Features Practice Exams.
OCP Oracle8i Upgrade Exam: New Features for Administrators.
Appendixes.
Object Relational Database Features in Oracle8i.
Glossary of Common Oracle Terms.
Read More Show Less

Customer Reviews

Average Rating 4
( 1 )
Rating Distribution

5 Star

(0)

4 Star

(1)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing 1 Customer Review
  • Anonymous

    Posted May 20, 2002

    Fairly Decent Book to prepare for OCP upgrade exam

    It is definitely a good book to prepare for exam, not only it will help you in passing the exam, but will also improve your overall knowledge about Oracle8i database. The book does have some errata, but you should be able to pick those. I found this book, examcram book, and Oracle documentation more than enough to pass the exam.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Review

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)