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 delete an existing row from a table in oracle?

1127

---

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2143

---

What is the data pump export utility?

1129

---

What are the restrictions on external table columns?

1107

---

Calculate difference between 2 date / times in oracle sql?

1097

---

How to concatenate two text values in oracle?

1151

---

How to display employee records who gets more salary than the average salary in the department?

1124

---

Can select statements be used on views in oracle?

1082

---

What is the scope of a local variable?

1119

---

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1921

---

Why we use bulk collect in oracle?

1109

---

How to list all tables in your schema?

1113

---

Is there a function to split a string in plsql?

1104

---

Explain oracle left join with an example?

1058

---

What happens to indexes if you drop a table?

1222

---