OraFAQ Forum: Server Administration » A bit confused with the constraints

Home » RDBMS Server » Server Administration » A bit confused with the constraints

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

A bit confused with the constraints [message #244590]

Wed, 13 June 2007 08:14

it_me24
Messages: 167
Registered: March 2006
Location: delhi

Senior Member

Hi All,

Please see the attached document and can somebody explain that why answer C is correct not A

Appreciate your feedback.

Attachment: quest.doc
(Size: 88.00KB, Downloaded 1329 times)

Report message to a moderator

Re: A bit confused with the constraints [message #244591 is a reply to message #244590]

Wed, 13 June 2007 08:18

it_me24
Messages: 167
Registered: March 2006
Location: delhi

Senior Member

No Message Body

Attachment: quest.doc
(Size: 88.00KB, Downloaded 1383 times)

Report message to a moderator

Re: A bit confused with the constraints [message #244595 is a reply to message #244591]

Wed, 13 June 2007 08:23

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

Why not post the contents? I will not open a .DOC attachment.

Report message to a moderator

Re: A bit confused with the constraints [message #244600 is a reply to message #244590]

Wed, 13 June 2007 08:42

it_me24
Messages: 167
Registered: March 2006
Location: delhi

Senior Member

Hi,

Thank you for your quick reply.
Actually i have taken a screenshot from .pdf file.

that is why i cannot paste the contents, please check.

Thank you in advance.

[Updated on: Wed, 13 June 2007 08:44]

Report message to a moderator

Re: A bit confused with the constraints [message #244610 is a reply to message #244600]

Wed, 13 June 2007 08:57

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

So rewrite it.
I can neither open a .doc file.

Regards
Michel

Report message to a moderator

Re: A bit confused with the constraints [message #244628 is a reply to message #244600]

Wed, 13 June 2007 09:43

it_me24
Messages: 167
Registered: March 2006
Location: delhi

Senior Member

Please see the result after Querying DBA_Constraints view.

CONSTRAINT_NAME C DEFERRABLE DEFERRED VALIDATED
__________________ _________ _________ __________

EMP_JOB_NN C DEFERRABLE DEFFERRED NOT VALIDATED

can you please explain if C denotes the check constraint , then why the answer for this question is written as Not Null constraint.

Thank you.

Report message to a moderator

Re: A bit confused with the constraints [message #244651 is a reply to message #244628]

Wed, 13 June 2007 11:14

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

I see a check constraint, I don't see anything refering NOT NULL (except the NN postfix, Oracle standard naming for Not Null).

Regards
Michel

Report message to a moderator

Re: A bit confused with the constraints [message #244666 is a reply to message #244590]

Wed, 13 June 2007 12:37

Yasir Hashmi
Messages: 304
Registered: April 2006

Senior Member

Hi,
There is no special constraint type in oracle for NOT NULL constraints.
If you check in dba_constraints for any NOT NULL constraint, the constraint_type has the value 'C'.

Since "_NN" is a standard name for NOT NULL constraints,
the answer is correct.

Report message to a moderator

Previous Topic:	SGA and Memory Mapping
Next Topic:	db_file_multiblock_read_count - reading too less blocks at a time

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 23:06:13 CDT 2024