Answer Posted / chandrakant agrawal

Let us try one using :

select distinct dept_name
from departments;

What this query would return if dept_name column contains
NULL values.

How to disable a trigger name update_salary?

901

---

How do I create a memory optimized filegroup?

700

---

Do we need commit after truncate?

815

---

What is cursor and its types?

716

---

What is a natural join?

735

---

---

Explain the uses of a database trigger?

784

---

How many sql commands are there?

851

---

Where is pl sql used?

681

---

How to convert comma separated string to array in pl/sql?

814

---

Does sql require a server?

715

---

what is the difference between undefined value and null value? : Sql dba

786

---

How many databases can sql express handle?

734

---

what is a trigger? : Sql dba

762

---

What is rank dense_rank and partition in sql?

756

---

Which data type is a composite type?

738

---