12 RULES OF RDBMS
Answer / povidyasagar
1. Data should be represent in the form of table.
2. data is logically accessible.
3. all the null vaules should be uniformly treated as
unknown values.
4. single language should be used to communicate with RDBMS
package.
5. every relational database should be self described.
oracle contains two types of tables.
(a) system tables -- tables which contains meta data of user
tables.
(b) user tables -- tables with business data.
6. logical data independence.
7. physical data independence.
8. altematives must be provided for viewing data.
9. every RDBMS package should supports setbased and
relational algebra operations.
10. integrity rule.
11. every RDBMS package should support distributed operations.
12. data integrity cannot be subverted.
Note: Any DBMS package supports 6 out of 12 codds rules.
| Is This Answer Correct ? | 2 Yes | 0 No |
How to execute a stored program unit?
Hello All, Could any one provide me FAQs/interview questions on oracle PL/SQL
what is the use of rank function?
How do I uninstall oracle 11g?
i can't insert column value greater than 4000 characters at one instance even i am using CLOB datatype . how to insert efficiently more than 4000 characters ? And please let me know how to impose inline and out-of line constraints on oracle column??? Thanks in Advance... Prakash
What are the different editions of oracle?
Where is the export dump file located?
What is the difference between SQL and SQL Server?
What is parameterized cursor in oracle?
How to do a full database export?
Explain the difference between a procedure and a function? What do you understand by those terms?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....