Home » RDBMS Server » Server Administration » A bit confused with the constraints
A bit confused with the constraints [message #244590] Wed, 13 June 2007 08:14 Go to next message
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 444 times)
Re: A bit confused with the constraints [message #244591 is a reply to message #244590] Wed, 13 June 2007 08:18 Go to previous messageGo to next message
it_me24
Messages: 167
Registered: March 2006
Location: delhi
Senior Member
No Message Body
  • Attachment: quest.doc
    (Size: 88.00KB, Downloaded 496 times)
Re: A bit confused with the constraints [message #244595 is a reply to message #244591] Wed, 13 June 2007 08:23 Go to previous messageGo to next message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
Why not post the contents? I will not open a .DOC attachment.
Re: A bit confused with the constraints [message #244600 is a reply to message #244590] Wed, 13 June 2007 08:42 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So rewrite it.
I can neither open a .doc file.

Regards
Michel
Re: A bit confused with the constraints [message #244628 is a reply to message #244600] Wed, 13 June 2007 09:43 Go to previous messageGo to next message
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.
Re: A bit confused with the constraints [message #244651 is a reply to message #244628] Wed, 13 June 2007 11:14 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
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
Re: A bit confused with the constraints [message #244666 is a reply to message #244590] Wed, 13 June 2007 12:37 Go to previous message
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.
Previous Topic: SGA and Memory Mapping
Next Topic: db_file_multiblock_read_count - reading too less blocks at a time
Goto Forum:
  


Current Time: Sat Dec 10 20:51:16 CST 2016

Total time taken to generate the page: 0.07881 seconds