Oracle 9i Fundamentals I Exam Cram 2
Oracle 9i Fundamentals I Exam Cram 2
ISBN: 0789732653
EAN: 2147483647
EAN: 2147483647
Year: 2004
Pages: 244
Pages: 244
Authors: April Wells
- Oracle 9i Fundamentals I Exam Cram 2 (Exam 1Z0-031)
- Table of Contents
- 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
- A
- B
- C
- D
- E
- F
- G
- H
- I
- J
- K
- L
- M
- N
- O
- P
- Q
- R
- S
- T
- U
- V
- W
Oracle 9i Fundamentals I Exam Cram 2
ISBN: 0789732653
EAN: 2147483647
EAN: 2147483647
Year: 2004
Pages: 244
Pages: 244
Authors: April Wells