How view is different from a table?

972

---

What do you understand by a database object?

990

---

What is meant by raw datatype?

1006

---

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

995

---

Where do we use decode and case statements?

945

---

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

997

---

What is the difference between truncate & delete command?

1126

---

How will you identify oracle database software release?

944

---

What are the attributes that are found in a cursor?

1013

---

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

971

---

What is a nvl function?

958

---

Why do we use coalesce function in oracle?

1055

---

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

1005

---

How translate command is different from replace?

1012

---

How will you differentiate between varchar & varchar2?

994

---