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.

Why cursor variables are easier to use than cursors?

1094

---

How will you write a query to get a 5th rank student from a table student_report?

1863

---

Explain the use of control file?

1111

---

How to join two tables in a single query using oracle?

995

---

What is a schema in oracle?

1012

---

Explain view?

1029

---

Explain the use of show option in imp command.

1096

---

What is the minimum client footprint required to connect c# to an oracle database?

1092

---

What is the purpose of save points in oracle database?

1114

---

What are the differences between char and nchar in oracle?

1094

---

How to use "out" parameter properly?

1080

---

Explain the difference between a procedure and a function?

1167

---

Give the various rollback segment states.

1052

---

Explain what are the characteristics of data files?

1084

---

How to retrieve data from an explicit cursor?

1059

---