OCA/OCP Oracle Database 11g All-in-One Exam Guide with CD-ROM: Exams 1Z0-051, 1Z0-052, 1Z0-053 (Osborne ORACLE Press Series)

Contents......Page 16
Introduction......Page 36
Part I: Oracle Database 11g Administration......Page 46
Exam Objectives......Page 48
Oracle Product Stack......Page 49
Prerequisite Concepts......Page 56
Single-Instance Architecture......Page 58
Instance Memory Structures......Page 64
Instance Process Structures......Page 73
Database Storage Structures......Page 85
Two-Minute Drill......Page 94
Self Test......Page 95
Self Test Answers......Page 97
Exam Objectives......Page 100
Identify the Tools for Administering an Oracle Database......Page 101
Plan an Oracle Database Installation......Page 113
Install the Oracle Software by Using the Oracle Universal Installer (OUI)......Page 119
Create a Database by Using the Database Configuration Assistant......Page 122
Two-Minute Drill......Page 136
Self Test......Page 137
Self Test Answers......Page 141
Exam Objectives......Page 144
Set Database Initialization Parameters......Page 146
Describe the Stages of Database Startup and Shutdown......Page 153
Use the Alert Log and Trace Files......Page 166
Use Data Dictionary and Dynamic Performance Views......Page 168
Two-Minute Drill......Page 171
Self Test......Page 172
Self Test Answers......Page 175
Exam Objectives......Page 178
Configure and Manage the Oracle Network......Page 179
Use the Oracle Shared Server Architecture......Page 202
Two-Minute Drill......Page 210
Self Test......Page 211
Self Test Answers......Page 214
Exam Objectives......Page 216
Overview of Tablespaces and Datafiles......Page 217
Create and Manage Tablespaces......Page 225
Space Management in Tablespaces......Page 239
Two-Minute Drill......Page 242
Self Test......Page 243
Self Test Answers......Page 246
Exam Objectives......Page 248
Create and Manage Database User Accounts......Page 249
Grant and Revoke Privileges......Page 261
Create and Manage Roles......Page 268
Create and Manage Profiles......Page 274
Database Security and Principle of Least Privilege......Page 279
Work with Standard Database Auditing......Page 285
Two-Minute Drill......Page 293
Self Test......Page 294
Self Test Answers......Page 298
Part II: SQL......Page 302
Exam Objectives......Page 304
Categorize the Main Database Objects......Page 305
List the Data Types That Are Available for Columns......Page 308
Create a Simple Table......Page 311
Create and Use Temporary Tables......Page 318
Indexes......Page 320
Constraints......Page 328
Views......Page 335
Synonyms......Page 340
Sequences......Page 343
Two-Minute Drill......Page 348
Self Test......Page 350
Self Test Answers......Page 356
Exam Objectives......Page 360
Data Manipulation Language (DML) Statements......Page 361
Control Transactions......Page 375
Identify and Administer PL/SQL Objects......Page 385
Monitor and Resolve Locking Conflicts......Page 391
Overview of Undo......Page 396
Transactions and Undo Data......Page 397
Managing Undo......Page 399
Two-Minute Drill......Page 404
Self Test......Page 406
Self Test Answers......Page 410
Exam Objectives......Page 412
List the Capabilities of SQL SELECT Statements......Page 413
Create the Demonstration Schemas......Page 420
Execute a Basic SELECT Statement......Page 426
Limit the Rows Retrieved by a Query......Page 437
Sort the Rows Retrieved by a Query......Page 448
Ampersand Substitution......Page 450
Two-Minute Drill......Page 457
Self Test......Page 459
Self Test Answers......Page 461
Exam Objectives......Page 464
Describe and Use Character, Number, and Date Functions in SQL......Page 465
Describe Various Types of Conversion Functions Available in SQL......Page 479
Use the TO_CHAR, TO_NUMBER, and TO_DATE Conversion Functions......Page 481
Apply Conditional Expressions in a SELECT Statement......Page 489
Two-Minute Drill......Page 498
Self Test......Page 499
Self Test Answers......Page 502
Exam Objectives......Page 504
The Group Functions......Page 505
Group Data Using the GROUP BY Clause......Page 510
Include or Exclude Grouped Rows Using the HAVING Clause......Page 516
Two-Minute Drill......Page 520
Self Test......Page 521
Self Test Answers......Page 523
Exam Objectives......Page 526
Write SELECT Statements to Access Data from More Than One Table Using Equijoins and Nonequijoins......Page 527
Join a Table to Itself Using a Self-Join......Page 543
View Data That Does Not Meet a Join Condition by Using Outer Joins......Page 545
Generate a Cartesian Product of Two or More Tables......Page 550
Two-Minute Drill......Page 553
Self Test......Page 555
Self Test Answers......Page 557
Exam Objectives......Page 560
Define Subqueries......Page 561
Describe the Types of Problems That the Subqueries Can Solve......Page 562
List the Types of Subqueries......Page 565
Write Single-Row and Multiple-Row Subqueries......Page 569
Describe the Set Operators......Page 570
Use a Set Operator to Combine Multiple Queries into a Single Query......Page 574
Two-Minute Drill......Page 578
Self Test......Page 580
Self Test Answers......Page 584
Part III: Advanced Database Administration......Page 586
Exam Objectives......Page 588
Backup and Recovery Issues......Page 589
Categories of Failures......Page 591
Instance Recovery......Page 597
Preparing the Database for Recoverability......Page 603
The Flash Recovery Area......Page 612
Two-Minute Drill......Page 615
Self Test......Page 617
Self Test Answers......Page 620
Exam Objectives......Page 622
Backup Concepts and Terminology......Page 623
Using the RMAN BACKUP Command to Create Backups......Page 625
Configuring RMAN Defaults......Page 637
Managing and Monitoring RMAN Backups......Page 639
Two-Minute Drill......Page 644
Self Test......Page 647
Self Test Answers......Page 649
Exam Objectives......Page 652
The Data Recovery Advisor......Page 653
Database Restore and Recovery......Page 658
Complete Recovery from Data File Loss Using RMAN......Page 659
Incomplete Recovery......Page 665
Autobackup and Restore of the Controlfile......Page 668
Using Image Copies for Recovery......Page 672
Block Recovery......Page 674
Two-Minute Drill......Page 676
Self Test......Page 678
Self Test Answers......Page 682
Exam Objectives......Page 686
The Recovery Catalog......Page 687
Stored Scripts......Page 694
Using RMAN to Create Databases......Page 696
Tablespace Point-in-Time Recovery (TSPITR)......Page 699
RMAN Performance and Monitoring......Page 703
Two-Minute Drill......Page 712
Self Test......Page 716
Self Test Answers......Page 719
Exam Objectives......Page 722
User-Managed Database Backup......Page 723
Backup of the Password and Parameter Files......Page 727
Media Failure That Does Not Affect Datafiles......Page 728
Recovery from Loss of Datafiles......Page 733
User-Managed Incomplete Recovery......Page 736
Two-Minute Drill......Page 738
Self Test......Page 740
Self Test Answers......Page 742
Exam Objectives......Page 744
The Different Flashback Technologies......Page 745
Flashback Database......Page 749
Flashback Drop......Page 760
Flashback Query......Page 768
The Flashback Data Archive......Page 781
Two-Minute Drill......Page 784
Self Test......Page 785
Self Test Answers......Page 789
Exam Objectives......Page 792
The Purpose of a Logical Volume Manager......Page 793
The ASM Architecture......Page 796
Creating Raw Devices......Page 801
Creating, Starting, and Stopping an ASM Instance......Page 802
Creating ASM Disk Groups......Page 805
Creating and Using ASM Files......Page 807
ASM and RMAN......Page 808
The ASMCMD Utility......Page 810
Two-Minute Drill......Page 811
Self Test......Page 813
Self Test Answers......Page 816
Exam Objectives......Page 818
The Need for Resource Management......Page 819
The Resource Manager Architecture......Page 820
Resource Manager Plans......Page 826
Automatic Consumer Group Switching......Page 839
Adaptive Consumer Group Mapping......Page 840
Two-Minute Drill......Page 844
Self Test......Page 845
Self Test Answers......Page 848
Exam Objectives......Page 850
The Scheduler Architecture......Page 851
Scheduler Objects......Page 852
Creating and Scheduling Jobs......Page 858
Using Classes, Windows, and the Resource Manager......Page 867
Two-Minute Drill......Page 871
Self Test......Page 872
Self Test Answers......Page 874
Exam Objectives......Page 876
SQL* Loader......Page 877
External Tables......Page 879
Data Pump......Page 883
Using Data Pump Export and Import......Page 886
Resumable Space Allocation......Page 895
Segment Reorganization......Page 897
Two-Minute Drill......Page 904
Self Test......Page 906
Self Test Answers......Page 908
Exam Objectives......Page 910
The Automatic Workload Repository......Page 911
The Database Advisory Framework......Page 916
Using the Server-Generated Alert System......Page 925
Two-Minute Drill......Page 931
Self Test......Page 932
Self Test Answers......Page 934
Exam Objectives......Page 936
Managing Memory......Page 937
The SQL Tuning Advisor......Page 945
The SQL Access Advisor......Page 955
Identifying and Fixing Invalid and Unusable Objects......Page 961
Database Replay......Page 966
Two-Minute Drill......Page 972
Self Test......Page 975
Self Test Answers......Page 978
Exam Objectives......Page 982
Globalization Requirements and Capabilities......Page 983
Using Globalization Support Features......Page 989
Languages and Time Zones......Page 997
Two-Minute Drill......Page 1002
Self Test......Page 1003
Self Test Answers......Page 1006
Exam Objectives......Page 1010
The Enterprise Manager Support Workbench......Page 1011
Patches......Page 1016
Two-Minute Drill......Page 1023
Self Test......Page 1024
Self Test Answers......Page 1025
Appendix About the CD......Page 1028
Help......Page 1029
LearnKey Technical Support......Page 1030
A......Page 1032
B......Page 1033
C......Page 1034
D......Page 1035
F......Page 1037
I......Page 1038
L......Page 1039
M......Page 1040
N......Page 1041
O......Page 1042
R......Page 1043
S......Page 1044
T......Page 1045
X......Page 1046
A......Page 1048
C......Page 1050
D......Page 1052
E......Page 1055
F......Page 1057
I......Page 1058
J......Page 1059
M......Page 1060
N......Page 1061
O......Page 1062
P......Page 1063
R......Page 1064
S......Page 1067
T......Page 1071
U......Page 1072
W......Page 1073