Answer Posted / n.srivani

Normalization is a process to reduce the redundant data in
the database.

How to convert a string to a date in oracle database?

1002

---

Calculate difference between 2 date / times in oracle sql?

987

---

What would you do with an in-doubt distributed transaction?

1916

---

How to count duplicated values in a column in oracle?

985

---

How to assign values to variables?

1046

---

How to define a record variable to store a table row?

1005

---

What are joins, explain all types of joins?

2221

---

Can we commit inside a function in oracle?

920

---

What are privileges and grants?

1002

---

What are the attributes of cursor?

990

---

What is java oracle used for?

973

---

What is integrity and what is constraint??Explain with example

2215

---

Explain the use of file option in exp command.

1081

---

What is a trigger and what are its types?

1115

---

what is the difference between restoring and recovering?

965

---