Answer Posted / jannath

Normalization is the Process of reducing a complex data
structure into its simplest and most stable form by
eliminating redundant attributes, keys, and relationships.

Explain database link?

1170

---

What is merge statement used for?

1072

---

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

1009

---

Explain joins in oracle?

1089

---

What are a cluster and non-cluster index?

1064

---

What are the varoius components of physical database structure of oracle database?

1038

---

How to use fetch statement in a loop?

1066

---

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2173

---

How many types of synonyms in Oracle?

1175

---

How to upsert (update or insert into a table)?

1042

---

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2305

---

How to use select statement to count the number of rows in oracle?

1092

---

Does oracle charge for java?

1112

---

What is a connect identifier?

1084

---

Differentiate between function and procedure in oracle.

1150

---