0

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

Edited by pritaeas: Closed again.

13
Contributors
15
Replies
25
Views
8 Years
Discussion Span
Last Post by pritaeas
0

You can get most of your answer,<URL SNIPPED>
For more you can contact me personally. It is difficult to answer all the questions at a time.

0

hey gimme ur maild id or else pm me ill send u material for that i have already done my OCA certification so its all upto u...........

0

I am preparing for my OCA certification and i want to follow the pl/Sql stream.. can anyone advise me on what to read and the

dumps sites that helps

i have heard of ucertify and pass 4 sure but i don't really know if they are for real..

I'm preparing at home using the sybex book for sql..

i will also like it if anyone can recommend any book for pl/sql..

thanks all

0

I am preparing for my OCA certification and i want to follow the pl/Sql stream.. can anyone advise me on what to read and the

dumps sites that helps

i have heard of ucertify and pass 4 sure but i don't really know if they are for real..

I'm preparing at home using the sybex book for sql..

i will also like it if anyone can recommend any book for pl/sql..

thanks all

Ya we have some dumps to prepare for certifications

see lemme tell u one thing keep in mind that if we prepare from dumps and do our certification what's the use of certification then

its all in u dude u have some set of questions keep on repeating in certifications the best thing is that just ill post dump to u
u just work out every question of that and answers too

its not a big deal u can come out successful
the best book i suggest is PL/SQL programming by SCOTT URMAN

just pm me ur mail id ill forward u latest possible questions

0

Hi All,

I am preparing for my OCA Certification 1Z0-047 Oracle Database SQL Expert. Can anyone pls suggest a study material covering all the topics

Thanks in advance
Meenashi

0

ya for sure you just pm your mail ill forward you some material which covers all the topics and ofcourse they are very much repeating questions in exam

0

sure meenashi when r u thinking of giving your exam k fine ill post u some material as you said covering all the topics you just prepared every question in them and you will be getting atleast 95 % ....in worst case atleast 90%
but dont just prepare only question ...... just read the question and cover the related topic in text book
any way i suggest you SCOTT URMAN

jsut PM me your id ill mail you those dumps........

0

Hello I am planning to take the 1Z0-047 exam soon. Can you please send me the material and also dumps to my email id: <EMAIL SNIPPED>.

I would really appreciate your help

Thanks,
Swetha.

0

Can someone send me the study materials for 1zo-047 to my email id.. <EMAIL SNIPPED>

Thanks in advance

0

I have decided to start preparing for the OCA exam. And while searching on the net I came to know that before giving OCA i have to complete 2 exam. is it so? Please help!!!!

Edited by pritaeas: Removed email.

0

Closing thread getting attention of people who are not willing to pay for study materials as they should!

Closed again.