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.

Explain the use of record length option in exp command.

1021

---

How to drop an existing view in oracle?

903

---

Can a formula column be obtained through a select statement ?

2264

---

Why we use bulk collect in oracle?

967

---

What is the difference between postgresql and oracle?

978

---

How to change user password in oracle?

974

---

What is a procedure in oracle?

1073

---

Is oracle a programming language?

936

---

How to write an inner join with the where clause in oracle?

994

---

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

1289

---

How to synchronize 2 schema's objects?

2115

---

What is connection pooling in oracle?

911

---

Whether any commands are used for months calculation? If so, what are they?

1040

---

Write a trigger example in oracle?

980

---

What are the uses of synonyms?

1083

---