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

Question

MCQ▾

A Database Procedure is stored in the Database

Choices

Choice (4)

a.

As source code

b.

In compiled form

c.

Not stored

d.

Both a. and b. are correct

Answer

d.

Explanation

  • 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: