i want to prepare oracle 1z0-051 , i study SQL tutorial (HR schema) , and i have seen some questions. but some of tables is like (sales , customers ,promotion ...ets)
What are the schemas in this exam ? by the way all samples schema install in my database
and thx advace
If anyone gave you information directly from the exam they would be in violation of the non-disclosure they signed when they took the exam.
If you understand the fundamentals and principles, it wont' matter about the schema names used on the exam.
If you DON'T understand the fundamentals and principles, it won't matter what schema names you've memorized.
You should not be preparing for the exam by memorizing factoids.
Thanks for the tips ..The idea is not to save , I'm good sql topics , but the idea is to understand diagrams and read the data in order to understand .
There are more than schemas(OE , SH) have the same tables name (customers,products,promotions .. ets )
Well, the sample tables in the sample schemas are merely an example of the things. You can (and should) create your set of tables and schemas for the practice.
There is confusion on what db you are working ? Have you created your own database on your test PC ?
You have said " i study SQL tutorial", what is the name and link of that tutorial ?
>There are more than schemas(OE , SH) have the same tables name (customers,products,promotions .. ets )
As Aman has already give you answer "why don't you search for the mentioned tables in the dba_tables view and check who is their owner?" Did you read/tried this ?
In the exam you will get the snippet of the code that includes table structure and may be data in some tables in some questions. But every time they are different. so my advice is that you need to understand how to read a table definition and interpret. dont just mug up the things. Go to oracle documentation and read and try get the concept right.
I followed the book 'Oracle 11g- SQL Fundamental Exam Guide (Exam 1Z0-051)' it nearly covered all the topics and have good examples at the end of the chapter. happy studying.
You cane refer to 'http://www.oracle.com/technetwork/articles/sql/11g-schemamanagement-089869.html'
and 'Managing Schema Objects'