OCA: Oracle Database 12c Administrator Certified Associate Study Guide E-Book

Biju Thomas

• Herausgeber: John Wiley & Sons
• Kategorie: Wissenschaft und neue Technologien
• Sprache: Englisch

Seitenzahl: 1582

Veröffentlichungsjahr: 2014

Beschreibung

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.

Leseprobe

CONTENTS

Titlepage

Dedication

Acknowledgments

About the Author

About the Contributor

About the Technical Reviewers

Introduction

Exam Objectives

Assessment Test

Exam 1Z0-061: SQL Fundamentals

Exam 1Z0-062: Installation and Administration

Answers to Assessment Test

Exam 1Z0-061: SQL Fundamentals

Exam 1Z0-062: Installation and Administration

Part I: Oracle Database 12c: SQL Fundamentals

Chapter 1: Introducing Oracle Database 12c RDBMS

Relational Database Management Systems

The Oracle Database 12c

Becoming Familiar with SQL*Plus

Summary

Chapter 2: Introducing SQL

SQL Fundamentals

Writing Simple Queries

Accepting Values at Runtime

Summary

Exam Essentials

Review Questions

Chapter 3: Using Single-Row Functions

Single-Row Function Fundamentals

Using Single-Row Character Functions

Using Single-Row Numeric Functions

Using Single-Row Date Functions

Using Single-Row Conversion Functions

Using Other Single-Row Functions

Summary

Exam Essentials

Review Questions

Chapter 4: Using Group Functions

Group Function Fundamentals

Utilizing Aggregate Functions

Summary

Exam Essentials

Review Questions

Chapter 5: Using Joins and Subqueries

Writing Multiple-Table Queries

Using Set Operators

Using Subqueries

Summary

Exam Essentials

Review Questions

Chapter 6: Manipulating Data

Using DML Statements

Understanding Transaction Control

Summary

Exam Essentials

Review Questions

Chapter 7: Creating Tables and Constraints

Database Objects Overview

Built-in Datatypes

Creating Tables

Modifying Tables

Managing Constraints

Summary

Exam Essentials

Review Questions

Part II: Oracle Database 12c: Installation and Administration

Chapter 8: Introducing Oracle Database 12c Components and Architecture

Oracle Database Fundamentals

Oracle Database 12c Architecture

Summary

Exam Essentials

Review Questions

Chapter 9: Creating and Operating Oracle Database 12c

Oracle Database 12c Software Installation

Using DBCA to Create an Oracle 12c Database

Working with Oracle Database Metadata

Managing Initialization-Parameter Files

Starting Up and Shutting Down an Oracle Instance

Monitoring the Database Alert Log

Summary

Exam Essentials

Review Questions

Chapter 10: Understanding Storage and Space Management

Understanding the Physical and Logical Storage

Managing Tablespaces

Managing Data Files

Managing Space

Summary

Exam Essentials

Review Questions

Chapter 11: Managing Data Concurrency and Undo

Managing Data Changes Using DML

Managing Data Concurrency

Summary

Exam Essentials

Review Questions

Chapter 12: Understanding Oracle Network Architecture

Introducing Network Configurations

An Overview of Oracle Net Features

Configuring Oracle Net on the Server

Configuring Oracle Net for the Client

An Overview of Oracle Shared Server

Understanding Database Resident Connection Pooling

Communicating Between Databases

Summary

Exam Essentials

Review Questions

Chapter 13: Implementing Security and Auditing

Creating and Managing User Accounts

Granting and Revoking Privileges

Controlling Resource Usage by Users

Auditing Database Activity

Summary

Exam Essentials

Review Questions

Chapter 14: Maintaining the Database and Managing Performance

Proactive Database Maintenance

Managing Performance

Summary

Exam Essentials

Review Questions

Chapter 15: Using Backup and Recovery

Understanding and Configuring Recovery Components

Performing Backups

Understanding Types of Database Failures

Performing Recovery Operations

Summary

Exam Essentials

Review Questions

Chapter 16: Controlling Resources and Jobs

Resource Management with the Resource Manager

Task Automation with Oracle Scheduler

Summary

Exam Essentials

Review Questions

Chapter 17: Upgrading to Oracle Database 12c

Determining the Database Upgrade Method

Preparing for a Database Upgrade

Upgrading the Database

Summary

Exam Essentials

Review Questions

Chapter 18: Using Grid Infrastructure and Data Movement Tools

Tools for Moving Data

Migrating Data Using Data Pump

Loading Data with SQL*Loader

Populating External Tables

Introducing Grid Infrastructure

Summary

Exam Essentials

Review Questions

Appendix A: Answers to Review Questions

Chapter 1: Introducing Oracle Database 12c RDBMS

Chapter 2: Introducing SQL

Chapter 3: Using Single-Row Functions

Chapter 4: Using Group Functions

Chapter 5: Using Joins and Subqueries

Chapter 6: Manipulating Data

Chapter 7: Creating Tables and Constraints

Chapter 8: Introducing Oracle Database 12c Components and Architecture

Chapter 9: Creating and Operating Oracle Database 12c

Chapter 10: Understanding Storage and Space Management

Chapter 11: Managing Data Concurrency and Undo

Chapter 12: Understanding Oracle Network Architecture

Chapter 13: Implementing Security and Auditing

Chapter 14: Maintaining the Database and Managing Performance

Chapter 15: Using Backup and Recovery

Chapter 16: Controlling Resources and Jobs

Chapter 17: Upgrading to Oracle Database 12c

Chapter 18: Using Grid Infrastructure and Data Movement Tools

Appendix B: About the Additional Study Tools

Additional Study Tools

System Requirements

Using the Study Tools

Troubleshooting

Free Online Study Tools

End-User License Agreement

List of Tables

Table 2-1

Table 2-2

Table 2-3

Table 2-4

Table 2-5

Table 2-6

Table 2-7

Table 2-8

Table 2-9

Table 2-10

Table 3-1

Table 3-2

Table 3-3

Table 3-4

Table 3-5

Table 3-6

Table 3-7

Table 3-8

Table 3-9

Table 3-10

Table 3-11

Table 3-12

Table 3-13

Table 3-14

Table 4-1

Table 4-2

Table 4-3

Table 5-1

Table 5-2

Table 6-1

Table 6-2

Table 7-1

Table 7-2

Table 7-3

Table 8-1

Table 8-2

Table 8-3

Table 8-4

Table 8-5

Table 8-6

Table 8-7

Table 9-1

Table 9-2

Table 9-3

Table 9-4

Table 9-5

Table 9-6

Table 9-7

Table 9-8

Table 9-9

Table 9-10

Table 9-11

Table 9-12

Table 9-13

Table 9-14

Table 9-15

Table 9-16

Table 9-17

Table 11-1

Table 11-2

Table 11-3

Table 12-1

Table 12-2

Table 12-3

Table 12-4

Table 12-5

Table 12-6

Table 12-7

Table 12-8

Table 13-1

Table 13-2

Table 14-1

Table 14-2

Table 14-3

Table 14-4

Table 14-5

Table 14-6

Table 14-7

Table 14-8

Table 14-9

Table 15-1

Table 16-1

Table 16-2

Table 16-3

Table 16-4

Table 16-5

Table 16-6

Table 16-7

Table 16-8

Table 16-9

Table 16-10

Table 17-1

Table 18-1

Table 18-2

Table 18-3

Table 18-4

Table 18-5

List of Illustrations

Figure 1-1

Figure 1-2

Figure 1-3

Figure 1-4

Figure 1-5

Figure 1-6

Figure 1-7

Figure 1-8

Figure 1-9

Figure 1-10

Figure 1-11

Figure 6-1

Figure 7-1

Figure 7-2

Figure 8-1

Figure 8-2

Figure 8-3

Figure 8-4

Figure 8-5

Figure 8-6

Figure 8-7

Figure 8-8

Figure 8-9

Figure 8-10

Figure 8-11

Figure 8-12

Figure 8-13

Figure 8-14

Figure 8-15

Figure 8-16

Figure 8-17

Figure 9-1

Figure 9-2

Figure 9-3

Figure 9-4

Figure 9-5

Figure 9-6

Figure 9-7

Figure 9-8

Figure 9-9

Figure 9-10

Figure 9-11

Figure 9-12

Figure 9-13

Figure 9-14

Figure 9-15

Figure 9-16

Figure 9-17

Figure 9-18

Figure 9-19

Figure 9-20

Figure 9-21

Figure 9-22

Figure 9-23

Figure 9-24

Figure 9-25

Figure 9-26

Figure 9-27

Figure 9-28

Figure 9-29

Figure 9-30

Figure 9-31

Figure 9-32

Figure 9-33

Figure 9-34

Figure 9-35

Figure 9-36

Figure 10-1

Figure 10-2

Figure 10-3

Figure 10-4

Figure 10-5

Figure 10-6

Figure 10-7

Figure 10-8

Figure 10-9

Figure 10-10

Figure 10-11

Figure 10-12

Figure 10-13

Figure 10-14

Figure 10-15

Figure 11-1

Figure 11-2

Figure 11-3

Figure 11-4

Figure 11-5

Figure 12-1

Figure 12-2

Figure 12-3

Figure 12-4

Figure 12-5

Figure 12-6

Figure 12-7

Figure 12-8

Figure 12-9

Figure 12-10

Figure 12-11

Figure 12-12

Figure 12-13

Figure 12-14

Figure 12-15

Figure 12-16

Figure 12-17

Figure 12-18

Figure 12-19

Figure 12-20

Figure 13-1

Figure 13-2

Figure 13-3

Figure 13-4

Figure 13-5

Figure 13-6

Figure 13-7

Figure 13-8

Figure 13-9

Figure 13-10

Figure 14-1

Figure 14-2

Figure 14-3

Figure 14-4

Figure 14-5

Figure 14-6

Figure 14-7

Figure 14-8

Figure 14-9

Figure 14-10

Figure 14-11

Figure 14-12

Figure 14-13

Figure 14-14

Figure 14-15

Figure 14-16

Figure 14-17

Figure 14-18

Figure 14-19

Figure 14-20

Figure 14-21

Figure 14-22

Figure 14-23

Figure 14-24

Figure 14-25

Figure 14-26

Figure 14-27

Figure 14-28

Figure 14-29

Figure 14-30

Figure 14-31

Figure 14-32

Figure 15-1

Figure 15-2

Figure 15-3

Figure 15-4

Figure 15-5

Figure 15-6

Figure 15-7

Figure 15-8

Figure 15-9

Figure 15-10

Figure 15-11

Figure 15-12

Figure 15-13

Figure 15-14

Figure 15-15

Figure 15-16

Figure 15-17

Figure 15-18

Figure 15-19

Figure 15-20

Figure 16-1

Figure 16-2

Figure 16-3

Figure 16-4

Figure 16-5

Figure 16-6

Figure 16-7

Figure 16-8

Figure 16-9

Figure 16-10

Figure 16-11

Figure 16-12

Figure 16-13

Figure 16-14

Figure 17-1

Figure 17-2

Figure 17-3