A Fully Integrated Study System for OCA Exam 1Z0-052
Prepare for the Oracle Certified Associate Oracle Database 11g 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
Get full details on the powerful features of Oracle Database 11g from this thoroughly updated Oracle Press guide. Oracle Database 11g: The Complete Reference explains how to use all the new features and tools, execute powerful SQL queries, construct PL/SQL and SQL*Plus statements, and work with large objects and object-relational databases. Learn how to implement the latest security measures, tune database performance, and deploy grid computing techniques. An invaluable cross-referenced appendix containing Oracle commands, keywords, features, and functions is also included.
Install Oracle Database 11g or upgrade from an earlier version
Create database tables, sequences, indexes, views, and user accounts
Construct SQL statements, procedures, queries, and subqueries
Optimize security using virtual private databases and transparent data encryption
Import and export data using SQL*Loader and Oracle Data Pump
Use SQL replay, change management, and result caching
Avoid human errors using flashback and automatic undo management
Build and tune PL/SQL triggers, functions, and packages
Develop database applications using Java, JDBC, and XML
Optimize availability and scalability with Oracle Real Application Clusters
About this product: If you're doing database application development in the Oracle environment, you're going to have to know PL/SQL, the company's extended query and update language. If you want your programs to exploit the special capabilities of Oracle software, you'll need to know the language well. That's where the third edition of Oracle PL/SQL Programming comes into play. It's an absolutely comprehensive reference (as well as a rather extensive tutorial) on PL/SQL, ideally suited to answering your questions about how to perform some programming tasks and reminding you of the characteristics of functions, triggers, and other elements of the database programmer's toolkit. The new edition covers calls to Java methods from within PL/SQL programs, autonomous transactions, object type inheritance, and the new Timestamp and XMLType data types. There's also more information about server internals--the way PL/SQL programs are run--than before, better enabling readers to optimize their code for fast and safe execution.
Steven Feuerstein takes care to explain, with prose and example code, the characteristics of PL/SQL elements. In explaining number conversions, for example, he explores Oracle's different ways of formatting numbers, then details the behavior of the to_number function under different conditions (with and without a specified format model, and with National Language Support information attached). It's a helpful approach that will have readers using the index to locate places in which Feuerstein mentions language elements of interest. --David Wall
Topics covered: How to use Oracle PL/SQL in all its manifestations through Oracle9i. Fundamentals of program structure (loops, cases, exceptions, etc.) and execution get attention, as do data types, transaction management, triggers, and the object-oriented aspects of the language. There's also coverage of calls to external Java and C programs.
By popular demand, Doreen Virtue has created a beautiful deck of cards based on her best-selling book Archangels & Ascended Masters. The deck includes gorgeous paintings of 44 male and female cross-cultural deities, such as Ganesha, Merlin, Saint-Germain, Apollo, Pallas Athena, White Buffalo Calf Woman, Jesus, Moses, Yogananda, Green Man, and Kuthumi. The enclosed guidebook gives expanded explanations of each card’s meaning, and a brief history of each ascended master. As with each of Doreen’s oracle-card decks, the messages for each card are positive, accurate, and life-affirming.
About this product: Everything a DBA needs to know in one volume--this is the must-have reference for anyone working with the Oracle database, and it's been fully revised and updated for Oracle Database 10g. Co-author Kevin Loney is the all-time, best-selling Oracle Press author.
About this product: Learn cutting-edge technology from Oracle experts
Written by Oracle insiders, this comprehensive guide covers everything you need to know about Real Application Clusters -- low-cost hardware platforms that can rival and exceed the quality of service, availability, and scalability of the most expensive mainframe systems.
Concepts covered are applicable to all previous versions of Oracle
Tuning and troubleshooting tips, providing insight on the most advanced diagnostics available
This easy-to-use deck is appropriate for beginners as well as those experienced with divination cards. Angel Therapy is a powerful healing and guidance process that involves working with your guardian angels and the archangels (particularly Michael and Raphael). These oracle cards and the enclosed guidebook give you action steps to take that will initiate healing; help you release fears and emotional blocks; and give you messages about your life purpose, relationships, manifestations, and more.
Each card features a gorgeous painting of angels and a message or answer for you, and is suitable for both children and adults. The guidebook walks you through the steps for giving an oracle reading for yourself or others, and outlines the extended meanings behind each card.
About this product: What ancient mysteries lurk behind the amazing stories in the Dragons in our Midst series? Eye of the Oracle takes the reader back in time to the days when dragons abounded. From the era just before Noah s ark, through the battles between dragons and mankind in the time of King Arthur, and to the haunting presence of dragons in our day, this stunning prequel reveals the mysteries that led to the bestselling fantasy adventure that began with Raising Dragons. How did dragons survive the flood? Who helped preserve an ancient evil force that led to the demise of the dragons in the days of King Arthur? What heroic sacrifices kept that evil from exterminating the dragon race forever? If you enjoyed the heart-stopping action and spiritual depth of the first four books in this series, you won t want to miss the astonishing story that began it all. Eye of the Oracle will captivate young and old alike, and it will challenge every reader to search deep within for answers to the mysteries in their own hearts.
About this product: Four for the price of one! Oracle Database 10g OCP Certification All-in-One Exam Guide is the only book that offers thorough exam prep and a great on-the-job reference for both the latest OCA and OCP exams.
Also includes the Boson’s Oracle self-assessment engine to get experience taking the test in the environment it will be given
The Most Complete Guide to Maximizing Oracle Recovery Manager
Deploy a rock-solid data backup and disaster recovery strategy with the in-depth guidance of this authoritative volume. From the exclusive publishers of Oracle Press books, Oracle Database 10g RMAN Backup And Recovery shows you, step by step, how to set up RMAN-ready databases, create reliable backup tapes and discs, and perform accurate Oracle system restores. Find out how to use RMAN from the command line and from Enterprise Manager, generate meaningful lists and reports, and automate administrative tasks using third-party media management tools. Plus, you'll learn to perform incremental backups, Flashback recoveries, and database cloning.
Set up, configure, and maintain Oracle Database 10g RMAN
Use RMAN recovery catalogs, target database packages, and control files
Centralize backup tape management using Oracle Secure Backup
Perform online, offline, and incremental system backups
Monitor and tune performance with Enterprise Manager Grid Control and Database Control
Accomplish complete and partial RMAN database restores
Improve functionality using VERITAS NetBackup, EMC NetWorker Module, and Tivoli Storage Manager
Overcome human errors using Flashback Versions Query and Transaction Query
Create clone and standby databases from tape and disc backups
Work with Real Application Cluster (RAC) databases and sync-and-split hardware technologies