GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle  >  General
Go To First  |  Previous Question  |  Next Question 
 General  |  Question 192 of 211    Print  
How many codds rule should oracle satisfies

  
Total Answers and Comments: 12 Last Update: September 30, 2008     Asked by: Ajish 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
  Sorting Options  
  Page 1 of 2   « First    1    2    >     Last »  
September 28, 2005 05:08:44   #1  
kulwant1977 Member Since: September 2005   Contribution: 7    

RE: How many codds rule should oracle satisfies
Oracle Satisfies 11 of the 12 rules.

 
Is this answer useful? Yes | No
January 22, 2006 09:09:20   #2  
dhpuneet Member Since: January 2006   Contribution: 4    

RE: How many codds rule should oracle satisfies

Hi Kulwant

Thank you for this piece of information but can you please tell us what are the 11 rules oracle satisfies. If possible please provide us any site or link in this matter that will elaborate the things.

A quick response will be highly appreciated.

Regards

Punu


 
Is this answer useful? Yes | No
February 12, 2006 01:57:37   #3  
muthu        

RE: How many codds rule should oracle satisfies
HI CAN I KNOW THAT ONE RULE WHICH IS NOT SUPPORTED BY ORCALE WITH REGARDS MUTHU
 
Is this answer useful? Yes | No
April 14, 2006 02:29:54   #4  
pranav kumar purbey        

RE: How many codds rule should oracle satisfies

oracle can support codd's 11.5 rules.

view updated rules fully not supported in oracle.


 
Is this answer useful? Yes | No
April 14, 2006 02:40:21   #5  
pranavtalk2u Member Since: April 2006   Contribution: 1    

RE: How many codds rule should oracle satisfies

oracle can supports 11.5 rules of codd's .

oracle can't fully support view updatded rules.


 
Is this answer useful? Yes | No
April 24, 2006 04:51:58   #6  
gorantla_rao Member Since: February 2006   Contribution: 5    

RE: How many codds rule should oracle satisfies
Hi friend this is srinivas. There r totally 12 Codd rules are there. If any 6 rules are satisfied with the database then thatwill comes under rdbms. this is the site u can get the information about the codd rules.http://www.psoug.org/reference/codds_rules.html
 
Is this answer useful? Yes | No
July 19, 2006 14:40:55   #7  
Krish        

RE: How many codds rule should oracle satisfies

hi

Oracle satisfies 11.5 of 12 codd's rules.

The DML Operations on a complex view is not possible directly.

because Oracle only update the Simple view But it will over come

INSTEAD OF TRIGGER .

Krish


 
Is this answer useful? Yes | No
July 19, 2006 14:49:14   #8  
gigopi Member Since: July 2006   Contribution: 2    

RE: How many codds rule should oracle satisfies

11.5 Rules

The updation on a complex view is not possible in oracle .That is the remining rule.But we can over come this on INstead of trigger

Regards

Krish


 
Is this answer useful? Yes | No
August 15, 2006 10:07:52   #9  
gouthami kodangal        

RE: How many codds rule should oracle satisfies

The min no of codds rules an Rdbms should satisfy are 6 out of the 12.wherein the oracle satisfies 12 rules


 
Is this answer useful? Yes | No
October 05, 2006 05:13:50   #10  
Santosh        

RE: How many codds rule should oracle satisfies
Non Subversion rule :

If a relational system has a low-level (single-record-at-a-time) language that low level cannot be used to subvert or bypass the integrity Rules and constraints expressed in the higher level relational language (multiple-records-at-a-time).

The RDBMS should prevent users from accessing the data without going through the Oracle data-read functions.
In Rule 5 Codd stated that an RDBMS required a Query Language however Codd does not explicitly state that SQL should be the query tool just that there should be a tool and many of the initial products had their own tools Oracle had UFI (User Friendly Interface) Ingres had QUEL (QUery Execution Language) and the never released DB1 had a language called sequel the acronym SQL is often pronounced such as it was sequel that provided the core functionality to SQL.
Even when the vendors eventually all started offering SQL the flavours were/are all radically different and contained wildly varying syntax. This situation was somewhat resolved in the late 80's when ANSI brought out their first definition of the SQL syntax.
This has since been upgraded to version 2 and now all vendors offer a standard core SQL however ANSI SQL is somewhat limited and thus all RDBMS providers offer extensions to SQL which may differ from vendor to vendor


 
Is this answer useful? Yes | No
  Page 1 of 2   « First    1    2    >     Last »  


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape