KyaPoocha.com

Huge Collection of Interview Questions

Search our list of 7708 Interview Questions


What are the two parts of a procedure ? 

Posted in Database Interview Questions

Procedure Specification and Procedure Body. The Same procedure name is repeated with parameters of different datatypes and parameters in different positions, varying number of parameters is called overloading of procedures.e.g. DBMS_OUTPUT put_line

Post Your Answer!
Send This to a Friend

← What is a stored procedure ?
What is an Extent ? →

If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!


BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |

Related Interview Questions

  • How are web parts developed?  28.11.08

    Web parts are developed in Visual Studio .Net. VS.Net offers many web part and page templates and can also be downloaded from the Microsoft site....

  • what is a web part zone?  28.11.08

    Web part zones are what your web parts reside in and help categorize your web parts when designing a page....

  • what is a web part?  28.11.08

    Web parts consist of xml queries to full SharePoint lists or document libraries. You can also develop your own web parts and web part pages....

  • What are the built-ins used for processing rows?  27.05.08

    GET_GROUP_ROW_COUNT(function) GET_GROUP_SELECTION(function) GET_GROUP_SELECTION(function) RESET_GROUP_SELECTION(Procedure) SET_GROUP_SELECTION(Procedure) U...

  • What are the built-ins used for modifying a group structure?  21.05.08

    ADD_GROUP_COLUMN(function) ADD_GROUP_ROW(Procedure) DELETE_GROUP_ROW(Procedure) POPULATE_GROUP(function) POPULATE_GROUP_WITH_QUERY(function) SET_GROUP_CHAR...

  • Why do stored procedures reduce network traffic?  14.05.08

    When a stored procedure is called, only the procedure call is sent to the server and not the statements that the procedure contains....

  • What is Code Coverage?  26.02.07

    An analysis method that determines which parts of the software have been executed (covered) by the test case suite and which parts have not been executed and th...

  • What is a DATABASE trigger ? What is a DATABASE Procedure ?  16.03.06

    A DATABASE TRIGGER is a stored procedure associated with a table that ORACLE7 automatically executes on one or more specified events (BEFORE or AFTER an INSERT,...

  • Difference between procedure and function ?  16.03.06

    Functions are named PL/SQL blocks that return a value and can be called with arguments procedure a named block that can be called with parameter. A procedure al...

  • Differentiate Aggregation and containment?  09.03.06

    Aggregation is the relationship between the whole and a part. We can add/subtract some  properties in the part (slave) side.It won't affect the whole part.Best...