| | | Copyright |
| | | Oracle 9i Cram Sheet |
| | | | THE ITERATIVE SYSTEM DEVELOPMENT CYCLE |
| | | | BASIC TERMINOLOGY |
| | | | THE SELECT STATEMENT |
| | | | JOINING TABLES |
| | | | SPECIALIZED QUERIES |
| | | | OPERATORS |
| | | | CONDITIONS |
| | | | PSEUDOCOLUMNS |
| | | | EXPRESSIONS |
| | | | FUNCTIONS |
| | | | CHANGING DATA (DML) |
| | | A Note from Series Editor Ed Tittel |
| | | About the Author |
| | | About the Technical Editors |
| | | Acknowledgements |
| | | We Want to Hear from You! |
| | | Introduction |
| | | | How to Prepare for an Exam |
| | | | Exam Format |
| | | | Testing Situation |
| | | | Using the Book |
| | | Self-Assessment |
| | | | In the Real World |
| | | | The Ideal Candidate |
| | | | Put Yourself to the Test |
| | | | Assessing Your Readiness for the Exam |
| | | | Onward Through the Fog |
| | | Chapter 1. Oracle Architecture Components |
| | | | Database Versus Instance |
| | | | Datafiles |
| | | | Memory Structures |
| | | | Shared SQL Area |
| | | | Program Global Areas (PGA) Overview |
| | | | Process Architecture |
| | | | Background Processes |
| | | | Connecting to an Instance |
| | | | Exam Prep Questions |
| | | | Need to Know More? |
| | | Chapter 2. Getting Started with the Oracle Server |
| | | | Administrative Tools |
| | | | Oracle Universal Installer (OUI) |
| | | | Oracle Database Configuration Assistant (DBCA) |
| | | | Optimal Flexible Architecture (OFA) |
| | | | Password File Authentication |
| | | | DBA Tools |
| | | | Exam Prep Questions |
| | | Chapter 3. Creating a Database |
| | | | Prerequisites for Database Creation |
| | | | Planning Database File Locations |
| | | | Creating the Database |
| | | | Oracle Database Configuration Assistant |
| | | | Create a Database Manually |
| | | | What to Do If Database Creation Fails |
| | | | Exam Prep Questions |
| | | | Need to Know More? |
| | | Chapter 4. Managing an Instance |
| | | | Initialization Parameter Files |
| | | | Oracle Managed File (OMF) System |
| | | | Database Startup |
| | | | Working with the STARTUP Command |
| | | | Shutting Down the Database |
| | | | Managing the Instance by Monitoring the Diagnostic Files |
| | | | Exam Prep Questions |
| | | | Need to Know More? |
| | | Chapter 5. Data Dictionary Content and Usage |
| | | | Oracle's Data Dictionary |
| | | | How the Data Dictionary Is Used |
| | | | Accessing Data Dictionary and Dynamic Performance Views |
| | | | Creating the Data Dictionary |
| | | | Common Views and Their Uses |
| | | | Exam Prep Questions |
| | | | Need to Know More? |
| | | Chapter 6. Storage Structure and Relationships |
| | | | Segments |
| | | | Extents |
| | | | Database Data Blocks |
| | | | Block Utilization Parameter |
| | | | Storage Structure Information in the Data Dictionary |
| | | | Exam Prep Questions |
| | | | Need to Know More? |
| | | Chapter 7. Globalization Support |
| | | | Globalization Support |
| | | | Character Sets and Encoding Schemes |
| | | | Database Character Set |
| | | | National Character Set |
| | | | Language-Dependent Behavior Specification |
| | | | Setting Environment Variables |
| | | | Linguistic Sorting |
| | | | Language-Dependent Application Behavior |
| | | | Globalization Support Information in the Data Dictionary |
| | | | Globalization Support Utilities |
| | | | Exam Prep Questions |
| | | Chapter 8. Maintaining Control Files |
| | | | What Are Control Files? |
| | | | Multiplexing Control Files |
| | | | The CREATE CONTROLFILE Command |
| | | | Dropping Control Files |
| | | | Backing Up the Control File |
| | | | Obtaining Control File Information |
| | | | Control File-Related Parameters |
| | | | Managing the Control File with OMF |
| | | | Exam Prep Questions |
| | | Chapter 9. Maintaining Redo Log Files |
| | | | Purpose of Online Redo Log Files |
| | | | Structure of Online Redo Log Files |
| | | | Control Log Switches and Checkpoints |
| | | | Multiplexing and Maintaining Online Redo Log Files |
| | | | Using OEM to Maintain Redo Log Groups and Members |
| | | | Managing Redo Log Files with OMF |
| | | | Data Dictionary Redo Information |
| | | | Archived Redo Log Files |
| | | | Exam Prep Questions |
| | | Chapter 10. Managing Tablespaces and Data Files |
| | | | Logical Structure of the Database |
| | | | Types of Tablespaces |
| | | | Creating Tablespaces |
| | | | Dropping Tablespaces |
| | | | Space Management in Tablespaces |
| | | | Changing the Size of the Tablespace |
| | | | Manipulating Tablespaces and Data Files with OEM |
| | | | Implementing Oracle Managed Files (OMF) |
| | | | Data Dictionary Tablespace and Data File Information |
| | | | Exam Prep Questions |
| | | | Need to Know More? |
| | | Chapter 11. Managing Undo Data |
| | | | Logical Structure of Undo Segments in the Database |
| | | | Purpose of Undo Data |
| | | | Types of Undo Data |
| | | | Implementing Automatic Undo Management |
| | | | Data Dictionary Information on Undo |
| | | | Exam Prep Questions |
| | | Chapter 12. Managing Tables |
| | | | Methods of Storing Data |
| | | | Oracle Data Types |
| | | | Structure of a Row |
| | | | Creating Regular and Temporary Tables |
| | | | External Tables |
| | | | Managing Storage Structures |
| | | | Regular Table Operations |
| | | | Column Operations |
| | | | Data Dictionary Information on Tables |
| | | | Exam Prep Questions |
| | | Chapter 13. Managing Indexes |
| | | | Different Types of Indexes and Their Uses |
| | | | Creating Indexes |
| | | | Changing Storage Parameters for Indexes |
| | | | Reorganizing Indexes |
| | | | Index Information in the Data Dictionary |
| | | | Exam Prep Questions |
| | | Chapter 14. Maintaining Data Integrity |
| | | | Defining Data Integrity |
| | | | Implementing Data Integrity Constraints |
| | | | Maintaining Integrity Constraints |
| | | | Constraint Information in the Data Dictionary |
| | | | Exam Prep Questions |
| | | Chapter 15. Managing Users |
| | | | Creating New Users |
| | | | Altering Users |
| | | | Dropping Users |
| | | | User Information in the Data Dictionary |
| | | | Exam Prep Questions |
| | | Chapter 16. Managing Password Security and Resources |
| | | | Manage Passwords Using Profiles |
| | | | Administering Profiles |
| | | | Controlling Resources Using Profiles |
| | | | Managing Resource Plans and Consumer Groups |
| | | | Data Dictionary Information About Profiles, Password Management, and Resources |
| | | | Exam Prep Questions |
| | | Chapter 17. Managing Privileges |
| | | | System Privileges |
| | | | Object Privileges |
| | | | Auditing Capabilities |
| | | | Data Dictionary Information |
| | | | Exam Prep Questions |
| | | Chapter 18. Managing Roles |
| | | | Creating and Modifying Roles |
| | | | Granting Roles |
| | | | Controlling Availability of Roles |
| | | | Removing Roles |
| | | | Using Predefined Roles |
| | | | Role Creation Guidelines |
| | | | Role Information in the Data Dictionary |
| | | | Exam Prep Questions |
| | | Chapter 19. Practice Exam 1 |
| | | Chapter 20. Exam 1 Answers |
| | | Chapter 21. Practice Exam 2 |
| | | Chapter 22. Exam 2 Answers |
| | | Appendix A. CD Contents and Installation Instructions |
| | | | Multiple Test Modes |
| | | | Question Types |
| | | | Random Questions and Order of Answers |
| | | | Detailed Explanations of Correct and Incorrect Answers |
| | | | Attention to Exam Objectives |
| | | | Installing the CD |
| | | | Technical Support |
| | | Glossary |
| | | Appendix C. Need to Know More? |
| | | | Chapter 1: Oracle Architectural Components |
| | | | Chapter 2: Getting Started with the Oracle Server |
| | | | Chapter 3: Creating a Database |
| | | | Chapter 4: Managing an Instance |
| | | | Chapter 5: Data Dictionary Content and Usage |
| | | | Chapter 6: Storage Structure and Relationships |
| | | | Chapter 7: Globalization Support |
| | | | Chapter 8: Maintaining Control Files |
| | | | Chapter 9: Maintaining Redo Log Files |
| | | | Chapter 10: Managing Tablespaces and Data Files |
| | | | Chapter 11: Managing Undo Data |
| | | | Chapter 12: Managing Tables |
| | | | Chapter 13: Managing Indexes |
| | | | Chapter 14: Maintaining Data Integrity |
| | | | Chapter 15: Managing Users |
| | | | Chapter 16: Managing Password Security and Resources |
| | | | Chapter 17: Managing Privileges |
| | | | Chapter 18: Managing Roles |
| | | Index |