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.

how do u know the total no of rows in a table?

6 Answers  

---

what are different types of locks?

6 Answers  

---

Give the various rollback segment states.

0 Answers  

---

how the indexes are stored in the Oracle Database?

0 Answers  

---

What is the difference between view and materialized view in Oracle?

0 Answers   MCN Solutions,

---

What is the use of Redo Log Information ?

2 Answers  

---

What are the factors that affect OPTIMIZER in choosing an Optimization approach ?

2 Answers  

---

i must get table name, constraint type, constrain name with using concads "||" and it must be in string type, then with join processes i need code please help immidiately

1 Answers  

---

what is main def between plsql/table and array?

1 Answers   Oracle,

---

What is a partition in oracle?

0 Answers  

---

How to end the current transaction in oracle?

0 Answers  

---

How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. when u use to_char(), it tells the month is invalid. how to resolve this problem.tel with eg.

2 Answers   AppLabs,

---