This website provides targeted information for you searches. Trust the #1 resource for certification information that thousands have come to rely upon for great resources, all at a low price.

Exam Topics

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

Other related Resources at Actualtests.com

We hope you take advantage of the unlimited access package today. Your query about Oracle Exam Information - ActualTests.com can also be answered if you become a member today. We have all the details in the member zone. You can also download a testing engine for the most popular exams alogwith all the PDF's. They're all included in the package.

Check the MCSE Training page also if you are interested in that certification.