12 RULES OF RDBMS
- 1 Answers
- 3872 Views
- I also Faced
- E-Mail Answers
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 compare dates in oracle sql?
What is meant by a deadlock situation?
Which Database is the best for the Security issue ? 1. DB2 2.SQL Server 3.MySQL 4.ORACLE
What is a materialised view?
When do we use group by clause in a sql query?
how to retrieve data from different tables ,place this data in different excel worksheets.
Can we convert a date to char in oracle and if so, what would be the syntax?
What is the max number of columns in an oracle table?
can a view be updated?
What are the different types of record groups in oracle? Explain each of them
Explain about integrity constraint?
what is candidate key & super key
Oracle General 
