Oracle8i Certified Professional Dbo Certification Exam Guide (Book/CD-ROM Package)

Overview

Featuring a logical methodology designed to reinforce your learning experience,this guide offers study aids to help you earn your OCP DBO credential.

Get certified with official exam prep material from Oracle Press.

The new Oracle Certified Professional (OCP) Database Operator (DOB) designation is proof of your ability to successfully perform operational and administrative tasks on an Oracle database. Oracle ...

See more details below
Available through our Marketplace sellers.
Other sellers (Hardcover)
  • All (11) from $1.99   
  • New (4) from $5.49   
  • Used (7) 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
$5.49
Seller since 2006

Feedback rating:

(347)

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
2000 Hard cover Illustrated. New. No dust jacket as issued. Oracle Certified Professional (Osborne). Audience: General/trade.

Ships from: Northbrook, IL

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$36.73
Seller since 2015

Feedback rating:

(366)

Condition: New
Brand New Item.

Ships from: Chatham, NJ

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$45.00
Seller since 2015

Feedback rating:

(241)

Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
$58.89
Seller since 2008

Feedback rating:

(215)

Condition: New

Ships from: Chicago, IL

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

Featuring a logical methodology designed to reinforce your learning experience,this guide offers study aids to help you earn your OCP DBO credential.

Get certified with official exam prep material from Oracle Press.

The new Oracle Certified Professional (OCP) Database Operator (DOB) designation is proof of your ability to successfully perform operational and administrative tasks on an Oracle database. Oracle DBOs provide valuable support to Database Administrators (DBAs) in the everyday management of the database.

Certify your skills and demonstrate your expertise by earning your OCP DBO credential—with help from this Oracle-authorized exam guide. The book provides full coverage of the Oracle DBO certification exams,including complete details on Oracle8i.

Featuring a logical methodology designed to reinforce your learning experience,this guide offers the following study aids:

  • Tips,examples,and exercises to help you remember key concepts

  • Two-minute drills—quick and concise checklists that summarize a chapter's main points

  • Perfect for last-minute review

  • Chapter self-tests—chapter specific questions similar to those found on the exam with detailed answers to each question

  • Comprehensive coverage of Oracle-designated exam objectives,including Oracle database configuration,database software installation,data loading,SQL and DDL,backups,Oracle8i,and much more

  • Interactive exam on CD that enables you to hotlink directly to the relevant part of the electronic book

Make a smart career move and begin enjoying all the rewards of OCP DBO certification. This officially endorsed study guide offers acomplete preparation system geared to help you pass your exams with flying colors!

Read More Show Less

Product Details

  • ISBN-13: 9780072123616
  • Publisher: McGraw-Hill Professional
  • Publication date: 2/1/2000
  • Series: Oracle Press Series
  • Edition description: BK&CD ROM
  • Pages: 543
  • Product dimensions: 7.63 (w) x 9.44 (h) x 1.85 (d)

Read an Excerpt

Chapter 3: Networking and Database Availability

In this chapter, you will cover the following topics related to Oracle networking and database availability:
  • Oracle networking and OEM configuration
  • Startup and shutdown of Oracle databases
Oracle databases are meant to be used. In most organizations, this fact means that the Oracle database must be available to many users across a local area network. It also means that the database must be created, the instance must be running, and that users can connect to it. This chapter will teach you how to accomplish all three with Oracle running on Windows environments. By the end of it, you will be able to identify the purpose of and configure various Oracle networking files. You will also be able to use Enterprise Manager to open and close your Oracle database, and store your initialization parameters normally found in the initsid. ora file in Instance Manager instead.

Oracle Networking and OEM Configuration

This section covers the following topics on Oracle networking and OEM configuration:

  • Purpose and structure of Net8
  • Net8 files for configuration
  • Generating Net8 files with Net8 Assistant
  • Creating the OEM repository
  • Using OEM console navigator
The discussions in this section will explain the purpose and structure of Net8. You will learn the basics of how Oracle connects clients to the database server using Net8. You will also learn how to configure it using key configuration files on both client and server. The special purpose of Net8 Assistant for automatic generation of these files will also be explained. Recall in Chapter 2 that you learned how to install OracleEnterprise Manager. Well, in reality, you were only shown half the installation. The other half is learning how to create the repository of tables in Oracle that OEM uses to operate normally. This section will explain how to create that OEM repository. Finally, you will learn more about the OEM console navigator, and what it allows you to do. The purpose of a special piece of software called the Intelligent Agent, which resides on the server side to assist in OEM console tasks, will be covered as well.

Purpose and Structure of Net8

Whatever your network, Net8 can help you connect your users to the Oracle database. There are versions of Net8 that run on TCP/IP, DECnet, IPX, and many other LAN or WAN products. Moreover, it is possible for Net8 to handle users on multiple networks attempting to connect to the same Oracle database. Networked computing has seen three distinct trends in the last 40 years of organizational use of computers:

  • Mainframe computing Paradigm that uses mainframe computers to solve business problems. Mainframes feature powerful processing capacity at high speeds but have the drawbacks of unwieldy interfaces, complex programming, and inflexibility for changing business requirements.
  • Client/server computing Paradigm that uses personal computers and servers, each running their own software, to solve business problems. Advantages include great looking user interfaces and flexibility for changing business needs, but has the drawback of slow operation and distributed data storage that require synchronization activity to guarantee data reliability.
  • Internet computing Paradigm that uses servers and personal computers, each running their own software, to solve business problems. The differentiating characteristic of PC software in this case is the use of Web browser technology as a universal client. Advantages include centralized storage of data, fast user processing times, great looking user interfaces, and simplified choice process for client software. Disadvantages include security (perceived or real) and dependence on network availabi I ity for operation.
Benefits of Net8 for Client/Server and Internet Computing

Net8 is Oracle's networking software that allows both Internet computing and client/server architecture to be used in your database applications. The key component of Net8 includes database name and location resolution, locally or with an Oracle Names server. Net8 does not, however, do any hostname resolution. The resolution of a name you have given to a server to its network IP address; Net8 counts on the underlying network to handle that. Thus, Net8's basic purpose includes communication of user requests from client to server. Note the use of communication-not transport—in that description. Net8 is not a stand-alone networking protocol. In other words, if you aren't using TCP/IP, DECnet, IPX, or some other networking protocol already, Net8 alone won't make all your computers magically start talking to one another. Net8 simply runs over the top of an existing network to make all the Oracle-related components talk to each other, using something called the Transparent Network Substrate, or TNS, to form ,,connections between clients and servers. TNS allows Net8 to communicate with...

Read More Show Less

Table of Contents

Chapter 1: A DBO's Introduction to Oracle Software.
Chapter 2: Oracle Installation and Configuration.
Chapter 3: Networking and Database Availability.
Chapter 4: Database Structure and Object Creation.
Chapter 5: Oracle Usage and Database Security.
Chapter 6: Backup, Recovery, and Data Loads.
Chapter 7: Database Tuning and Troubleshooting.
Chapter 8: SQL Queries in SQL*Plus.
Chapter 9: SQL DML and DDL in SQL*Plus.
Chapter 10: Tips for Special Question Formats on the DBO Exam.
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

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

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