Results 1 to 12 of 12

Thread: OCA Certification

  1. #1

    OCA Certification


    i want to apply for OCA certification programme but i don't know the details
    how to apply for that ,can any one tell me how to apply for OCA certification programme.Also provide me the dumps for that.

    Is that neccessary to do OCA before doing OCP.....??
    Please assist me for this.


  2. #2
    Contributing Member
    Join Date
    Jan 2009

    Re: OCA Certification

    >I want to apply for OCA certification programme but i don't know the details
    You just need to go to any of the Oracle prometric centre or Oracle Corporation and register for exam.

    >Is that neccessary to do OCA before doing OCP.....??
    Its not necessary. You can take exams in any order. But you will be certified as OCP only after completing OCA.

    Regarding Certification:-
    Oracle University Select Country


  3. #3
    Junior Member
    Join Date
    Aug 2008

    Re: OCA Certification

    can any body provide me the OCA and OCP syllabus or regarding help?

  4. #4
    Junior Member
    Join Date
    Feb 2009

    Re: OCA Certification

    First it depends which oca certification you are interested in. All the syllabus and requirements are provided on the website: oracle university select country i have registered for my first oca exam (1z0-001 intro to oracle. Sql & pl/sql) and will be taking the exam next week. The syllabus for 1z0-001 is as below: creating and managing tables
    [ ] describe the main database objects
    [ ] create tables
    [ ] describe the datatypes that can be used when specifying column definition
    [ ] alter table definitions
    [ ] drop, rename, and truncate tables including constraints
    [ ] describe constraints
    [ ] create and maintain constraints create and maintain constraints
    [ ] describe a view
    [ ] create a view
    [ ] retrieve data through a view
    [ ] insert, update, and delete data through a view
    [ ] drop a view oracle data dictionary
    [ ] describe the data dictionary views a user may access
    [ ] query data from the data dictionary writing control structures
    [ ] identify the uses and types of control structures
    [ ] construct an if statement
    [ ] construct and identify different loop statements
    [ ] use logic tables
    [ ] control block flow using nested loops and labels working with composite datatypes
    [ ] create user-defined pl/sql records
    [ ] create a record with the % rowtype attribute
    [ ] create a pl/sql table
    [ ] create a pl/sql table of records
    [ ] describe the difference between records, tables, and tables of records overview of relational databases, sql, and pl/sql
    [ ] discuss the theoretical and physical aspects of a relational database
    [ ] describe the oracle implementation of the rdbms and ordbms
    [ ] describe the use and benefits of pl/sql aggregating data using group functions
    [ ] identify the available group functions
    [ ] use group functions
    [ ] group data using the group by clause
    [ ] include or exclude grouped rows by using the having clause creating views
    [ ] describe a view
    [ ] create, alter the definition, and drop a view
    [ ] retrieve data through a view
    [ ] insert, update and delete data through a view
    [ ] create and use an inline view
    [ ] perform top 'n' analysis other database objects
    [ ] describe database objects and their uses
    [ ] create, maintain, and use sequences
    [ ] create and maintain indexes
    [ ] create private and public synonyms controlling user access
    [ ] create users
    [ ] create roles to ease setup and maintenance of the security model
    [ ] use the grant and revoke statements to grant and revoke object privileges declaring variables
    [ ] list the benefits of pl/sql
    [ ] describe the basic pl/sql block and its sections
    [ ] describe the significance of variables in pl/sql
    [ ] declare pl/sql variables
    [ ] execute a pl/sql block writing explicit cursors
    [ ] distinguish between an implicit and an explicit cursor
    [ ] use a pl/sql record variable
    [ ] write a cursor for loop advanced explicit cursor concepts
    [ ] write a cursor that uses parameters
    [ ] determine when a for update clause in a cursor in required
    [ ] determine when to use the where current of clause
    [ ] write a cursor that uses a subquery writing basic sql statements
    [ ] list the capabilities of sql select statements
    [ ] execute a basic select statement
    [ ] differentiate between sql statements and sql*plus commands restricting and sorting data
    [ ] limit the rows retrieved by a query
    [ ] sort the rows retrieved by a query single row functions
    [ ] describe the various types of functions available in sql
    [ ] use character, number, and date functions in select statements
    [ ] describe the use of conversion functions displaying data from multiple tables
    [ ] write select statements to access data from more than one table by using equality and nonequality joins
    [ ] view data that generally does not meet a join condition by using outer joins
    [ ] join a table to itself writing executable statements
    [ ] describe the significance of the executable section
    [ ] write statements in the executable section
    [ ] describe the rules of nested blocks
    [ ] execute and test a pl/sql block
    [ ] use coding conventions interacting with the oracle server
    [ ] write a successful select statement in pl/sql
    [ ] declare the datatype and size of a pl/sql variable dynamically
    [ ] write dml statements in pl/sql
    [ ] control transactions in pl/sql
    [ ] determine the outcome of sql dml statements handing exceptions
    [ ] define pl/sql exceptions
    [ ] recognize unhandled exceptions
    [ ] list and use different types of pl/sql exception handlers
    [ ] trap unanticipated errors
    [ ] describe the effect of exception progagation in nested blocks
    [ ] customize pl/sql exception messages subqueries
    [ ] describe the types of problems that subqueries can solve
    [ ] define subqueries
    [ ] list the types of subqueries
    [ ] write single row and multiple row subqueries multiple-column subqueries
    [ ] write multiple-column subqueries
    [ ] describe and explain the behavior of subqueries when null values are retrieved
    [ ] write subqueries in a from clause producing readable output with isql*plus
    [ ] produce queries that require a substitution variable
    [ ] produce more readable output
    [ ] create and execute script files manipulating data
    [ ] describe each dml statement
    [ ] insert rows into a table
    [ ] update rows in a table
    [ ] delete rows from a table
    [ ] merge rows in a table
    [ ] control transactions including constraints
    [ ] describe constraints
    [ ] create and maintain constraints

  5. #5
    Expert Member
    Join Date
    Nov 2008

    Re: OCA Certification

  6. #6
    Junior Member
    Join Date
    Jun 2008

    Re: OCA Certification

    Cantact ORACLE india Pvt ltd

  7. #7
    Expert Member
    Join Date
    Jun 2007

    Re: OCA Certification

    Hi All,

    Did anyone appear for 1Z0-047 Oracle Database SQl Expert exam? If so, could you please guide me through the process, material etc. Thanks for your time


  8. #8
    Expert Member
    Join Date
    Nov 2008

    Re: OCA Certification

    The link that I have given in my above post will give you detailed information about the topics to be covered etc.

  9. #9
    Expert Member
    Join Date
    Jun 2007

    Re: OCA Certification

    would you mind sending the material/sample question papers.


  10. #10
    Junior Member
    Join Date
    Sep 2010

    Re: OCA Certification


    if u want to do OCA certification there are two modules. For OCA certification u have to appear in two pares.
    the two modules are
    1) OCA for developers.

    The papers are

    1Z0-007 Introduction to Oracle9i SQL + Oracle Database 10g: Administration I 1Z0-042---> Oracle10g Database Certified Associate
    1Z0-047 Oracle Database SQL Expert

    2) OCA for DBA`s.

    Introduction to SQL + Oracle 9i: PL/SQL.Exam: 1Z0-047-----> Oracle9i Oracle PL/SQL DeveloperCertified Associate
    Exam: 1Z0-007 (OCA)

    For these exams u have to consult Oracle procter.

    Last edited by admin; 11-17-2010 at 10:29 AM.

  11. #11
    Junior Member
    Join Date
    Sep 2010

    Re: OCA Certification

    first u have to appear as OCA afterwards u can go for OCP

  12. #12
    Junior Member
    Join Date
    Sep 2010

    Re: OCA Certification

    hi sushma this is karthik this is my mail id u can contact thrugh this ok....and i have some stuff regarding material/sample question papers.

  13.  Sponsored Ads


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.