Flylib.com
Oracle 9i Fundamentals I Exam Cram 2
Oracle 9i Fundamentals I Exam Cram 2
ISBN: 0789732653
EAN: 2147483647
Year: 2004
Pages: 244
Authors:
April Wells
BUY ON AMAZON
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
Year: 2004
Pages: 244
Authors:
April Wells
BUY ON AMAZON
Image Processing with LabVIEW and IMAQ Vision
NI Vision Builder for Automated Inspection
CMOS Image Sensors
Camera Interfaces and Protocols
Frequency Filtering
Morphology Functions
Secure Programming Cookbook for C and C++: Recipes for Cryptography, Authentication, Input Validation & More
Building a Dynamic Library Using Boost.Build
Reducing #includes with Forward Class Declarations
Parsing a String Containing a Number in Scientific Notation
Storing Objects in Sorted Order
Passing an Argument to a Thread Function
The Complete Cisco VPN Configuration Guide
VPN Definition
VPNs: Choosing a Solution
Cisco WebVPN Solution
Concentrator Management
Summary
What is Lean Six Sigma
Key #2: Improve Your Processes
Key #3: Work Together for Maximum Gain
Making Improvements That Last: An Illustrated Guide to DMAIC and the Lean Six Sigma Toolkit
The Experience of Making Improvements: What Its Like to Work on Lean Six Sigma Projects
Six Things Managers Must Do: How to Support Lean Six Sigma
Java Concurrency in Practice
Risks of Threads
Locking
Implicit Couplings Between Tasks and Execution Policies
Extending ThreadPoolExecutor
Costs Introduced by Threads
Programming .Net Windows Applications
Dialog Boxes
Apply Button
PictureBox
ListControls
Binding Data
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies