Download OCA-OCP: Oracle9i DBA Fundamentals I: study guide by Biju Thomas PDF

By Biju Thomas

-Your key to reaching certification in Oracle's made over DBA music! -Contains examination necessities, real-world situation sidebars, scenario-based questions, and fill-in-the-blank questions. -The CD comprises flashcards, chapter-by-chapter checks, randomly gen

Show description

Read or Download OCA-OCP: Oracle9i DBA Fundamentals I: study guide PDF

Similar oracle books

Oracle9i Java Developers Guide

This publication lias been written for the next audiences:■ Management-You could have bought Oracle9i for purposes except Java improvement in the database. in spite of the fact that, as a way to understand extra approximately Oracle9i Java positive aspects, see "Overview of Oracle9i Java Documentation" on web page 1-23 for a administration standpoint.

Oracle XSQL: Combining SQL, Oracle Text, XSLT, and Java to Publish Dynamic Web Content

There are few books out that take care of Oracle textual content and XSQL. using the methodologies, practices, and so on. i discovered little need to go looking for one more reference.

Oracle Performance Survival Guide: A Systematic Approach to Database Optimization

Oracle functionality Survival consultant   a scientific method of Database Optimization   the short, whole, start-to-finish consultant to optimizing Oracle functionality   Oracle functionality Survival advisor deals a based, systematic, start-to-finish method for optimizing Oracle functionality as successfully as attainable.

Oracle Database 10g Database Administrator OCP Certification Exam Preparation Course in a Book for Passing the Oracle Database 10g Database ... on Your First Try Certification Study Guide

This self-study examination coaching consultant for the Oracle Database 10g Database Administrator OCP certification examination includes every thing you want to attempt your self and cross the examination. All examination issues are lined and insider secrets and techniques, entire causes of all Oracle Database 10g Database Administrator OCP matters, attempt methods and assistance, a number of hugely lifelike pattern questions, and workouts designed to bolster knowing of Oracle Database 10g Database Administrator OCP options and get ready you for examination luck at the first try out are supplied.

Additional info for OCA-OCP: Oracle9i DBA Fundamentals I: study guide

Example text

In terms of overall security, the Oracle9i Server provides more “finegrained” enhancements: a better random number generator, the ability to more tightly control access to rows in a table, and a more useful and flexible means of auditing access to the database. The Oracle9i Server is much easier to manage from a DBA perspective with the new Oracle Managed Files (OMF) and the automated undo features. Security is further enhanced by the Secure Application Role feature, which replaces a relatively weak password authentication method with a more robust and secure stored procedure methodology for enabling roles.

You can now explicitly specify query join types in FROM clauses, rather than in the WHERE clause. The join types supported include cross joins (Cartesian products), natural joins (equijoins), and full, left, and right outer joins. Oracle9i expands on the CASE expression that has been available since Oracle8i. ELSE construct and allows for multiple predicates within the WHEN clauses. The NULLIF and COALESCE functions operate much like “abbreviated” CASE statements for returning and evaluating null values.

A schema is a logical structure that groups the database objects. A schema is not directly related to a tablespace or to any other logical storage structure. The objects that belong to a schema can reside in different tablespaces, and a tablespace can have objects that belong to multiple schemas. Schema objects include structures such as tables, indexes, synonyms, procedures, triggers, database links, and so on. Physical Storage Structures The physical database structure consists of three types of physical files: Data files Redo log files Control files The purpose and contents of each type of file are explained in the following paragraphs.

Download PDF sample

Rated 4.33 of 5 – based on 7 votes