Candidates for the Oracle Certified Associate in Oracle Database 11g need to pass Exams 1Z0-051 and 1Z0-052 to achieve their certification—this guide prepares you for taking both those exams. This two-in-one study guide covers the Oracle Certified Associate certification for Oracle database 11g and reviews exam topics such as restricting and sorting data, using conversion functions and conditional expressions, displaying data from multiple tables, and exploring the Oracle database architecture. Plus, you'll learn how to create and maintain an Oracle database, perform database backups and recovery, move and manipulate data, prepare the database environment, and more.

Candidates for the Oracle Certified Associate in Oracle Database 11g need to pass Exams 1Z0-051 and 1Z0-052 to achieve their certification—this guide prepares you for taking both those exams. This two-in-one study guide covers the Oracle Certified Associate certification for Oracle database 11g and reviews exam topics such as restricting and sorting data, using conversion functions and conditional expressions, displaying data from multiple tables, and exploring the Oracle database architecture. Plus, you'll learn how to create and maintain an Oracle database, perform database backups and recovery, move and manipulate data, prepare the database environment, and more.

This Oracle Press certification exam guide offers detailed coverage of all of the official exam objectives on the Oracle Certified Professional Administration II exam, including installation, configuration, application tuning, database management, backup and recovery, security, and more. Real-world examples, practice questions, and chapter summaries help certification candidates learn the material. The CD-ROM contains two practice exams and an electronic copy of the book.

Prepare for the Oracle Certified Associate Oracle Database 11g: SQL Fundamentals I exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference.

A Fully Integrated Study System for OCA Exam 1Z0-052 Prepare for the Oracle Certified Associate Oracle Database 11 Administration I exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary 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 OCA objectives for exam 1Z0-052, including: Database architecture Creating an Oracle Database Managing the Oracle instance Configuring and managing the Oracle network Managing database storage structures Administering user security Managing schema objects, data and concurrency, and undo data Implementing Oracle Database security Database maintenance and performance management Backup and recovery Moving data Intelligent infrastructure enhancements On the CD-ROM: One full practice exam that simulates the actual OCA exam Detailed answers and explanations Score report performance assessment tool Complete electronic book Bonus exam available free with online registration.

A Fully Integrated Study System for OCA Exam 1Z0-052 Prepare for the Oracle Certified Associate Oracle Database 11 Administration I exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary 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 OCA objectives for exam 1Z0-052, including: Database architecture Creating an Oracle Database Managing the Oracle instance Configuring and managing the Oracle network Managing database storage structures Administering user security Managing schema objects, data and concurrency, and undo data Implementing Oracle Database security Database maintenance and performance management Backup and recovery Moving data Intelligent infrastructure enhancements On the CD-ROM: One full practice exam that simulates the actual OCA exam Detailed answers and explanations Score report performance assessment tool Complete electronic book Bonus exam available free with online registration.

A Fully Integrated Study System for OCP Exam 1Z0-050 Prepare for the Oracle Certified Professional Oracle Database 11 New Features for Administrators exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary 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 OCP objectives for exam 1Z0-050, including: Installation and upgrades Partitioning and storage Intelligent infrastructure Diagnostics and fault management Performance Oracle Recovery Manager and Oracle Flashback Security Oracle SQL Performance Analyzer SQL plan management Automatic SQL tuning On the CD-ROM: One full practice exam that simulates the actual OCP exam Detailed answers and explanations Score report performance assessment tool Complete electronic book Bonus exam available free with online registrat ion.

A Fully Integrated Study System for OCP Exam 1Z0-050 Prepare for the Oracle Certified Professional Oracle Database 11 New Features for Administrators exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary 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 OCP objectives for exam 1Z0-050, including: Installation and upgrades Partitioning and storage Intelligent infrastructure Diagnostics and fault management Performance Oracle Recovery Manager and Oracle Flashback Security Oracle SQL Performance Analyzer SQL plan management Automatic SQL tuning On the CD-ROM: One full practice exam that simulates the actual OCP exam Detailed answers and explanations Score report performance assessment tool Complete electronic book Bonus exam available free with online registrat ion.

The Ultimate Reference & Learning Guide for Oracle Financials Consultants! Over 150 Certification Questions, Answers, and Explanations It's clear that Oracle Financials is the future for ERP in Oracle - but finding good reference materials can be difficult. Now, for the first time, a world class Oracle consultant shares his knowledge and understanding of this complex topic. Oracle Financials Interview Questions guides you easily through your learning process. From helping you to assess your Oracle Financials skills, to helping screen candidates for your Oracle positions, Oracle Financials Interview Questions will help you understand what you really need to know. This book is organized around several areas of Oracle Financials: General Ledger, Accounts Payable, Accounts Receivable, OFSA, Budget module, Technical installation & configuration, Procure to Pay. In addition, Oracle Fusion Middleware is covered. Each question is based on implementation project know-how gained on high- profile Oracle Financials implementations. Key topics include: Fusion Middleware, General Ledger, Budget, AR/AP, Technical installation & configuration, Procure to Pay, much more.

The Ultimate Job Reference & Career Guide for Oracle Professionals! Over 150 Certification Questions, Answers, and Explanations Our books are for readers who must absolutely land their next job in Oracle, and who want to improve their existing positions. ORACOOKOOK readers have a need for information they can use right now. Our series of Oracle interview questions books is a direct answer to that need for instant information in the modern workplace. Our books are written by Oracle practition ers and expert authors who have varied vast experiences in the world of information technology. If great careers begin with a good book, the best careers begin with ORACOOKBOOK Over 150 Certification Questions, Answers and Explanations guide you through your learning process. Suitable for developers of any and every level of Oracle expertise, the book is organized around design, performance tuning, and audit and security. Each question includes everything you need to know to master the interview or properly evaluate a candidate. More than just a rehash of Oracle documentation and sales presentations, each question is based on project knowledge and experience gained on successful high-profile implementations.

Complete coverage of the exam objectives, hands-on exercises, review questions, and more, this is the first and only book to offer such in-depth coverage of this challenging exam. Takes into consideration that candidates must not only know how to install and configure Oracle Application Server 10g, but how to use the robust tool set, including Oracle HTTP Server and OracleAS Portal. The book features an interactive CD-ROM, including the Sybex Test Engine with chapter review questions and bonus exams, a series of flash cards that can be used on a PC or handheld, and an e-version of the book

Oracle 10g Database Administrator II: Backup/Recovery uses the most current database release from Oracle to provide thorough coverage of an Oracle database through the day-to-day duties of a database administrator.

Prepare for the Oracle Certified Administrator Oracle Application Server 10g exam with help from this exclusive Oracle Press guide. Get complete coverage of all topics on the exam 1Z0-311, including installation, configuration, and management of Oracle Application Server 10g, as well as details on Oracle Internet Directory, Oracle HTTP Server, Oracle Single Sign-On Server, Oracle Portal, Oracle Application Server Containers for J2EE (OC4J), and Oracle Web Cache. In each chapter, you'll find cert ification objectives, examples, a two-minute drill, and a self-test to highlight what you've learned. This book and CD-ROM package is the most comprehensive preparation tool available for this OCA exam.

The Most Authoritative OCA/OCP Exam Guide Available Prepare to pass the OCA and OCP Oracle Database 10g certification exams with help from this Oracle Press guide. With complete coverage of all the material on Exam #1Z0-042 Oracle Database 10g: Administration I and Exam #1Z0-043 Oracle Database 10g: Administration II, this book covers everything you need to know to pass both exams. Inside, you'll find helpful exam tips, hundreds of practice questions, and real-world exercises. This comprehensive guide serves as both a study tool and an on-the-job reference. Get full details on all exam objectives, including how to: Install Oracle Database 10g and create a database Use SQL, SQL*Plus, iSQL*Plus, and PL/SQL Create and manage database user accounts Configure Oracle Networking Manage shared servers Monitor, tune, and troubleshoot a database Handle database backup, restore, and recovery Use Oracle Recovery Manager and Oracle Flashback Configure and manage security Use Automatic Storage Manag ement and Resource Manager Automate administrative tasks Included on the CD-ROM Electronic Practice Test engine with two full practice exams Complete electronic book

Here's the comprehensive and affordable self-study solution you need to prepare for the Oracle Database 10g Administration I and Administration II exams. These Study Guides were developed to meet the exacting requirements of today's Oracle certification candidates. In addition to the consistent and accessible instructional approach that has earned Sybex the reputation as the preferred publisher for IT certification exam candidates worldwide, each book provides: * Clear and concise information on database administration with Oracle 10g * Practical examples and insights drawn from the authors' real-world experiences * Leading-edge exam preparation software, including a test engine and electronic flashcards

Here's the book you need to prepare for the Oracle Database 10g Administration II exam, 1Z0-043. This Study Guide was developed to meet the exacting requirements of today's Oracle certification candidates. In addition to the consistent and accessible instructional approach that has earned Sybex the "Best Study Guide" selection in CertCities Readers' Choice Awards for two consecutive years

Here's the book you need to prepare for the Oracle Database 10g Administration I exam, 1Z0-042. This Study Guide was developed to meet the exacting requirements of today's Oracle certification candidates. In addition to the consistent and accessible instructional approach that has earned Sybex the "Best Study Guide" selection in CertCities Readers Choice Awards for two consecutive years

Whether you're studying for the Oracle 9i Fundamentals I exam or just need to take the New Features update exam, Oracle 9i Funamentals I Exam Cram 2 can help you get certified. This efficient guide follows the exam objectives clearly and concisely. New Features materials are also included in the book, as well as a full-customizable practice test engine on CD. Oracle 9i Fundamentals I Exam Cram 2 is your smartest way to get certified.

Here's the book you need to prepare for Oracle's 10g upgrade exam, Oracle Database 10g: New Features for Administrators (1Z0-040). This Study Guide was developed to meet the exacting requirements of today's Oracle certification candidates. In addition to the consistent and accessible instructional approach that has earned Sybex the "Best Study Guide" selection in CertCities Readers Choice Awards for two consecutive years

Prepare for the Oracle Certified Professional Oracle Database 10 g New Features for Administrators exam with help from this exclusive Oracle Press guide. Get complete coverage of all topics on the upgrade exam, including installation, configuration, application tuning, database management, backup and recovery, security, and more. In each chapter, you'll find examples, practice questions, lab questions, a two-minute drill, and a chapter summary to highlight what you've learned. This book and CD-R OM package is the most comprehensive preparation tool available for this OCP exam.

Whether you're studying for the Oracle 9i SQL exam or just need to take the New Features update exam, Oracle 9i: SQL Exam Cram 2 can help you get certified. This efficient study guide follows the exam objectives clearly and concisely. New Features materials are also included in the book, as well as a full-customizable practice test engine on CD. Oracle 9i: SQL Exam Cram 2 is your smartest way to get certified.

An instructor's guide for teaching Oracle DBA certification candidates, this book is highly technical and written for Oracle Certified Professional (OCP) DBA instructors who want to ensure that their students successfully pass their Oracle OCP certification exam. Covering those OCP topics that students find the most challenging, instructors will find targeted Oracle OCP testing content, test taking tips, and actual OCP test content. Other test topics covered include database architectures, desig n review meetings, software installation, database objects, backup and recovery, and tuning and performance.

A guide to Oracle DBA management scripts, this book is indispensable for all Oracle professionals who must quickly automate and manage their Oracle databases with scripts. An online code depot full of more than 200 pretested Oracle DBA scripts is provided. Coverage of all areas of Oracle database administration including data files, tablespace, and table and index management scripts is included. Also reviewed are mechanisms for automating Oracle database administration tasks and tips for automat ing without buying expensive tools.

Prepares students for the first exam in both the Oracle DBA and Internet Application Developer Certification Tracks, and offers a solid general understanding of Oracle9i SQL.

Using a series of labs with examples and exercises, this guide introduces how to write programs in PL/SQL with discussion of syntax and structured programming, iterative control, scoping and anchored databases, cursors, triggers, security, tables, and packaging and parameter passing techniques. Integrated book-and-Web learning solution teaches all of the Oracle PL/SQL skills you need, through hands-on, real-world labs, exercises, projects, and the Web-based training site.

Save 20% on four books! Prepare for the Oracle Certified Professional exams using this complete Oracle Press study system. In each book, you'll find in-depth details on all the material covered on these challenging exams, followed by practice questions and chapter summaries to highlight what you've learned. Books and CD-ROMs combined contain 1,200+ practice exam questions. This boxed set includes: OCP Introduction to Oracle9i: SQL Exam Guide, OCP Oracle9i Database: Fundamentals I Exam Guide, OCP Oracle9i Database: Fundamentals II Exam Guide, OCP Oracle9i Database: Performance Tuning Exam Guide.

Full Coverage of exams 1Z0-007 and 1Z0-031! Prepare for the Oracle Certified Associate (OCA) exams with this exam guide from the exclusive publishers of Oracle Press books. This volume is comprised of OCP Introduction to Oracle9i: SQL Exam Guide and OCP Oracle9i Database: Fundamentals I Exam Guide. Books and CD-ROMs combined contain more than 600 practice questions and cover all objectives for OCA certification.

The perfect way to prepare for the Oracle9i Performance Tuning exam! -Contains exam essentials, real-world scenario sidebars, scenario-based questions, and fill-in-the-blank questions. -The CD includes flashcards, chapter-by-chapter exams, randomly generated question sets, a bonus exam, and an electronic version of the book.

The perfect way to prepare for the Oracle9i DBA Fundamentals II exam! -Contains exam essentials, real-world scenario sidebars, scenario-based questions, and fill-in-the-blank questions. -The CD includes flashcards, chapter-by-chapter exams, randomly generated question sets, a bonus exam, and an electronic version of the book. The book you need to prepare for Exam 1Z1-032 Oracle 9i Database: Fundamentals II. Provides indepth coverage of official exam objectives and hundreds of challenging review questions. CD-ROM included.

Here's the book you need to prepare for Exam 1Z1-031: OCA/OCP: Oracle9i DBA Fundamentals I Study Guide In-depth coverage of official exam objectives Practical information on implementing and managing Oracle9i databases Hundreds of challenging review questions, in the book and on the CD Authoritative coverage of all exam objectives, including: Understanding Oracle architecture and its main components Identifying DBA administrative tools Setting up password file authentications Creating and managi ng Initialization Parameter Files Configuring OMF Create a database using Oracle Database Configuration Assistant Creating a database manually Featured on the CD The enclosed CD is packed with vital preparation tools and materials, beginning with the Sybex EdgeTest testing engine for the Oracle9i Fundamentals I exam. Loaded with hundreds of practice questions, it lets you test yourself chapter by chapter or according to objective areas. You'll also find electronic flashcards for your PC and Palm handhelds and two bonus exams that will help you prepare for the test. Also included is a complete electronic version of the book.

Get Certified with Official Exam Prep Material from Oracle Press. Prepare for the Oracle Certified Professional Oracle9i Database: Performance Tuning exam--a required exam for Oracle9i DBA certification--using this Oracle Press study guide. Throughout each chapter, you'll find in-depth details on all the material covered on this challenging exam, followed by practice questions and chapter summaries to highlight what you've learned. Authorized by Oracle Corporation, this book and CD-ROM package is the most comprehensive preparation tool available for the Oracle9i Database: Performance Tuning exam. Book and CD-ROM include more than 300 interactive exam-based questions. CD-ROM contains interactive exams that simulate the actual OCP exams and include hotlinked questions, answers, and explanations.

Prepare for the Oracle Certified Professional Oracle9i Database: New Features for Administrators exam--a required exam for upgrading your Oracle8i or earlier DBA certification--using this Oracle Press study guide. Throughout each chapter, you'll find in-depth details on all the material covered on this challenging exam, followed by practice questions and chapter summaries to highlight what you've learned. Authorized by Oracle Corporation, this book and CD-ROM package is the most comprehensive pr eparation tool available for the Oracle9i Database: New Features for Administrators exam. Book and CD-ROM include more than 300 interactive exam-based questions. CD-ROM contains interactive exams that simulate the actual OCP exams and include hotlinked questions, answers, and explanations.

Learn the ins and outs of 9i with the OCA/OCP: Introduction to Oracle9i SQL Study Guide. This release from Sybex will prepare you for Exam 1Z0-007, Introduction to Oracle9i: SQL. You get hundreds of challenging review questions in the book and on the CD and authoritative coverage of all exam objectives. Here's the book you need to prepare for Exam 1Z0-007: Introduction to Oracle9i: In-depth coverage of official exam objectives Practical information on using SQL in a real-world Oracle9i en Hundr eds of challenging review questions, in the book and on the CD Authoritative coverage of all exam objectives, including: Writing basic SQL SELECT statements Restricting and sorting data Displaying data from multiple tables Aggregating data using group functions Producing readable output with iSQL*Plus Creating and managing tables Controlling user access.

Prepare for the Oracle Certified Professional Oracle9i Database: Fundamentals II exam--a required exam for Oracle9i DBA certification--using this Oracle Press study guide. Throughout each chapter, you'll find in-depth details on all the material covered on this challenging exam, followed by practice questions and chapter summaries to highlight what you've learned. Authorized by Oracle Corporation, this book and CD-ROM package is the most comprehensive preparation tool available for the Oracle9i Database: Fundamentals II exam.

Prepare for the Oracle Certified Professional Oracle9i Database: Fundamentals I exam--a required exam for Oracle9i DBA certification--using this Oracle Press study guide. Throughout each chapter, you'll find in-depth details on all the material covered on this challenging exam, followed by practice questions and chapter summaries to highlight what you've learned. Authorized by Oracle Corporation, this book and CD-ROM package is the most comprehensive preparation tool available for the Oracle9i D atabase: Fundamentals I exam.

This book delivers comprehensive coverage of exam objectives, presented according to Oracle's certification guide. Because Oracle's exam scoring provides section scores according to exact objectives, this organization of the book allows you to refocus. Each exam objective is covered in a chapter complete with self-assessment opportunities. Four appendices include a listing and description of Oracle's initialization parameters and other elements to be tested on the exam. These appendices provide information useful post-exam in real-work implementation of Oracle Systems.

Prepare to pass the OCP Building Internet Applications I ; II exams--two of four required exams for OCP Application Developer certifications--using this Oracle Press study guide. You'll get complete coverage of all exam topics followed by practice questions and chapter summaries. The CD-ROM contains hundreds of practice exam questions in an adaptive format.

Oracle 8i Performance and Tuning Exam Cram is the most recognized, and highly focused, exam preparation product available to professionals gearing up for the Oracle 8i Network Administration exam (1Z0-024). The book's well organized, concise layout provides thorough coverage of test content and objectives like describing Oracle Alert and Trace files, tuning the Shared Pool and Buffer Cache.

Oracle 8i Backup and Recovery Exam Cram is the most recognized, and highly focused, exam preparation product available to professionals gearing up for the Oracle 8i Backup and Recovery exam (1Z0-025). The book's well organized, concise layout provides thorough coverage of test content and objectives like using Oracle export and import utilities, understanding utilities for troubleshooting, describing Oracle recovery catalog creation and maintenance, and configuring an Oracle standby database. In cludes the supportive Exam Cram features of helpful hints and tips, test taking strategies, realistic case studies, and challenging practice questions.

Test your knowledge with exclusive software to prepare you for all five OCP Oracle8i DBA exams. --Contains 1000 questions in a tough adaptive format with a unique benchmarking feature to help you identify weak areas. --Delivers four sample exams for each test and is a great companion to the Sybex OCP: Oracle8i Study Guides.

Boxed set certification kit for the Oracle 8i DBA exams, numbers 1Z0-001, 1Z0-023, 1Z0-024, 1Z0-025, and 1Z0-026. Includes three study guide texts, each with its own CD-ROM. Each includes custom testing engines with hundreds of sample questions, electronic flashcards for PC and Palm devices, and other helpful features.

Prepare to pass All Five exams required for OCP DBA Certification. The only OCP DBA exam guide officially authorized by Oracle Corporation, this book/CD-ROM package offers comprehensive coverage of all five required exams: 1Z0-001: SQL and PL/SQL, 1Z0-023: Database Administration, 1Z0-025: Backup/Recovery, 1Z0-024: Tuning, 1Z0-026: Net8 Administration

The DBA (database administrator) track is the most popular, with more than 8,000 DBAs being certified each year. Sybex's OCP DBA Study Guides provide complete coverage of exam objectives for the five exams in the DBA track: SQL and PL/SQL, Database Administration, Backup & Recovery, Performance Tuning, and Network Administration. The books are fully up-to-date for Oracle8i and include all the new features of Sybex's best-selling Study Guides. The companion CDs contain exclusive self-testing software. The DBO (database operator) exam is a new offering from Oracle, which prepares students for the full DBA track. It is fully supported by Oracle's partners: Sun, Novell, Compaq, and HP. Sybex's Study Guide provides complete coverage of the exam objectives and includes a companion CD with exclusive self-testing software.

Make a smart career move and begin enjoying all the rewards of OCP Financial Applications Consultant certification! This Oracle-endorsed study guide offers a complete preparation system geared to help you pass your exams with flying colors! The design of Oracle Press's OCP series is unprecedented in its level of focus. It provides readers with thorough explanatory text and plenty of examples. Following the main content will be: short chapter review; two-minute drill; 10-15 multiple choice questi ons modeled after the OCP exam questions and answers to chapter questions along with explanations. CD-ROM includes electronic, fully searchable version of the Exam Guide hyperlinked to over 300 practice exam questions.

Specially designed and written to help you pass the Oracle8: Network Administration (1Z0-016) exam, Oracle DBA Network Administration Exam Cram is packed with time-saving study tips, test-taking strategies, and warnings on how to deal with trick questions. Includes a sixty-two question sample test with answer key and a special CRAM SHEET with tips, acronyms, and memory joggers with help you pass the exam the first time. Oracle DBA Network Administration Exam Cram will help you learn how to use t he Net8 Assistant; configure local naming; configure host naming; configure an Oracle Names Server; set up connection pooling; configure LISTENER processes; set up multiple LISTENER processes on a server; configure client profiles; set parameters for MTS; monitor MTS processes; set up connection; start, stop, and monitor LISTENER; configure Intelligent Agent; start, stop, and monitor Intelligent Agent; implement security with Net8; troubleshoot Net8 problems on the client and the server, use the Connection Manager.

2001-2011 Oracle-Books.com