Book description
Whether you're studying for the Oracle 9i SQL exam or just need to take the New Features update exam, Oracle 9i: SQL Exam Cram 2 can help you get certified. This efficient study guide follows the exam objectives clearly and concisely. New Features materials are also included in the book, as well as a full-customizable practice test engine on CD. Oracle 9i: SQL Exam Cram 2 is your smartest way to get certified.
Table of contents
- Copyright
- Oracle 9i Cram Sheet
- A Note from Series Editor Ed Tittel
- About the Author
- We Want to Hear from You!
- Introduction
- Self-Assessment
- 1. Getting Started with Oracle Database
- 2. Retrieving Data (SELECT)
- 3. Filtering (WHERE) and Sorting Data (ORDER BY)
- 4. Operators, Conditions, Pseudocolumns, and Expressions
- 5. Single Row Functions
- 6. Joining Tables
- 7. Groups and Summaries (GROUP BY)
- 8. Subqueries and Other Specialized Queries
- 9. SQL*Plus Formatting
- 10. Changing Data (DML)
- 11. Tables, Datatypes, and Constraints (DDL)
- 12. Views, Indexes, Sequences, and Synonyms (DDL)
- 13. Security (DDL)
- 14. Practice Test #1 (60 questions)
- 15. Answer Key to Practice Test #1
- 16. Practice Test #2
- 17. Answer Key to Practice Test #2
- A. CD Contents and Installation Instructions
- B. Need to Know More?
- Glossary
Product information
- Title: Oracle® 9i SQL Exam Cram™ 2 (Exam 1Z0-007)
- Author(s):
- Release date: September 2004
- Publisher(s): Pearson IT Certification
- ISBN: 9780789732484
You might also like
book
Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031)
Whether you're studying for the Oracle 9i Fundamentals I exam or just need to take the …
book
Creating Highly Available Database Solutions: Oracle Real Application Clusters (RAC) and Sun Cluster 3.x Software
This book explains how to architect and deploy high availability (HA) solutions with Oracle Real Application …
book
Oracle Database 10g The Complete Reference
Get a thorough understanding of Oracle Database 10 g from the most comprehensive Oracle database reference …
book
Oracle Database 10g DBA Handbook
Everything a DBA needs to know in one volume--this is the must-have reference for anyone working …