Test Bank for Oracle 10g Database Administrator Implementation and Administration 2nd Edition by Gavin Powell

Oracle 10g: Database Administrator: Implementation and Administration (DBA1) uses the most current database release from Oracle to provide thorough coverage of an Oracle database through the day-to-day duties of a database administrator. This real-world approach, combined with topics ranging from initialization parameters and table space storage to data integrity, constraints, and user profiles, provides good preparation for the update Oracle certification exam, Database Fundamentals I (#1Z0-041). In addition to extensive review material, the end of chapter content also includes comprehensive coverage of the exam objectives and exam-like practice questions.

Preface		xiii
Oracle Architecture Overview		1	(34)
Introduction to Oracle 10g Architecture		2	(8)
Key Components of the Oracle 10g		2	(3)
Running the Database		5	(4)
Some Optional Additions to Oracle 10g		9	(1)
Introduction to ORACLASS Database		10	(1)
Overview of Oracle 10g Installation Options		11	(4)
Comparing Server-Side Installation Options		12	(2)
Comparing Client-Side Installation Options		14	(1)
The Oracle Universal Installer		15	(3)
Oracle Home		16	(2)
Description of Optimal Flexible Architecture (OFA)		18	(3)
Directory Structure Standards		18	(2)
File Naming Standards		20	(1)
Installing Oracle Software		21	(8)
Chapter Summary		29	(1)
Review Questions		30	(1)
Exam Review Questions—Oracle Database 10g: Administration (#1Z0-042)		31	(2)
Hands-on Assignments		33	(1)
Case Project		33	(2)
Tools and Architecture		35	(52)
Overview of DBA Tools		36	(3)
Configuring Oracle Net Services to Connect to the Database		39	(17)
Overview of Oracle Net Services Architecture		39	(3)
Network Naming Methods		42	(1)
Step-By-Step Configuration of Oracle Net Services Using Net Manager		43	(6)
TNS Configuration Files		49	(1)
Working with the Listener		50	(2)
Using the Net Configuration Assistant		52	(1)
Using SQL *Plus, SQL *Plus Worksheet, and iSQL *Plus		52	(4)
Oracle Instance Architecture		56	(7)
Shared and Dedicated Server Processes		56	(3)
Background Processes		59	(2)
Memory Components		61	(2)
Introducing Enterprise Manager		63	(17)
Running the Enterprise Manager Console		64	(2)
Viewing the Features of Enterprise Manager		66	(10)
The Database Control Interface		76	(4)
Chapter Summary		80	(1)
Review Questions		81	(1)
Exam Review Questions—Oracle Database 10g Administration (#1Z0-042)		82	(2)
Hands-on Assignments		84	(2)
Case Project		86	(1)
Creating an Oracle Instance		87	(50)
Steps for Creating a Database		88	(1)
Overview of Prerequisites for Creating a Database		89	(1)
Choosing Configuration		90	(14)
Database Type		91	(1)
Database Management Tool		92	(1)
DBA Authentication Methods		92	(4)
Storage Management Methods		96	(1)
File Management Methods		97	(3)
Set the Initialization Parameters		100	(4)
Creating a Database		104	(18)
Create a New Database Using the Database Configuration Assistant		105	(13)
Creating a Database Manually		118	(4)
Starting and Stopping the Instance and Database		122	(3)
Managing Text and Binary (Server) Parameter Files		125	(1)
The Alert Log and Trace Files		126	(2)
Expanding OFA Just a Little More		126	(2)
Chapter Summary		128	(2)
Review Questions		130	(1)
Exam Review Questions—Oracle Database 10g: Administration (#1Z0-042)		131	(2)
Hands-on Assignments		133	(2)
Case Project		135	(2)
Oracle Physical Architecture and Data Dictionary Views		137	(62)
Tablespaces and Datafiles		138	(3)
Advanced Database Architectures		141	(4)
Oracle Managed Files (OMF)		142	(1)
Partitioning		142	(1)
Replication		142	(1)
Standby (Failover) Databases		143	(1)
Grid Computing, Oracle RAC and ASM		144	(1)
The Control File		145	(10)
Managing and Multiplexing the Control Files		146	(4)
Using OMF to Manage Control Files		150	(1)
Creating a New Control File		151	(3)
Viewing Control File Data		154	(1)
Online Redo Log Files and Archive Log Files		155	(21)
The Purpose of Redo Log Files		158	(1)
The Structure of Redo Log Files		159	(1)
Introducing Redo Log File Management		160	(1)
Log Switches and Checkpoints		161	(2)
Duplexing and Other Maintenance		163	(10)
Using OMF to Manage Online Redo Log Files		173	(2)
Viewing Redo Log Information		175	(1)
The Data Dictionary		176	(11)
Looking at Data Dictionary Components		176	(3)
Using Data Dictionary Views		179	(6)
Useful Dynamic Performance Views		185	(1)
Examining Table Structure Using SQL *Plus and iSQL *Plus		186	(1)
Chapter Summary		187	(2)
Review Questions		189	(1)
Exam Review Questions—Oracle Database 10g: Administration (#1Z0-042)		190	(5)
Hands-on Assignments		195	(2)
Case Projects		197	(2)
Basic Storage Concepts and Settings		199	(52)
Introduction to Storage Structures		200	(22)
Logical Structure Versus Physical Structure		200	(5)
Tablespaces and Datafiles		205	(11)
Segment Types and Their Uses		216	(2)
Temporary Tablespace		218	(2)
Tablespaces with Nonstandard Data Block Size		220	(2)
Configuring and Viewing Storage		222	(9)
Changing the Size, Storage Settings, and Status		222	(7)
Querying the Data Dictionary for Storage Data		229	(2)
Overview of Undo Data		231	(8)
Implementing Automatic Undo Management		232	(3)
Monitoring Undo		235	(4)
Overview of Diagnostic (Trace) Files		239	(5)
Chapter Summary		244	(1)
Review Questions		245	(1)
Exam Review Questions—Oracle Database 10g: Administration (#1Z0-042)		246	(1)
Hands-on Assignments		247	(2)
Case Projects		249	(2)
The Basics of Querying a Database		251	(40)
Introduction to Queries		252	(10)
Different Types of Queries		252	(3)
Oracle SQL Functions and Pseudocolumns		255	(2)
What is NULL?		257	(2)
The DUAL Table and More on Pseudocolumns		259	(2)
The DISTINCT Clause		261	(1)
The SELECT Statement		262	(3)
Filtering, Sorting, and Summarizing (Aggregations) Queries		265	(8)
Filtering Queries with the WHERE Clause		265	(4)
Sorting Queries with the ORDER BY Clause		269	(2)
Aggregating Queries with the GROUP BY Clause		271	(2)
Advanced Queries		273	(13)
Joins		273	(5)
Subqueries		278	(2)
Other Specialized Queries		280	(6)
Chapter Summary		286	(2)
Review Questions		288	(1)
Exam Review Questions—Oracle Database 10g: Administration (#1Z0-042)		288	(1)
Hands-on Assignments		288	(1)
Case Project		289	(2)
Basic Table Management		291	(66)
Introduction to Table Structures		293	(13)
Setting Block Space Usage		295	(4)
Storage Methods		299	(3)
Row Structure and the ROWID		302	(4)
Creating Tables		306	(26)
Columns and Datatypes		307	(5)
Creating Relational Tables		312	(5)
Creating Temporary Tables		317	(3)
Creating VARRAYs and Nested Tables		320	(5)
Creating Object Tables		325	(2)
Creating Partitioned Tables		327	(5)
Viewing Database Object Attributes		332	(14)
Viewing Object Metadata in SQL *Plus		332	(4)
Viewing Object Metadata in the Console		336	(1)
Viewing Object Metadata in the Database Control		337	(9)
Chapter Summary		346	(2)
Review Questions		348	(2)
Exam Review Questions—Oracle Database 10g: Administration (#1Z0-042)		350	(2)
Hands-on Assignments		352	(3)
Case Project		355	(2)
Advanced Table Management		357	(38)
Advanced Table Structures		358	(9)
Tables with LOB Columns		358	(2)
LOB Storage		360	(4)
Index-Organized Tables		364	(3)
Overview of Table Management		367	(16)
Analyzing a Table		368	(2)
Adjusting Table Storage Structure		370	(3)
Redefining Tables Online		373	(4)
Dropping, Adding, or Modifying a Column in a Table		377	(3)
Truncating and Dropping a Table		380	(3)
Making Other More Specialized Table Changes		383	(2)
Table Flashback Recovery		383	(1)
Transparent Table Encryption		384	(1)
Querying Data Dictionary Views for Tables and Other Objects		385	(2)
Chapter Summary		387	(1)
Review Questions		388	(1)
Exam Review Questions—Oracle Database 10g: Administration (#1Z0-042)		389	(2)
Hands-on Assignments		391	(2)
Case Project		393	(2)
Constraints, Indexes, and Other Specialized Objects		395	(70)
What are Constraints?		396	(22)
Types of Integrity Constraints		397	(2)
How To Create and Maintain Integrity Constraints		399	(6)
Working with Constraints		405	(11)
Data Dictionary Information on Constraints		416	(2)
What are Indexes?		418	(27)
Types and Uses of Indexes		421	(17)
Managing Indexes		438	(3)
Data Dictionary Information on Indexes		441	(4)
Other Specialized Database Objects		445	(6)
Views		445	(3)
Sequences		448	(1)
Synonyms		449	(1)
Data Dictionary Information on Views, Sequences, and Synonyms		450	(1)
Chapter Summary		451	(2)
Review Questions		453	(2)
Exam Review Questions—Oracle Database 10g: Administration (#1Z0-042)		455	(5)
Hands-on Assignments		460	(3)
Case Projects		463	(2)
Basic Data Management		465	(20)
Introduction to Basic Data Management		465	(6)
What are DML and DDL?		467	(1)
What is a Transaction?		468	(3)
Using DML Statements		471	(5)
The INSERT Statement (Adding New Data)		471	(4)
The UPDATE Statement (Changing Existing Data)		475	(1)
The DELETE Statement (Delete Existing Data)		476	(1)
Controlling Transactions		476	(3)
The COMMIT Statement		477	(1)
The ROLLBACK Statement		477	(1)
The SAVEPOINT Statement		477	(1)
SET TRANSACTION Statement		477	(1)
The LOCK TABLE Statement		478	(1)
Directory Objects		479	(3)
Chapter Summary		482	(1)
Review Questions		482	(1)
Exam Review Questions—Oracle Database 10g: Administration (#1Z0-042)		483	(1)
Hands-on Assignments		484	(1)
Case Project		484	(1)
Advanced Data Management		485	(30)
Introduction to Advanced Data Management		486	(1)
Coding SQL into Programs with PL/SQL		487	(15)
Blocks, Exception Trapping, and Anonymous Blocks		487	(3)
Named Blocks and Packages		490	(5)
Triggers and Events Firing Triggers		495	(1)
PL/SQL Variables and Datatypes		496	(1)
What Is a Cursor?		497	(2)
PL/SQL Programming Control Structures		499	(3)
Bulk Imports and Exports Using Data Pump		502	(3)
Exporting Using Data Pump		503	(1)
Importing Using Data Pump		504	(1)
Bulk Data Loads with SQL *Loader		505	(7)
Direct Versus Conventional Path Loads		505	(2)
SQL Loader Input Data Files		507	(1)
The SQL Loader Control File		507	(3)
The Parameter File		510	(2)
Chapter Summary		512	(1)
Review Questions		512	(1)
Exam Review Questions—Oracle Database 10g: Administration (#1Z0-042)		513	(1)
Hands-on Assignments		514	(1)
Case Project		514	(1)
Security Management		515	(86)
Users and Resource Control		516	(10)
Creating New Users		517	(5)
Modifying User Settings with the ALTER USER Statement		522	(2)
Removing Users		524	(2)
Introduction to Profiles		526	(11)
Creating Profiles		527	(2)
Managing Passwords		529	(6)
Controlling Resource Usage		535	(2)
Dropping a Profile		537	(1)
Obtaining User, Profile, Password, and Resource Data		537	(7)
System and Object Privileges		544	(3)
Identifying System Privileges		544	(2)
Using Object Privileges		546	(1)
Managing System and Object Privileges		547	(12)
Granting and Revoking System Privileges		547	(5)
Granting and Revoking Object Privileges		552	(7)
Description of Auditing Capabilities		559	(7)
Database Roles		566	(5)
How to Use Roles		566	(2)
Using Predefined Roles		568	(3)
Creating and Modifying Roles		571	(8)
Creating and Assigning Privileges to a Role		572	(1)
Assigning Roles to Users and to Other Roles		572	(4)
Limiting Availability and Removing Roles		576	(3)
Data Dictionary Information about Roles		579	(1)
Roles in the Enterprise Manager Console		580	(6)
Chapter Summary		586	(1)
Review Questions		587	(3)
Exam Review Questions—Oracle Database 10g: Administration (#1Z0-042)		590	(8)
Hands-on Assignments		598	(1)
Case Project		599	(2)
Performance Monitoring		601	(34)
Introduction to Performance Monitoring		603	(2)
Different Tools for Performance Monitoring		603	(2)
Statistics		605	(12)
The Importance of Statistics		605	(1)
Gathering Statistics Manually		606	(2)
Automated Statistics Gathering		608	(9)
Performance Metrics		617	(3)
Changing Performance Metric Parameters		619	(1)
Searching for Invalidated Objects		620	(1)
Lock Conflicts		621	(10)
How to Detect Lock Conflicts		622	(4)
Resolving Lock Conflicts		626	(4)
What is a Deadlock?		630	(1)
Chapter Summary		631	(1)
Review Questions		631	(2)
Exam Review Questions—Oracle Database 10g: Administration (#1Z1-042)		633	(1)
Hands-on Assignments		633	(1)
Case Projects		634	(1)
Proactive Maintenance		635	(42)
What is Proactive Maintenance?		636	(1)
Advice Performance Tools		636	(28)
The Different Tuning and Diagnostic Advisors		639	(25)
Baseline Metrics		664	(9)
What are Baseline Metrics?		665	(6)
Changing Baseline Metrics		671	(2)
Chapter Summary		673
Review Questions		373	(301)
Exam Review Questions—Oracle Database 10g: Administration (#1Z1-042)		674	(1)
Hands-on Assignments		675	(1)
Case Project		675	(2)
Backup and Recovery		677	(32)
Introduction to Backup and Recovery		678	(14)
What is Backup?		678	(1)
What is Restoration?		678	(2)
What is Recovery?		680	(1)
Methods of Backup and Recovery		681	(1)
Tools for Backup and Recovery		682	(1)
Types of Failure		683	(1)
Backup Strategy		684	(8)
Configuring a Database for Possible Recovery		692	(3)
Setting the Database in Archive Log Mode		692	(2)
Checkpoints, Redo Logs, Archive Logs, and Fast Starts		694	(1)
Sacrificing Recoverability for Performance		695	(1)
Flash Recovery and Backups		695	(5)
The MTTR (Mean Time To Recovery) Advisor		696	(4)
Database Backup		700	(4)
Cold Backups		700	(1)
Hot Backups		701	(3)
Database Recovery		704	(2)
Chapter Summary		706	(1)
Review Questions		706	(1)
Exam Review Questions—Oracle Database 10g: Administration (#1Z1-042)		707	(1)
Hands-on Assignments		708	(1)
Case Project		708	(1)
Appendix A		709	(4)
Glossary		713	(14)
Index		727