hi.. i have OCA and OCP Oracle Database 11g Administrator book (sybex).. Is it good to learn and professionalism? thank you. Editorial Reviews. From the Back Cover. Prepare for two OCA certification exams with this one He has coauthored five Oracle certification books published by Sybex and has written articles for multiple Oracle technical publications. OCA: Oracle Database 11g Administrator Certified Associate Study Guide: He has coauthored five Oracle certification books published by Sybex and has.

Author: Gajinn Dailmaran
Country: South Sudan
Language: English (Spanish)
Genre: Software
Published (Last): 13 October 2011
Pages: 495
PDF File Size: 8.95 Mb
ePub File Size: 5.53 Mb
ISBN: 188-4-56398-640-9
Downloads: 21782
Price: Free* [*Free Regsitration Required]
Uploader: Malajas

OCA: Oracle Database 11g Administrator Certified Associate Study Guide – O’Reilly Media

Primary Key Constraints 6. Auditing Database Activity Inserting into a Single Table New Features for Administrators 1Z Choosing Other Tablespace Options Invoking the Database Configuration Assistant 9.

Candidates for the Oracle Certified Associate in Oracle Database 11g need to pass Exams 1Z and 1Z 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 ofacle 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.

Maximizing Data Concurrency Subquery Returns No Rows 4. Important Performance Metrics Using Automatic Workload Repository Granting Sjbex Privileges Multiplexing Control Files Use Common Location for all Database Files 9.

You’ll find valuable information on how to use a business blueprint and system architecture to your company’s greatest benefit.

Table of Contents Part I: Globally Authenticated Users Oracle Database Foundations provides essential knowledge about installing, configuring, maintaining, and querying Or acle 9i and 10g databases.

Using the Data Recovery Advisor Working with Triggering Events and Managing Triggers Adding New Members Dynamic Performance Views Right Outer Joins 4.

Operators and Literals 1. Multiplexing Control Files Using an Spfile Architecture of Data Pump Sources of Tuning Information The Connection Mode Tab 9.

Making Tables Read-Only 6. Dynamically Registering Services Redo Log Buffer 8. User-Managed Hot Backups Explore topics such as basic SQL SELECT statements, group functions, creating schema objects, restricting and sorting data, and much more with this essential two-in-one guide.

Answers to Review Questions 7.