hi all,
I need one help.i want to give OCA exam the name and number of exam is "1Z0-047 Oracle Database SQL Expert" these is for "10g".But i don't have any material for that.please send me the material for that. only i know the exam topics which i am send to so that you all can refer to that :
Retrieving Data Using the SQL SELECT Statement
[ ]List the capabilities of SQL SELECT statements
[ ]Execute a basic SELECT statement
[ ]Describe how schema objects work
Restricting and Sorting Data
[ ]Limit the rows that are retrieved by a query
[ ]Sort the rows that are retrieved by a query
Using Single-Row Functions to Customize Output
[ ]Describe various types of functions that are available in SQL
[ ]Use character, number, and date functions in SELECT statements
[ ]Describe the use of conversion functions
Reporting Aggregated Data Using the Group Functions
[ ]Identify the available group functions
[ ]Describe the use of group functions
[ ]Group data by using the GROUP BY clause
[ ]Include or exclude grouped rows by using the HAVING clause
Displaying Data from Multiple Tables
[ ]Write SELECT statements to access data from more than one table using equijoins and nonequijoins
[ ]Join a table to itself by using a self-join
[ ]View data that generally does not meet a join condition by using outer joins
[ ]Generate a Cartesian product of all rows from two or more tables
Using Subqueries to Solve Queries
[ ]Define subqueries
[ ]Describe the types of problems that subqueries can solve
[ ]List the types of subqueries
[ ]Write single-row and multiple-row subqueries
Using the Set Operators
[ ]Describe set operators
[ ]Use a set operator to combine multiple a single query
[ ]Control the order of rows returned
Manipulating Data
[ ]Describe each data manipulation language (DML) statement
[ ]Insert rows into a table
[ ]Update rows in a table
[ ]Delete rows from a table
[ ]Control transactions
Using DDL Statements to Create and Manage Tables
[ ]Categorize the main database objects
[ ]Review the table structure
[ ]List the data types that are available for columns
[ ]Create a simple table
[ ]Explain how constraints are created at the time of table creation
Creating Other Schema Objects
[ ]Create simple and complex views
[ ]Retrieve data from views
[ ]Create, maintain, and use sequences
[ ]Create and maintain indexes
[ ]Create private and public synonyms
Managing Objects with Data Dictionary Views
[ ]Use the data dictionary views to research data on your objects
[ ]Query various data dictionary views
Controlling User Access
[ ]Differentiate system privileges from object privileges
[ ]Grant privileges on tables
[ ]View privileges in the data dictionary
[ ]Grant roles
[ ]Distinguish between privileges and roles
Managing Schema Objects
[ ]Add constraints
[ ]Create indexes
[ ]Create indexes using the CREATE TABLE statement
[ ]Creating function-based indexes
[ ]Drop columns and set column UNUSED
[ ]Perform FLASHBACK operations
[ ]Create and use external tables
Manipulating Large Data Sets
[ ]Manipulate data using subqueries
[ ]Describe the features of multitable INSERTs
[ ]Use the following types of multitable INSERTs (Unconditional, Conditional and Pivot)
[ ]Merge rows in a table
[ ]Track the changes to data over a period of time
Generating Reports by Grouping Related Data
[ ]Use the ROLLUP operation to produce subtotal values
[ ]Use the CUBE operation to produce crosstabulation values
[ ]Use the GROUPING function to identify the row values created by ROLLUP or CUBE
[ ]Use GROUPING SETS to produce a single result set
Managing Data in Different Time Zones
[ ]Use Various datetime functions
Retrieving Data Using Subqueries
[ ]Write a multiple-column subquery
[ ]Use scalar subqueries in SQL
[ ]Solve problems with correlated subqueries
[ ]Update and delete rows using correlated subqueries
[ ]Use the EXISTS and NOT EXISTS operators
[ ]Use the WITH clause
Hierarchical Retrieval
[ ]Interpret the concept of a hierarchical query
[ ]Create a tree-structured report
[ ]Format hierarchical data
[ ]Exclude branches from the tree structure
Regular Expression Support
[ ]Using Meta Characters
[ ]Regular Expression Functions
[ ]Replacing Patterns
[ ]Regular Expressions and Check Constraints