Answer Posted / gautam choudhury

1) If the table partitioning column is a subset of the
index keys, use a local index. If this is the case, you are
done.

If this is not the case, continue to guideline 2.

2) If the index is unique, use a global index. If this is
the case, you are done. If this is not the case, continue
to

guideline 3.

3) If your priority is manageability, use a local index. If
this is the case, you are done. If this is not the case,

continue to guideline 4.

4) If the application is an OLTP one and users need quick
response times, use a global index. If the application is a
DSS one

and users are more interested in throughput, use a local
index.

How to convert raw data type into text in oracle? Explain

955

---

Explain the use of online redo log files in oracle.

996

---

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5344

---

What privilege is needed for a user to connect to oracle server?

945

---

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2778

---

What do you mean by group by clause?

990

---

Give the different types of rollback segments.

984

---

Explain the use of compress option in exp command.

972

---

How would you go about verifying the network name that the local_listener is currently using?

2001

---

Is oracle a relational database?

877

---

Explain oracle 12c new features for developers?

1001

---

What is materialized view in Oracle?

1046

---

what is meant by magic query

2139

---

What are a collation and state the different types of collation sensitivity?

1108

---

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4302

---