 |
 |
****************************************************************
* Description: Oracle OCA 12c & 11g exam overview introduction.
* Compatiablity: RDBMS 11g, 12c
* Date: 11:46 AM EST, 03/09/2017
****************************************************************
1) OCA stands for "Oracle Certification Associate"
2) OCA pass path:
|
|__ Step 1: Pass one
| |
| |__ Oracle Database 12c - 1Z0-071 - SQL ...................... $245, 100 minutes, 73 multiple choice questions pass above 63%, on-sited, proctored
| Oracle Database 11g - 1Z0-047 - SQL Expert ............... $245, 090 minutes, 60 multiple choice questions pass above 66%, on-sited, proctored
| Oracle Database 11g - 1Z0-051 - SQL Fundamentals ......... $125, 120 minutes, 64 multiple choice questions pass above 60%, web base, non-proctor
| Oracle Database 12c - 1Z0-061 - SQL Fundamentals ......... $125, 120 minutes, 75 multiple choice questions pass above 65%, web base, non-proctor
|
|__ Step 2: Pass below
|
|__ Oracle Database 11g - 1Z0-052 - Administration I ......... $245, 090 minutes, 70 multiple choice questions pass above 66%, on-sited, proctored
3) OCA Exam Topics - 1Z0-061:
|
|__ Introduction:
| o. Describe the features of Oracle Database 12c
| o. Describe the salient features of Oracle Cloud 12c
| o. Explain the theoretical and physical aspects of a relational database
| o. Describe Oracle server’s implementation of RDBMS and object relational database management system (ORDBMS)
|
|__ Retrieving Data using the SQL SELECT Statement:
| o. Explain the capabilities of SQL SELECT statements
| o. Execute a basic SELECT statement
|
|__ Restricting and Sorting Data:
| o. Limit the rows that are retrieved by a query
| o. Sort the rows that are retrieved by a query
| o. Use ampersand substitution to restrict and sort output at
|
|__ Using Single-Row Functions to Customize Output:
| o. Describe various types of functions available in SQL
| o. Use character, number, and date functions in SELECT statements
|
|__ Using Conversion Functions and Conditional Expressions:
| o. Describe various types of conversion functions that are available in SQL
| o. Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
| o. Apply conditional expressions in a SELECT statement
|
|__ Reporting Aggregated Data Using the Group Functions:
| o. Identify the available group functions
| o. Describe the use of group functions
| o. Group data by using the GROUP BY clause
| o. Include or exclude grouped rows by using the HAVING clause
|
|__ Displaying Data From Multiple Tables Using Joins:
| o. Write SELECT statements to access data from more than one table using equijoins and nonequijoins
| o. Join a table to itself by using a self-join
| o. View data that generally does not meet a join condition by using OUTER joins
| o. Generate a Cartesian product of all rows from two or more tables
|
|__ Using Subqueries to Solve Queries:
| o. Define subqueries
| o. Describe the types of problems that the subqueries can solve
| o. Describe the types of subqueries
| o. Write single-row and multiple-row subqueries
| o. Using the SET Operators
| o. Describe set operators
| o. Use a set operator to combine multiple queries into a single query
| o. Control the order of rows returned
|
|__ Managing Tables using DML statements:
| o. Truncate data
| o. Insert rows into a table
| o. Update rows in a table
| o. Delete rows from a table
| o. Control transactions
|
|__ Introduction to Data Definition Language:
o. Categorize the main database objects
o. Explain the table structure
o. Describe the data types that are available for columns
o. Create a simple table
o. Explain how constraints are created at the time of table creation
o. Describe how schema objects work
4) OCA Exam Topics - 1Z0-052
|
|__ Exploring the Oracle Database Architecture:
| o. Explain the Memory Structures
| o. Describe the Process Structures
| o. Overview of Storage Structures
|
|__ Preparing the Database Environment:
| o. Identify the tools for Administering an Oracle Database
| o. Plan an Oracle Database installation
| o. Install the Oracle software by using Oracle Universal Installer (OUI)
|
|__ Creating an Oracle Database:
| o. Create a database by using the Database Configuration Assistant (DBCA)
|
|__ Managing the Oracle Instance:
| o. Setting database initialization parameters
| o. Describe the stages of database startup and shutdown
| o. Using alert log and trace files
| o. Using data dictionary and dynamic performance views
|
|__ Configuring the Oracle Network Environment:
| o. Configure and Manage the Oracle Network
| o. Using the Oracle Shared Server architecture
|
|__ Managing Database Storage Structures:
| o. Overview of tablespace and datafiles
| o. Create and manage tablespaces
| o. Space management in tablespaces
|
|__ Administering User Security:
| o. Create and manage database user accounts
| o. Grant and revoke privileges
| o. Create and manage roles
| o. Create and manage profiles
|
|__ Managing Data and Concurrency:
| o. Monitor and resolve locking conflicts
|
|__ Managing Undo Data:
| o. Overview of Undo
| o. Transactions and undo data
| o. Managing undo
|
|__ Implementing Oracle Database Security:
| o. Database Security and Principle of Least Privilege
| o. Work with Standard Database Auditing
|
|__ Database Maintenance:
| o. Use and manage optimizer statistics
| o. Use and manage Automatic Workload Repository (AWR)
| o. Use advisory framework
| o. Manage Alerts and Thresholds
|
|__ Performance Management:
| o. Use Automatic Memory Management
| o. Use Memory Advisors
| o. Troubleshoot invalid and unusable objects
|
|__ Intelligent Infrastructure Enhancements:
| o. Use the Enterprise Manager Support Workbench
| o. Managing Patches
|
|__ Backup and Recovery Concepts:
| o. Identify the types of failure that can occur in an Oracle database
| o. Describe ways to tune instance recovery
| o. Identify the importance of checkpoints, redo log files, and archived log files
| o. Overview of flash recovery area
| o. Configure ARCHIVELOG mode
|
|__ Performing Database Backups:
| o. Create consistent database backups
| o. Back up your database without shutting it down
| o. Create incremental backups
| o. Automate database backups
| o. Manage backups, view backup reports and monitor the flash recovery area
|
|__ Performing Database Recovery:
| o. Overview of Data Recovery Advisor
| o. Use Data Recovery Advisor to Perform recovery (Control file, Redo log file and Data file)
|
|__ Moving Data:
o.Describe and use methods to move data (Directory objects, SQL*Loader, External Tables)
o.Explain the general architecture of Oracle Data Pump
o.Use Data Pump Export and Import to move data between Oracle databases
4) OCA exam reference:
|
|__ http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=654&get_params=p_id:50
Your Comments