Answer Posted / nannesaheb chinthalacheruvu

Procedure :
->Procedure is a Named PL/SQL Block which can be stored in
Database in compile form.
->Procedure is used to execute the Perticular task.
->Procedure Does not required RETURN clause.
->Procedure Does not Return value
->It is not posible to execute using SQL statements.
->Procedures can be execute using a)Execute/Call,b)Anonymous
Block

Function :
->Function is a Named PL/SQL Block Which can be Stored in
Database in Compile Form.
->Function is used for Calculation Perpose.
->Fuction Does Contains RETURN Type
->Fuction Can Return only One Value.
->Fuction can Execute using SQL Statements when We can not
Perform any DML Operations in Function.
->Using Out Mode Parameters we can Return Multiple Records
in Function.

explain normalization concept? : Sql dba

582

---

How can triggers be used for the table auditing?

590

---

What is the difference between the implicit and explicit cursors?

519

---

Why stored procedure is faster than query?

513

---

What is the difference between count 1 and count (*) in a sql query?

491

---

---

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

592

---

Does view store data in sql?

525

---

What is trigger in sql and its types?

528

---

what is bcp? When is it used?

574

---

What are aggregate and scalar functions?

520

---

What are the two parts of design view?

575

---

what is foreign key? : Sql dba

579

---

What program will open a mdb file?

491

---

Can a varchar be a primary key?

532

---

Why do we use joins in sql?

496

---