Answer Posted / kamal pratap singh

Normalization is the process of reduce the redundency in
database which is usefull for maintain the database very
smoothly and fast processing.

How to rollback the current transaction in oracle?

538

---

How to create a new view in oracle?

622

---

How to initialize variables with default values?

636

---

What is a private synonym?

1086

---

Why does Oracle not permit the use of PCTUSED with indexes?

1953

---

---

How to define and use table alias names in oracle?

510

---

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

1378

---

What is Segment Advisor in Oracle?

669

---

What is Library Cache in Oracle?

644

---

How to retrieve data from an cursor to a record?

563

---

What is the difference between substr & instr functions?

597

---

How do I spool to a csv formatted file using sqlplus?

550

---

How to enter a new row into a table interactively?

550

---

How to see the table columns used in an index?

596

---

How to set a transaction to be read only in oracle?

582

---