Database-MySQL [3i Infotech Placement]: Sample Questions 64 - 64 of 162

Glide to success with Doorsteptutor material for competitive exams : get questions, notes, tests, video lectures and more- for all subjects of your exam.

Question 64



A Database Procedure is stored in the Database


Choice (4)


As source code


In compiled form


Not stored


Both a. and b. are correct




  • A procedure is named PL/SQL block which performs one or more specific task.
  • It is similar to a procedure in other programming language.
  • A procedure shared a number of programs.
  • It is also helpful in controlling access to data, preserving data integrity.
  • We use compiler form for compiling procedure.
  • We can view the source code of a function or a procedure by using data dictionary view.
  • Apply all_source view to get a list of all of the source code.

    SELECT text

    FROM all_source

    WHERE name = your_function_Name

    ORDER BY line;

  • A stored procedure is a group of one or more database statement stored in the database data dictionary.

Main parts of stored procedure:

  • Input
    • Store procedure can accept parameter value as input
  • Execution
    • Store procedures can execute SQL statement
  • Output
    • A stores procedure can return a single value as a number or text value.
Main Parts of Stored Procedure

Benefit of stored procedures:

  • Network efficiency
  • Encapsulate business logic
  • Maintainable
  • Stronger security

Developed by: