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.

can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ?

2 Answers   Allfon,

---

What is a cognitive schema?

0 Answers  

---

DBMS vs. RDBMS

2 Answers   TCS,

---

What is meant by redo log buffer ?

2 Answers  

---

Explain the use of grant option in imp command.

0 Answers  

---

How to run create database statement again?

0 Answers  

---

Name the three major set of files on disk that compose a database in Oracle?

0 Answers  

---

If server is in US and client is in india there is timezone is diffrence, How can we display date in indian time when data is displayed from US server timezone?

1 Answers  

---

How can we find out the duplicate values in an oracle table?

0 Answers  

---

Does oracle charge for java?

0 Answers  

---

What is the quickest way to export a table to a flat file?

0 Answers  

---

How do I spool to a csv formatted file using sqlplus?

0 Answers  

---