Answer Posted / sravya

There are two types of data independence

1. Logical data independence: The ability to change the
logical (conceptual) schema without changing the External
schema (User View) is called logical data independence. For
example, the addition or removal of new entities,
attributes, or relationships to the conceptual schema should
be possible without having to change existing external
schemas or having to rewrite existing application programs.

2 Physical data independence: The ability to change the
physical schema without changing the logical schema is
called physical data independence. For example, a change to
the internal schema, such as using different file
organization or storage structures, storage devices, or
indexing strategy, should be possible without having to
change the conceptual or external schemas.

what happened to the global index when I truncate the data in one of the partition?

2062

---

What is oracle instant client?

1064

---

Explain the function of optimizer in oracle?

1195

---

What is literal?

1060

---

Is primary key indexed by default in oracle?

1043

---

What is proxy method?

1019

---

Can we create database in oracle using command line ?

1127

---

How to manage transaction isolation level?

1054

---

How to connect the oracle server as sysdba?

1125

---

What is an oracle tablespace?

1092

---

What are the attributes that are found in a cursor?

1118

---

What is a procedure in oracle?

1276

---

How to commit the current transaction in oracle?

1177

---

What is the difference between a user and a schema in oracle?

1075

---

Difference between pre-select and pre-query

1171

---