* 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