Home » Other » Training & Certification » OCA Certification, exam 051 questions
OCA Certification, exam 051 questions [message #561454] Mon, 23 July 2012 02:19 Go to previous message
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

 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Difference Between "Redo Log Buffer" and "Database Buffer Cache"?
Next Topic: Looking for complete online course for Oracle Developer & DBA
Goto Forum:
  


Current Time: Thu Mar 28 12:59:51 CDT 2024