Examine the structure of the employees table: 
There is a parent/child relationship between EMPLOYEE_ID and MANAGER_ID.
You want to display the name, joining date, and manager for all the employees. Newly hired
employees are yet to be assigned a department or a manager. For them, ‘No Manager1 should be
displayed in the manager column.
Which SQL query gets the required output?
A.
Option A
B.
Option B
C.
Option C
D.
Option D
Explanation:
http://ivrainbow65.blogspot.com/
Why D?
I think the correct response is A
Is ‘nt Natual Join for columns with the same name?
I think B is the correct one
I also think so. We have to retrieve those null values in e.manager_id, and e table is in the left side of the join.
I also think that B is correct.
LEFT OUTER JOIN
Retrieves the records that match the table right and also those of the left table records that do not match.
Cesário,
I Agree with You the answer B is the correct one.
Where is Cesario 🙂
A is wrong. Using “Join” can only produce matching values from two tables ignoring null values. So since the required output needs to show the employees even without manager then that is the time that were going to use LEFT OUTER JOIN. And so the correct answer is B.
Correction: What I mean is Option D is wrong. Correct answer is B.
share with us the updated dump the total of 74 question are not enough to pass this exam. I passes the first sitting and I found the different question than this dump only 25 question are valid in this blog the others are new out of 75 total question
What do you mean? the answers in this website are not reliable?
rofl
No, really, I literally laughed hard for this one. My wife just came to see why I was laughing 😛
Hi Mug, what are the other questions?
I completed my exam a few moments back and not more than 10-15 questions are from this site.
Arnab, which exam did you take? is it 1z0-061?
Hi can anyone send me latest dumps at [email protected]
arnab sir I scheduled my oracle 1z0-061 exam tomorrow. and i practised the question that are available on this site.
would I be able to clear the exam or not? If not, then can you please send me the updated dumps on [email protected]
can you please send the questions and answers?
Can any one send me the latest dump on my mail for IZ0-061 [email protected]
Hi Imran, Can u pls forward the dump to me as well ? at [email protected]
Hi Arnab and Imran, can you please pass me the questions as well?
at [email protected]
The answer D is definitely wrong since NATURAL and ON are mutually exclusive.
http://www.orafaq.com/wiki/Natural_join
Please pay more attention!
Hi can anyone send me latest dumps at [email protected]
please study nivedita munjal.
The correct Answer is B. Dont memorize the answers…study until you can’t get it wrong
B is Correct answer.