Answer Posted / 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 to open and close an explicit cursor in oracle?

1096

---

What is the data type of dual table?

1065

---

How much memory your 10g xe server is using?

1153

---

How to load excel data sheet to oracle database

1076

---

What happens to the current transaction if a ddl statement is executed?

1059

---

Explain the characteristics of oracle dba?

1175

---

How do you bind variables in oracle?

1023

---

What happens to indexes if you drop a table?

1223

---

What is archive log in Oracle?

1182

---

What is a user account in oracle?

1171

---

What is materialized view in Oracle?

1115

---

What is set verify off in oracle?

1158

---

What is Java Pool in Oracle?

1246

---

How can I see all tables in oracle?

1060

---

How to resolve the ORA-39133 error in Oracle?

1184

---