OCA Certification, exam 051 questions [message #561454] |
Mon, 23 July 2012 02:19 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Andrey_R
Messages: 441 Registered: January 2012 Location: Israel
|
Senior Member |
|
|
Hi all,
Since Michel Cadot, the forum moderator,
hasn't answered any of my personal messages sent to him on 21th of July,
I'm posting this here. Hope someone can guide me through this. Thanks in advance.
I am studying for the OCA Certification - the 051 SQL Fundamentals exam.
I've downloaded exams from http://www.examcollection.com/1Z0-051.html ,
And when I solve & look at the answers,
I sometimes come across "right answers" provided by the exam software,
Which seem not reasonable, even when I double check those.
for example, Given the table:
name NULL TYPE
----------------------
EMP_ID NOT NULL NUMBER
EMP_NAME NOT NULL VARCHAR2(40)
EMP_IMAGE LONG
I was supposed to mark the true sentences regarding this table.
one of the options was:
"You can alter the table to include the NOT NULL constraint on the EMP_IMAGE column"
this answer was marked as *NOT* true by the exam software,
Yet, I've tried and saw that I *can* alter a LONG column to not null.
I would like to consult forum members regarding different
questions related to Questions & Answers I encounter, such as this one.
Where can I do that in the forum? Just open a topic for every question I have?
or open a general topic and ask & discuss whatever I want there?
Please advise.
Regards,
Andrey
[Updated on: Mon, 23 July 2012 02:20] Report message to a moderator
|
|
|
Re: OCA Certification, exam 051 questions [message #561456 is a reply to message #561454] |
Mon, 23 July 2012 02:26 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote:Where can I do that in the forum? Just open a topic for every question I have?
If you have a question about SQL, post it in SQL forum.
If you have a question about backup or recovery, post in Backup & Recovery forum.
...
And for interview or certification questions, also post what you tried, what is your opinion and base on what (for instance, link to the documentation).
Do not just expect we answer the question without showing us you first tried to get the answer by yourself.
Edit: And do not forget to format your post.
Regards
Michel
[Updated on: Mon, 23 July 2012 02:28] Report message to a moderator
|
|
|
Re: OCA Certification, exam 051 questions [message #561457 is a reply to message #561454] |
Mon, 23 July 2012 02:28 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Quote:I would like to consult forum members regarding different
questions related to Questions & Answers I encounter, such as this one.
Where can I do that in the forum? Just open a topic for every question I have?
Yes.
With regard to your question, you have proved how useless these "exam" questions are.
And by the way, I wouldn't answer personal messages, either. Specially not at the weekend. Unless you want to pay for consultancy, at the out-of-hours rate.
[Updated on: Mon, 23 July 2012 02:30] Report message to a moderator
|
|
|
Re: OCA Certification, exam 051 questions [message #561458 is a reply to message #561457] |
Mon, 23 July 2012 02:33 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Andrey_R
Messages: 441 Registered: January 2012 Location: Israel
|
Senior Member |
|
|
John - my question to Michel was regarding *where and how to post topic-related questions*,
I didn't expect a personal reply regarding something technical.
And ignoring me twice by a forum moderator is not serious.
I'll just post each question in a different topic,
since I get no answer to my (very simple!) question.
|
|
|
Re: OCA Certification, exam 051 questions [message #561461 is a reply to message #561458] |
Mon, 23 July 2012 02:44 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
I've just had a look at the Examcollection website you mention, it is one of the illegal ones. I've reported them to the appropriate authorities.
I hope you are aware that you risk having your qualifications revoked if you are discovered to have used such resurces.
|
|
|
|
|
|
|
|
|