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.

Can a formula column referred to columns in higher group ?

2490

---

Please explain oracle left join with an example?

1020

---

How to use regular expression in pattern match conditions in oracle?

1018

---

What are dml statements in oracle?

1075

---

How to delete all rows a table in oracle?

1057

---

How to write numeric literals in oracle?

1164

---

What language does oracle use?

1083

---

How to retrieve data from an explicit cursor?

1039

---

What are the common oracle dba tasks?

1123

---

What is enter substitution variable in oracle?

1028

---

How to call a stored function in oracle?

1008

---

What is the difference between formal parameters and actual parameters?

1062

---

Explain view?

1013

---

How to use "out" parameter properly?

1070

---

How to work with data objects interactively?

959

---