Oracle Certified Professional Application Developer Exam Guide

ISBN-10: 0072119756

ISBN-13: 9780072119756

Edition: 1999

List price: $99.99
30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy

Description: This text and CD-ROM package contains questions on product upgrades since the Oracle certified application developer release 1 examination. The CD-ROM with interactive exams holds over 300 questions, hyperlinked to the text in the main book.

what's this?
Rush Rewards U
Members Receive:
coins
coins
You have reached 400 XP and carrot coins. That is the daily max!

Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Add to cart
Study Briefs
SQL Online content $4.95 $1.99
Add to cart
Study Briefs
MS Excel® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS Word® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS PowerPoint® 2010 Online content $4.95 $1.99

Customers also bought

Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

Book details

List price: $99.99
Copyright year: 1999
Publisher: McGraw-Hill Osborne
Binding: Hardcover
Pages: 1351
Size: 7.50" wide x 9.50" long x 3.00" tall
Weight: 5.434
Language: English

Christopher Allen is one of the leaders of the iPhone Web Developer community.He is the host of iphonewebdev.com, which is the largest community of iPhonebasedweb developers anywhere, and manages its mailing list. He also helped toorganize iPhoneDevCamp and oversaw its Hack-a-thon. Christopher is a longtimetechnologist, and is also a leader in social software and was one of the authors ofTLS, the next-generation SSL protocol.

Preface
Acknowledgments
Introduction
Preparing for OCP DBA Exam 1: SQL and PL/SQL
Selecting Data from Oracle
Selecting Rows
Writing SELECT Statements
Performing Arithmetic Equations
Handling NULL Values
Changing Column Headings with Column Aliases
Putting Columns Together with Concatenation
Editing SQL Queries Within SQL*Plus
Limiting and Refining Selected Output
The ORDER BY Clause
The WHERE Clause
Using Single-Row Functions
Various Single-Row Functions Explained
Using Functions in SELECT Statements
Date Functions
Conversion Functions
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
Advanced Data Selection in Oracle
Displaying Data from Multiple Tables
Select Statements That Join Data from More than One Table
Creating Outer Joins
Joining a Table to Itself
Group Functions and Their Uses
Identifying Available Group Functions
Using Group Functions
Using the GROUP BY Clause
Excluding GROUP Data with HAVING
Using Subqueries
Nested Subqueries
Subqueries in Other Situations
Putting Data in Order with Subqueries
Using Runtime Variables
Entering Variables at Run Time
Automatic Definition of Runtime Variables
ACCEPT: Another Way to Define Variables
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
Creating the Oracle Database
Overview of Data Modeling and Database Design
Stages of System Development
Basic Types of Data Relationships
Relational Database Components
Reading an Entity-Relationship Diagram
Creating the Tables of an Oracle Database
Creating a Table with Integrity Constraints
Using Table Naming Conventions
Datatypes and Column Definitions
Indexes Created by Constraints
Creating One Table with Data from Another
The Oracle Data Dictionary
Available Dictionary Views
Querying the Data Dictionary
Manipulating Oracle Data
Inserting New Rows into a Table
Making Changes to Existing Row Data
Deleting Data from the Oracle Database
The Importance of Transaction Control
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
Creating Other Database Objects in Oracle
Table and Constraint Modifications
Adding and Modifying Columns
Modifying Integrity Constraints
Enabling or Disabling Constraints
Dropping Tables
Truncating Tables
Changing Names of Objects
Viewing Dictionary Comments on Objects
Sequences
Role of Sequences
Creating Sequences
Using Sequences
Modifying a Sequence Definition
Removing Sequences
Views
Data Dictionary Views
Creating Simple and Complex Views
Creating Views that Enforce Constraints
Modifying Views
Removing Views
Indexes
Manual and Automatic Indexes
Uses for Indexes
Index Structure and Operation
Creating Indexes
Removing Indexes
Guidelines for Creating Indexes
User Access Control
Oracle Database Security Model
Granting System Privileges
Using Roles to Manage Database Access
Granting Object Privileges
Changing Passwords
Granting and Revoking Object Privileges
Using Synonyms for Database Transparency
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
Introducing PL/SQL
Overview of PL/SQL
Using PL/SQL to Access Oracle
PL/SQL Program Constructs
Developing a PL/SQL Block
Declaring and Using Variables
Variable Value Assignment
Interacting with the Oracle Database
Using SQL Statements in PL/SQL
Using Implicit Cursor Attributes
Transaction Processing in PL/SQL
Controlling PL/SQL Process Flow
Conditional Statements and Process Flow
Using Loops
Explicit Cursor Handling
Implicit vs. Explicit Cursors
Declaring and Using Explicit Cursors
Parameters and Explicit Cursors
Writing CURSOR FOR Loops
Error Handling
Three Basic Types of Exceptions
Identifying Common Exceptions
Coding the Exception Handler
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
Preparing for OCP Exam 2: Developing PL/SQL Program Units
Procedures and Functions in PL/SQL Development
Developing Stored Procedures and Functions
Permissions and PL/SQL Programs
Creating PL/SQL Procedures
Parameter Passing
Creating PL/SQL Functions
Using SQL*Plus to Create Procedures and Functions
Entering PL/SQL Code in SQL*Plus
Invoking Procedures and Functions in SQL*Plus
Code Compilation in Oracle Using SQL*Plus
Creating Procedures and Functions with Procedure Builder
Using Procedure Builder Command Line to Develop PL/SQL
Parts of the Procedure Builder GUI
Using Procedure Builder GUI to Develop Client-Side PL/SQL
Using Procedure Builder GUI to Develop Server-Side PL/SQL
Running Pl/SQL Programs in Procedure Builder
Handling Exceptions in PL/SQL
Handling Oracle-Defined Exceptions
Handling User-Defined Exceptions
Using RAISE_APPLICATION_ERROR()
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
Debugging PL/SQL Procedures and Functions
Methods of Debugging Server-Side PL/SQL
Introducing the DBMS_OUTPUT Package
A Tour of the DBMS_OUTPUT Package
DBMS_OUTPUT Procedures in Action
Debugging PL/SQL with Procedure Builder
Finding Errors in Code Compilation
Using Breakpoints to Debug Errors in Code Execution
Using Debug Triggers for Debugging Code Execution
Using Oracle-Supplied Packages for Debugging
Overview of Oracle-Supplied Packages in Procedure Builder
Packages for Application Component Communication
Packages for Tuning, Portability, and Compatibility
Packages for Debugging PL/SQL
Case Study of Debugging with Oracle-Supplied Packages
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
Managing Procedures, Functions, and Procedural Dependency
Managing Procedures and Functions
Dictionary Views on Stored Procedures
Security for Owner and User on Stored PL/SQL
Managing Procedure Dependencies
Tracking Procedural Dependencies
Database Object Changes and Stored Procedures
Managing Procedural Dependencies in One Database
Managing Procedural Dependencies in Distributed Databases
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
Developing and Using Packages
Developing PL/SQL Packages
Overview of Using PL/SQL Packages
Creating Packages to Bundle PL/SQL Constructs
Public and Private Objects in Packages
Compiling and Running Packages
Managing PL/SQL Packages on the Database
Managing Package Specification Dependency
Managing Compilation Dependency and Packages
Managing Procedure Dependency in Packages
Using Pragma RESTRICT_REFERENCES
Managing Packages and Security
Using Oracle Server-Supplied Packages
Overview of Oracle Server-Supplied Packages
Server Packages for Transaction Processing
Server Packages for Advanced Application Development
Server Packages for DBAs and Application Administration
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
Developing and Using Database Triggers
Developing Database Triggers
Identifying Different Trigger Types
Creating Statement Triggers
Creating Row Triggers
Dictionary Information about Triggers
Managing Triggers
Managing Trigger Development
Required Security and Trigger Availability
Understanding Trigger Firing Mechanisms
Creating Triggers that Complement the Oracle Database
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
Preparing for OCP Exam 3: Building Forms I
Introduction to Oracle Developer/2000
Overview of the Developer/2000 Package
Features and Benefits of Using Developer/2000
Component Groups in Developer/2000
Introduction to Developer/2000 Builder Tools
Builder Tools for Project Management
Builder Tools for Front-End Development
Builder Tools for Back-End Development
Customizing Your Developer/2000 Session
Navigating the Developer/2000 Interface
Customizing Project Builder
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
Form Builder
Working in the Form Builder Environment
Identifying the Main Form Builder Executables
Identifying the Main Components of Form Builder
Identifying the Main Objects in a Form Module
Creating Basic Form Modules
Creating a Form Module
Using Data Block Wizard to Create and Modify Data Blocks
Creating and Modifying Layouts Using the Layout Wizard
Saving, Compiling, and Running a Form Module
Form Builder File Formats and Their Characteristics
Creating Data Blocks with Relationships
Running a Master/Detail Form Module
Running a Form Builder Application
Understanding the Runtime Environment
Navigating a Form Builder Application
Understanding the Two Modules of Forms Runtime Operation
Retrieving Data into a Form Builder Application
Inserting, Updating, and Deleting Records
Displaying Database Errors Using the Help Facility
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
Forms Design I
Working with Data Blocks and Frames
Property Palette Components
Manipulating Properties
Controlling the Behavior of Data Blocks
Controlling Frame Properties
Creating Blocks That Do Not Correspond to a Database Object
Deleting Data Blocks and Their Components
Working with Text Items
Introduction to Text Items
Modifying a Text Item's Appearance
Controlling the Data In a Text Item
Modifying the Navigational Behavior of a Text Item
Enhancing the Relationship Between the Text Item and a Database
Modifying the Functionality of a Text Item
Including Help Messages in Your Applications
Creating LOVs and Editors
Introduction to LOVs and Editors
Creating LOVs
Creating Editors
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
Forms Design II
Creating Additional Input Items
Introduction to Item Types that Allow Input
Creating a Check Box
Creating a List Item
Creating a Radio Group
Creating Noninput Items
Introduction to Item Types that Do Not Allow Input
Creating a Display Item
Creating an Image Item
Creating a Sound Item
Creating a Button
Creating a Calculated Field
Creating Windows and Content Canvases
Introduction to Windows and Content Canvases
Window and Content Canvases Properties
Displaying a Form Module in Multiple Windows
Working with Other Canvases
Introduction to Canvas Types
Creating an Overlay Effect Using Stacked Canvases
Creating a Toolbar
Creating a Tabbed Interface
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
Working with Triggers
Introduction to Form Triggers
Definition of a Trigger
Form Trigger Categories
Form Trigger Types and Scope
Form Trigger Properties
How to Produce Triggers
Writing Trigger Code
Understanding the Use of Built-In Subprograms
Introduction to the When-Window-Closed Trigger
Adding Functionality to Form Items
Supplementing the Functionality of Input Items
Supplementing the Functionality of Noninput Items
Using Query Triggers
Data Block Query Process and Triggers
Writing Triggers That Screen Query Conditions
Writing Triggers to Supplement Query Results
Debugging Triggers
Running a Form Module in Debug Mode
Understanding the Components of the Debugger
Debugging PL/SQL Code
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
Forms Processing
Forms Runtime Messages and Alerts
Introduction to the Default Messaging
Handling Errors Using Built-In Subprograms
Controlling System Messages
Creating and Controlling Alerts
Data Validation
Effects of the Validation Unit on a Form
Introduction to Form Builder Validation Properties
Controlling Validation Using Triggers
Navigation
Internal vs. External Navigation
Using Navigation Triggers
Introduction to Built-Ins That Cause Navigation
Transaction Processing
Commit Processing, Transaction Processing, and Triggers
Allocating Automatic Sequence Numbers to Records
Implementing Array DML
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
Forms Programming
Writing Flexible Code
Flexible Code and System Variables
Built-In Subprograms that Assist Flexible Coding
Writing Code to Reference Objects by Internal ID
Writing Code to Reference Objects Indirectly
Sharing Objects and Code
Inheriting Properties from Property Classes
Grouping Related Objects for Reuse
Reusing Objects from an Object Library
Reusing PL/SQL code
Managing Multiple-Form Applications
Defining Multiple-Form Functionality
Calling One Form from Another
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
Preparing for OCP Exam 4: Building Forms II
Project Builder
Managing Projects with Project Builder
Benefits of Using Project Builder
Creating Projects and Subprojects
Adding Files to a Project
Implicit and Explicit Dependencies
Compile Options
Delivering a Project
Customizing a Project Builder Environment
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
Working with Menu Modules
Creating Menu Modules
Menu Components
Creating, Saving, and Attaching Menu Modules
Setting Menu Properties Using the Property Palette
Creating Menu Toolbars
Creating Pop-Up Menus
Managing Menu Modules
Controlling the Menu Programmatically
Customizing Menu Modules with Substitution Parameters
Implementing Menu Security
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
Advanced Forms Programming I
Programming Function Keys
Redefining Function Keys
Determining When Key Triggers Should Be Used
Responding to Mouse Events
Introduction to Mouse Events
Causing a Form Module to Respond to Mouse Movement
Causing a Form Module to Respond to Mouse Button Actions
Controlling Windows and Canvases Programmatically
Creating Trigger Code to Interact with Windows
Controlling Windows Programmatically
Controlling Canvases
Controlling Data Block Relationships
Definition of Block Coordination
creating and Modifying Relations
Characteristics of Relation-Handling Code
Implementing a Coordination-Type Toggle
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
Advanced Forms Programming II
Building Multiple-Form Applications
Different Ways to Invoke Forms
Building Robust Multiple-Form Transactions
Passing Data Between Forms Using Parameter Lists
Defining Data Sources
Introduction to Diverse Data Source Types
Selecting Appropriate Data Sources for Data Blocks
Working with Record Groups
Creating Record Groups at Design Time
Creating and Modifying Record Groups Programmatically
Building Dynamic List Items by Using Record Groups
Using a Global Record Group to Communicate Between Forms
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
Advanced Forms Programming III
Including Charts and Reports in Forms
Using the Chart Wizard to Embed Charts in a Form
Using the Report Wizard to Create and Invoke Reports in a Form
Applying Timers to Form Objects
Creating a Timer
Deleting a Timer
Modifying a Timer
Utilizing Reusable Components
Introduction to the Reusable Components
Using the Calendar Class in an Application
Using Server Features in Form Builder
Introduction to Oracle Server Features in Form Builder
Partitioning PL/SQL Program Units
Handling Errors Raised by the Oracle Server
Performing DDL Commands
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
Preparing for OCP Exam 5: Building Reports
Introducing Oracle Reports
Designing and Running Reports
Style and Structure of Common Business Reports
Using Runtime Executable to Run Prebuilt Reports
Identifying Various Report Destinations
Viewing Report Output in the Report Previewer
Report Builder Concepts
Executable Components of Oracle Reports
Invoking Report Builder and Its Components
Main Objects in a Report
Creating Reports with Report Wizard
Creating Simple Tabular Reports with Report Wizard
Methods for Building Report Queries
Summarizing Report Values
Modifying Style and Content of Reports
Other Report Styles Available in Report Wizard
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
Oracle Reports: Introduction to Report Builder
Modifying Reports using Live Previewer
Describing the Live Previewer
Modifying Display of Report Data with Live Previewer
Modifying Position of Report Data with Live Previewer
Adding Page Numbers and Current Date to Reports
Managing Report Templates
Describing the Template Regions
Modifying Template Default and Override Attributes
Modifying Predefined Report Templates
Registering Custom Templates
Report Storage Methods
Managing Storage of Report Definitions
Report Types and Their Portability
Converting Reports to Different Storage Types
Upgrading Report and Printer Definition Files
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
Enhancing Data Content in Report Builder
Using the Data Model to Create Queries and Groups
Data Model Objects and Their Relationships
Creating Groups to Modify Report Hierarchy
Changing Order of Data in Groups
Using Group Filters to Eliminate Data from Reports
Linking Data from Different Queries
Using the Data Model to Create Columns
Identifying Data Model Columns
Using Columns to Display File Contents
Creating and Using Formula Columns
Creating and Using Summary Columns
Creating and Populating Placeholder Columns
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
Enhancing Layout and Properties in Report Builder
Enhancing Reports Using the Layout Model
Viewing and Modifying Objects in Four Report Regions
Designing Multipanel Reports
Layout Objects and Their Relationships
Modifying Existing Report Layout with Layout Model Tools
Separating Tabular Data Columns with Lines
Creating Buttons to Display Multimedia Objects
Creating Explicit Anchors to Alter Object Positions
Modifying Layout Properties in Reports
Using Link Files in Reports to DisplayFile Contents
Modifying Layout Properties Common to All Object Types
Modifying Layout Properties Specific to One Object Type
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
Developing Other Features in Reports
Using Report Parameters and Parameter Forms
Controlling Report Output with Parameters
Creating User Parameters in a Report
Creating Lists of Values for Parameter Input
Incorporating User Parameters into Queries
Using and Modifying System Parameters
Building Parameter Form Layouts for Data Entry
Customizing Parameter Form Layouts
Embedding Charts in Reports
Creating Graphics Charts with Chart Wizard
Displaying Existing Graphics Charts in Reports
Using Parameters for Dynamic Modification of Chart Data
Developing and Enhancing Matrix Reports
Designing a Matrix Data Model
Designing a Matrix Layout Model
Displaying Zeros in Cells with No Value
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
Advanced Topics in Report Design
Coding PL/SQL Triggers in Reports
Different Types of Triggers and Their Usage
Writing and Referencing Common Code
Creating and Referencing a PL/SQL Library
Using Report Builder Built-in Packages
Report Builder SRW Built-In Package Contents
Using SRW Package Procedures and Functions
Output Messages at Run Time
Using Temporary Tables in Reports
Modifying Visual Attributes at Run Time
Maximizing Performance Using Reports Server
Comparing Local Client and Report Server Reporting
The Reports Server Architecture
Viewing and Scheduling Reports in Queue Manager
Invoking Oracle Reporting ActiveX Control from Other Apps
Building Reports for Different Environments
Character Mode vs. Bitmap Mode
Considerations When Building Reports for Different GUIs
Character Mode Reports and Their Settings
Facilities for Building Reports in Other Languages
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
Appendix: Preparing for Developer 2.0 New Features Upgrade Exam
Managing Projects with Project Builder
Creating Form Documents Using Wizards
Representing Data Within Your Application
Enhancing Items
Enhancing Interactivity
Ensuring Consistency Across Applications
Including Charts and Reports
Creating Reports Using Report Wizard
Modifying and Enhancing Reports
Maximizing Performance Using Reports Server
Deploying Reports on the Web
Index
×
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.

×