OCA Oracle Database 11g Administration I Exam Guide (Exam by John Watson

By John Watson

An absolutely built-in learn method for OCA examination 1Z0-052

Prepare for the Oracle qualified affiliate Oracle Database 11g management I examination with support from this particular Oracle Press advisor. In every one bankruptcy, you'll locate demanding workouts, perform questions, a two-minute drill, and a bankruptcy precis to focus on what you've realized. This authoritative advisor can help you cross the attempt and function your crucial on-the-job reference. Get whole insurance of all OCA goals for examination 1Z0-052, including:

Database architecture
developing an Oracle Database
coping with the Oracle instance
Configuring and dealing with the Oracle network
dealing with database garage structures
Administering person security
dealing with schema items, information and concurrency, and undo data
imposing Oracle Database security
Database upkeep and function management
Backup and recovery
relocating data
clever infrastructure improvements

Show description

Read Online or Download OCA Oracle Database 11g Administration I Exam Guide (Exam 1Z0-052) PDF

Similar oracle books

Oracle PL/SQL Programming 4Th Edition

За последние 10 лет книга Oracle PL/SQL Programming издательства O'Reilly's стала бестселлером среди книг по PL/SQL, процедурному языку базы данных Oracle. Снабженная примерами и полезными рекомендациями книнга является незаменимой как новичкам, так и гуру, как разработчикам на Oracle types, так и администраторам - используйте PL/SQL на полную мощь.

Oracle Streams 11g Data Replication

Grasp Oracle Streams 11g Replication allow real-time details entry and knowledge sharing throughout your dispensed framework utilizing the specialist details during this Oracle Press consultant. Oracle Streams 11g information Replication explains how one can manage and administer a unified firm info sharing infrastructure.

Oracle Application Express 4 Recipes

Oracle program convey four Recipes presents an example-based method of studying program show - the ground-breaking, quick program improvement platform integrated with each Oracle Database license. The recipes layout is perfect for the quick-study who simply desires a superb instance or to kick commence their considering and get pointed within the correct path.

Additional info for OCA Oracle Database 11g Administration I Exam Guide (Exam 1Z0-052)

Example text

A very extensive role indeed. 26 Chapter 1: ✓ Introduction to the Oracle Server Technologies TWO-MINUTE DRILL Position the Oracle Product Family ❑ The Oracle database stores and manages access to user data. ❑ The Oracle Application Server runs applications that connect users to the database. ❑ Oracle Enterprise Manager is a tool for managing databases, application servers, and if desired, the entire computing environment. ❑ Languages built into the database for application development are SQL, PL/SQL, and Java.

In the early days of computing, storage devices lacked the capability for maintaining the many separate files that were needed for the many relational tables. Note that this problem is avoided in the Oracle database by abstracting the physical storage (files) from the logical storage (tables); there is no direct connection between tables and files, and certainly not a one-to-one mapping. In effect, many tables can be stored in a very few files. A hierarchical structure stores all related data in one unit.

Procedural languages are usually less efficient than set-oriented languages at managing data, both as regards development and as regards execution. A procedural routine for looping through a group of rows and updating them one by one will involve many lines of code, whereas SQL might do the whole operation with one command: programmer productivity increases. During program execution, procedural code gives the database no options; it must run the code as it has been written. With SQL, the programmer states what he/she wants to do, but not how to do it: the database has the freedom to work out how best to carry out the operation.

Download PDF sample

Rated 4.49 of 5 – based on 7 votes