How view is different from a table?

1028

---

What do you understand by a database object?

1055

---

What is meant by raw datatype?

1056

---

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

1035

---

Where do we use decode and case statements?

1010

---

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

1041

---

What is the difference between truncate & delete command?

1176

---

How will you identify oracle database software release?

1003

---

What are the attributes that are found in a cursor?

1062

---

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

1015

---

What is a nvl function?

1017

---

Why do we use coalesce function in oracle?

1112

---

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

1056

---

How translate command is different from replace?

1076

---

How will you differentiate between varchar & varchar2?

1039

---