"Exam 1Z0-007"--Cover.

Basic SQL Select Statements -- Oracle Datatypes -- Operators and Literals -- Writing Simple Queries -- Using the Select Statement -- Limiting Rows -- Other Operators -- In and Not In -- Between -- Exists -- Is Null and is Not Null -- Like -- Sorting Rows -- Sorting Nulls -- Using Expressions -- The Case Expression -- SQL * Plus Overview -- SQL * Plus Fundamentals -- Connecting to SQL * Plus -- Using SQL * Plus -- Using Script Files -- Customizing the SQL * Plus Environment -- Producing More Readable Output -- Setting Page and Line Sizes -- Formatting Columns -- Suppressing Duplicate Values -- Adding Headers and Footers -- Clearing Formatting -- Using a Script File to Create a Report -- Performing Summary Operations -- Accepting Values at Runtime -- Using Substitution Variables -- Saving a Variable for a Session -- Using Positional Notation for Variables -- Using the Accept Command -- Using iSQL * Plus -- iSQL * Plus Architecture -- Working with iSQL * Plus -- iSQL * Plus Restrictions -- Single-Row Functions -- Single-Row Function Fundamentals -- Nulls and Single-Row Functions -- Null Value Functions -- Using Single-Row Character Functions -- Character Function Overview -- Character Function Descriptions -- Using Single-Row Numeric Functions -- Numeric Function Overview -- Numeric Function Descriptions -- Using Single-Row Date Functions -- Date Format Conversion -- Date Function Overview -- Date Function Descriptions -- Using Single-Row Conversion Functions -- Conversion Function Overview -- Conversion Function Descriptions -- Using Other Single-Row Functions -- Miscellaneous Function Overview -- Miscellaneous Function Descriptions -- Aggregating Data And Group Functions -- Group Function Fundamentals -- Using Group Functions -- Group Function Overview -- Group Function Descriptions -- Grouping Data with Group By -- Limiting Grouped Data with Having -- Creating Superaggregates with Cube and Rollup -- Nesting Functions -- Joins and Subqueries -- Multiple-Table Queries -- Simple Joins -- Complex Joins -- Multi-Table Joins -- Cartesian Joins -- Outer Joins -- Other Multiple-Table Queries -- Subqueries -- Single-Row Subqueries -- Multiple-Row Subqueries -- Correlated Subqueries -- Scalar Subqueries -- Multiple-Column Subqueries -- Subqueries in Other DML Statements -- Modifying Data -- Using DML Statements -- Inserting Rows into a Table -- Inserting into Multiple Tables -- Updating Rows in a Table -- Merging Rows into a Table -- Deleting Rows from a Table -- Truncating a Table -- Truncate versus Delete -- Truncate versus Drop Table -- Selecting Rows for Update -- Locking a Table -- Deadlocks -- DML Locks in Oracle -- Understanding Transaction Control -- Savepoints and Partial Rollbacks -- Consistency and Transactions -- Enabling Transaction-Level or Statement-Level Consistency -- Specifying a Rollback Segment for a Transaction -- Managing Tables and Constraints -- Database Objects Review -- Built-in Datatypes -- Character Datatypes -- Numeric Datatype -- Date and Time Datatypes -- Binary Datatypes -- Row ID Datatypes -- Creating Tables -- Naming Tables and Columns -- Specifing Default Values for Columns -- Adding Comments -- Creating a Table from Another Table -- Modifying Tables -- Adding Columns -- Modifying Columns -- Dropping Columns -- Dropping Tables -- Renaming Tables -- Managing Constraints -- Creating Constraints -- Not Null Constraint -- Check Constraints -- Unique Constraints -- Primary Key Constraints -- Foreign Key Constraints -- Disabled Constraints -- Dropping Constraints -- Enabling and Disabling Constraints -- Validated Constraints -- Deferring Constraint Checks -- Managing Views -- Creating and Modifying Views -- Using Defined Column Names -- Creating Views with Errors -- Creating Read-Only Views -- Creating Constraints on Views -- Modifying Views -- Dropping a View -- Using Views -- Using Views in Queries -- Inserting, Updating, and Deleting Data through Views -- Using Join Views -- Viewing Allowable DML Operations -- Using Inline Views -- Performing Top-'N' Analysis -- Other Database Objects -- Creating and Managing Sequences -- Creating and Dropping Sequences -- Using Sequences -- Altering Sequences -- Creating and Managing Synonyms -- Creating and Dropping Synonyms -- Resolving Object References -- Creating and Managing Indexes -- How Indexes Work -- Using B-Tree Indexes -- Using Bitmap Indexes -- Calling Stored Programs -- Using Procedures and Functions -- Using Packages -- User Access and Security -- Creating and Modifying User Accounts -- Configuring Account Authentication -- Assigning Attributes to Accounts -- Using Account Licensing Controls -- Creating and Using Roles -- Granting and Revoking Privileges -- Object Privileges -- System Privileges -- Assigning Privileges -- Revoking Privileges -- Viewing Privileges in the Data Dictionary -- Managing User Groups with Profiles -- Enabling Resource Settings -- Creating and Altering Profiles.

The perfect way to prepare for the Introduction to Oracle9i SQL exam. Contains exam essentials, real-world scenario sidebars, scenario-based questions, and fill-in-the-blank questions. The CD includes flashcards, chapter-by-chapter exams, random-generated question sets, a bonus exam, and an electronic version of the book.