| Progress with Self-Test Software CD [message #223105] |
Wed, 07 March 2007 10:03  |
DanAshcroft
Messages: 6
Registered: March 2007
|
Junior Member |
|
|
HI
I started out studying for the 1Z0 007 exam 6 weeks ago. I am taking a preparation course with a university in US (online).
I just received the Self Test CD bundle and I feel pretty phased by a number of the questions surrounding joins and subqueries. My average score is around 40% right now. I at least now know where to focus on - the aforesaid areas.
Does anyone have any idea where I might look for more subquery questions or notes? I am not looking for "dump" type stuff, but explanations. I have read the Couchman text back to back but the material on subqueries is just a taster.
If the questions on the exam are anything like those on the CD then I wont be booking my exam for a long time yet (and I want to finish sometime this year for both exams!)
Thanks for any helpful replies.
DA
|
|
|
|
| Re: Progress with Self-Test Software CD [message #223335 is a reply to message #223105] |
Thu, 08 March 2007 08:20  |
prashant_pathak
Messages: 263
Registered: February 2006
Location: California,US
|
Senior Member |
|
|
These are the group from which you will get a question in your 007 exam so 75% of the section requires a certain join operation so yes you are looking at questions which involves join.
Writing Basic SQL Select Statements
Restricting and Sorting Data
Single-Row Functions
Displaying Data from Multiple Tables
Aggregating Data using Group Functions
Subqueries
Producing Readable Output with iSQL*Plus
Manipulating Data
Creating and Managing Tables
Including Constraints
Creating Views
Creating Other Database Objects
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
