CP Exam 1 in the Oracle DBA track covers concepts and practices around the use of SQL and L/SQL commands. To pass this exam,you need to demonstrate an understanding of the basic SQL constructs available in Oracle, including built-in functions. You should also understand the basic concepts behind an Oracle relational database management system. In more recent editions of OCP Exam 1, the focus has included understanding of use of the PL/SQL programming language. In addition, new features in PL/SQL introduced in Oracle8i are tested,so you should also be sure you understand these new features.
OCP Exam I Topic areas
The following topic areas are covered in OCP Exam 1.Note that these concepts are taken directly from the Oracle OCP Candidate Guide for OCP Exam 1 and are current as of the publication of this book. The topics and subtonics are as follows:
1. Overview of Relational Databases, SQL,and PL/SQL
1.1 Discuss the theoretical and physical aspects of a relational database
1.2 Describe the Oracle implementation of the RDBMS and ORDBMS