Interested to Buy Any Domain ? << Click Here >> for more details...
12 RULES OF RDBMS
- 1 Answers
- 4521 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 get execution statistics reports on query statements?
What do you know about normalization? Explain in detail?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What are steps required to ENTER DATA INTO DWH?
How do we display rows from the table without duplicates?
Please explain compound trigger in oracle?
What is the difference between translate and replace in oracle?
What is oracle instant client?
What is raw datatype?
What is an oracle user role?
12 RULES OF RDBMS
What are group functions in oracle?
Oracle General 
