Answer Posted / roopesh kumar

Diff. B/W Procudure & Func......
(1) Proc. may or may not return value or more than one.
but func. must return a single value.
(2) We can call a func. in a select stmt. but func. should
only with IN parameter.
But we can't call a procedure inside a selct stmt.
because calling a procedure itself a PL/SQL block.

There is no too much diff. b/w proc. & func. but the thing
is that when we are looking to get back a single value we
should use func. in case of more than one then we should go
for proc.

Diff. b/w proc. & trigger..

(1) We have to call a proc. explicitly but trigger will
fire implicitly with assosiated event.

What is the difference between delete and truncate commands?

1032

---

What are the three forms of normalization?

1040

---

How do you create a unique index?

1044

---

Explain the uses of control file.

1044

---

Is sql difficult?

1148

---

Is sql better than excel?

1139

---

What is a data manipulation language?

1019

---

How many types of triggers are there in pl sql?

1063

---

How do I remove sql developer from windows 10?

1099

---

What is a composite primary key?

1083

---

What is duration in sql profiler trace?

1072

---

What is the use of sqlerrd 3?

936

---

what are integrity rules?

1020

---

What is dml and ddl?

946

---

What are the ddl commands?

1005

---