OCA: Oracle Database 12c Administrator Certified Associate Study Guide (eBook)

Exams 1Z0-061 and 1Z0-062

Biju Thomas (Autor)

eBook Download: PDF

2014
John Wiley & Sons (Verlag)
978-1-118-76325-4 (ISBN)

Infos

An all-in-one study guide prepares you for the updated Oracle Certified Associate certification

It's been nearly six years since Oracle updated its cornerstone database software, making the demand for a comprehensive study guide for the OCA 12c certification a top priority. This resource answers that demand. Packed with invaluable insight, chapter review questions, bonus practice exams, hundreds of electronic flashcards, and a searchable glossary of terms, this study guide prepares you for the challenging Oracle certification exams.

• Provides you with a solid understanding of restricting and sorting data
• Walks you through using conversion functions and conditional expressions
• Addresses displaying data from multiple tables, manipulating data, database maintenance, and database backups and recovery
• Explores the Oracle database architecture and discusses preparing the database environment, creating an Oracle database, and managing the Oracle instance
• Focuses on administering and implementing user security

This must-have study guide thoroughly prepares you to take the dramatically updated Oracle 12c OCA exams.

Autor

Biju Thomas OCA, OCP, is a Senior Oracle Solutions Architect with more than 20 years of Oracle development and database management experience. He has strong skills in database design and administration, performance tuning, and solution architecture. He has coauthored six Oracle Sybex certification books.

Inhalt

Contents 11
Introduction 22
Assessment Test 37
Answers to Assessment Test 57
Part I: Oracle Database 12c: SQL Fundamentals 65
Chapter 1: Introducing Oracle Database 12c RDBMS 67
Relational Database Management Systems 68
The Oracle Database 12c 73
Becoming Familiar with SQL*Plus 83
Summary 94
Exam Essentials 95
Review Questions 96
Chapter 2: Introducing SQL 99
SQL Fundamentals 100
Writing Simple Queries 110
Accepting Values at Runtime 136
Summary 142
Exam Essentials 142
Review Questions 144
Chapter 3: Using Single-Row Functions 153
Single-Row Function Fundamentals 154
Using Single-Row Character Functions 159
Using Single-Row Numeric Functions 172
Using Single-Row Date Functions 183
Using Single-Row Conversion Functions 195
Using Other Single-Row Functions 218
Summary 231
Exam Essentials 232
Review Questions 233
Chapter 4: Using Group Functions 239
Group Function Fundamentals 240
Utilizing Aggregate Functions 241
Summary 282
Exam Essentials 282
Review Questions 283
Chapter 5: Using Joins and Subqueries 291
Writing Multiple-Table Queries 292
Using Set Operators 311
Using Subqueries 316
Summary 333
Exam Essentials 334
Review Questions 335
Chapter 6: Manipulating Data 345
Using DML Statements 346
Understanding Transaction Control 363
Summary 370
Exam Essentials 371
Review Questions 372
Chapter 7: Creating Tables and Constraints 383
Database Objects Overview 384
Built-in Datatypes 389
Creating Tables 402
Modifying Tables 414
Managing Constraints 425
Summary 437
Exam Essentials 438
Review Questions 439
Part II: Oracle Database 12c: Installation and Administration 445
Chapter 8: Introducing Oracle Database 12c Components and Architecture 447
Oracle Database Fundamentals 449
Oracle Database 12c Architecture 455
Summary 488
Exam Essentials 489
Review Questions 490
Chapter 9: Creating and Operating Oracle Database 12c 495
Oracle Database 12c Software Installation 496
Using DBCA to Create an Oracle 12c Database 511
Working with Oracle Database Metadata 539
Managing Initialization-Parameter Files 543
Starting Up and Shutting Down an Oracle Instance 554
Monitoring the Database Alert Log 561
Summary 567
Exam Essentials 568
Review Questions 570
Chapter 10: Understanding Storage and Space Management 575
Understanding the Physical and Logical Storage 576
Managing Tablespaces 580
Managing Data Files 598
Managing Space 611
Summary 626
Exam Essentials 627
Review Questions 629
Chapter 11: Managing Data Concurrency 633
Managing Data Changes Using DML 634
Managing Data Concurrency 648
Summary 659
Exam Essentials 659
Review Questions 661
Chapter 12: Understanding Oracle Network Architecture 667
Introducing Network Configurations 668
An Overview of Oracle Net Features 671
Configuring Oracle Net on the Server 677
Configuring Oracle Net for the Client 701
An Overview of Oracle Shared Server 712
Understanding Database Resident Connection Pooling 725
Communicating Between Databases 730
Summary 733
Exam Essentials 734
Review Questions 736
Chapter 13: Implementing Security and Auditing 741
Creating and Managing User Accounts 742
Granting and Revoking Privileges 751
Controlling Resource Usage by Users 775
Auditing Database Activity 782
Summary 809
Exam Essentials 810
Review Questions 812
Chapter 14: Maintaining the Database and Managing Performance 817
Proactive Database Maintenance 818
Managing Performance 870
Summary 883
Exam Essentials 884
Review Questions 885
Chapter 15: Using Backup and Recovery 889
Understanding and Configuring Recovery Components 891
Performing Backups 912
Understanding Types of Database Failures 928
Performing Recovery Operations 932
Summary 958
Exam Essentials 959
Review Questions 961
Chapter 16: Controlling Resources and Jobs 967
Resource Management with the Resource Manager 968
Task Automation with Oracle Scheduler 994
Summary 1015
Exam Essentials 1015
Review Questions 1016
Chapter 17: Upgrading to Oracle Database 12c 1021
Determining the DatabaseUpgrade Method 1022
Preparing for a Database Upgrade 1027
Upgrading the Database 1040
Summary 1061
Exam Essentials 1061
Review Questions 1063
Chapter 18: Using Grid Infrastructure and Data Movement Tools 1069
Tools for Moving Data 1070
Migrating Data Using Data Pump 1072
Loading Data with SQL*Loader 1103
Populating External Tables 1110
Introducing Grid Infrastructure 1114
Summary 1140
Exam Essentials 1141
Review Questions 1142
Appendix A: Answers to Review Questions 1147
Chapter 1: Introducing Oracle Database 12c RDBMS 1148
Chapter 2: Introducing SQL 1149
Chapter 3: Using Single-Row Functions 1151
Chapter 4: Using Group Functions 1153
Chapter 5: Using Joins and Subqueries 1154
Chapter 6: Manipulating Data 1156
Chapter 7: Creating Tables and Constraints 1158
Chapter 8: IntroducingOracle Database 12c Componentsand Architecture 1160
Chapter 9: Creating and Operating Oracle Database 12c 1162
Chapter 10: Understanding Storage and Space Management 1164
Chapter 11: Managing Data Concurrency and Undo 1166
Chapter 12: Understanding Oracle Network Architecture 1168
Chapter 13: ImplementingSecurity and Auditing 1170
Chapter 14: Maintaining the Database and Managing Performance 1172
Chapter 15: Using Backup and Recovery 1174
Chapter 16: ControllingResources and Jobs 1176
Chapter 17: Upgrading to Oracle Database 12c 1178
Chapter 18: Using Grid Infrastructure and Data Movement Tools 1180
Appendix B: About the Additional Study Tools 1183
Additional Study Tools 1184
System Requirements 1185
Using the Study Tools 1185
Troubleshooting 1185
Index 1187
Free Online Study Tools 1226

Produkt-Details

• Erscheint lt. Verlag: 8.4.2014
• Sprache: englisch
• Themenwelt: Informatik ► Datenbanken ► Oracle
• Themenwelt: Informatik ► Office Programme ► Outlook
• Themenwelt: Informatik ► Weitere Themen ► Zertifizierung
• Schlagworte: 1z0-061 exam • 1z0-062 exam • book on taking the oracle 12c certification exam • book on taking the oracle 12c exam • books on taking the oracle 12c certification exam • books on taking the oracle 12c exam • Computer-Ratgeber • Database software (Non-Microsoft) • Datenbanken (außer Microsoft) • Datenbanken (außer Microsoft) • End-User Computing • exam 1z0-061 • oracle 12c certification prep • oracle 12c certification preparation • oracle 12c exam prep • oracle 12c exam preparation • oracle 12c practice exam • oracle 12c practice exams • oracle 12c practice test • oracle 12c practice tests • oracle 12c review questions • oracle 12c study guide • Oracle Database • oracle database study guide • Oracle exam • prepare to take oracle 12c certification • prepare to take the oracle 12c exam • preparing to take the 1z0-061 exam • preparing to take the 1z0-062 exam • review questions for oracle 12c • study guide on oracle 12c • taking the 1z0-061 • taking the 1z0-062 • taking the oracle 12c certification • taking the oracle 12c exam
• ISBN-10: 1-118-76325-4 / 1118763254
• ISBN-13: 978-1-118-76325-4 / 9781118763254