Interested to Buy Any Domain ? << Click Here >> for more details...
12 RULES OF RDBMS
- 1 Answers
- 4376 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 |
what's query optimization and without use of IN AND Exist can we get another way data from query
Explain cascading triggers.
Explain oracle instance.
How to delete a column in an existing table in oracle?
What are nested tables?
What is meant by joins?
What is a snapshot log?
SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN WE INSERT THAT RECORD IN ANOTHER TABLE LIKE(T4)?
When can Hash Cluster used ?
What is object data modeling?
What is oracle in java?
What is oracle data type?
Oracle General 
