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.

What is the data pump import utility?

969

---

How to use like conditions in oracle?

996

---

How do we create privileges in oracle?

993

---

What is a package ? What are the advantages of package ?

1033

---

Explain the use of parfile option in exp command.

991

---

What is flashback in Oracle?

967

---

What is oracle in java?

913

---

Can we create database in oracle using command line ?

1031

---

What is a connect identifier?

983

---

How to update a table row with a record?

962

---

Explain the use of Merge statement in oracle 11g

978

---

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

2045

---

Who developed oracle & when?

945

---

What is ceil and floor in oracle?

1011

---

How to add another datafile to a tablespace?

994

---