How view is different from a table?

1036

---

What do you understand by a database object?

1064

---

What is meant by raw datatype?

1061

---

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

1036

---

Where do we use decode and case statements?

1013

---

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

1046

---

What is the difference between truncate & delete command?

1183

---

How will you identify oracle database software release?

1010

---

What are the attributes that are found in a cursor?

1078

---

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

1018

---

What is a nvl function?

1034

---

Why do we use coalesce function in oracle?

1122

---

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

1058

---

How translate command is different from replace?

1089

---

How will you differentiate between varchar & varchar2?

1044

---