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 |
What are the differences between a sys and system user and what are the extra privileges available to the sys user?
can a table has a column that has only view data and in other columns we can change data?
Can Multiple instances be run on Single Machine???
what is the difference between no rows returned and null returned?
How do I recompile a procedure in oracle?
What is a parameter file in oracle?
What do you mean by redo log file mirroring?
What is a system tablespace and when it is created?
Differentiate the standard purchase order,Blanket purchase agreement,Contract purchase agreement,Planned purchase order?
How to convert a date to char in oracle? Give one example.
How to rollback the current transaction in oracle?
what is foreign key?