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
Read or Download OCA-OCP: Oracle9i DBA Fundamentals I: study guide PDF
Similar oracle books
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.
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 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.
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.
- Oracle Databases on the Web: Learn to Create Web Pages That Interface with Database Engines
- Pro Oracle application express
- Oracle 11i E Business Suite From The Front Lines
- Oracle 11g For Dummies
- Oracle SQL Tuning Pocket Reference
Additional info for OCA-OCP: Oracle9i DBA Fundamentals I: study guide
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.