How view is different from a table?

1091

---

What do you understand by a database object?

1109

---

What is meant by raw datatype?

1121

---

When do we use group by clause in a sql query?

1101

---

Where do we use decode and case statements?

1063

---

How can we find out the duplicate values in an oracle table?

1125

---

What is the difference between truncate & delete command?

1237

---

How will you identify oracle database software release?

1058

---

What are the attributes that are found in a cursor?

1124

---

What do you understand by a database object? Can you list a few of them?

1068

---

What is a nvl function?

1097

---

Why do we use coalesce function in oracle?

1169

---

What is the quickest way to fetch the data from a table?

1104

---

How translate command is different from replace?

1143

---

How will you differentiate between varchar & varchar2?

1087

---