What is a nvl function?

1054

---

Why do we use coalesce function in oracle?

1142

---

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

1076

---

How translate command is different from replace?

1105

---

How will you differentiate between varchar & varchar2?

1052

---

What are the set operators union, union all, minus & intersect meant to do?

1003

---

What is a nvl function? How can it be used?

1053

---

What is the use of aggregate functions in oracle?

1039

---

What do you mean by a database transaction & what all tcl statements are available in oracle?

1007

---

What is a data dictionary and how can it be created?

1172

---

Why do we need integrity constraints in a database?

1048

---

What are the different responsibilities of a dba?

739

---

How can we tune a sql query to optimize the performance of a database?

1

---

What is a password file in a database and why is it required when a user can be authenticated using data dictionary tables?

1

---

What is rac?

1

---