engineering computer science MCQ #826

What is the purpose of a 'stored procedure'?

engineering computer science MCQ #826

  1. Question 1

    Q1. What is the purpose of a 'stored procedure'?

    • A) To store data in a database
    • B) To execute a precompiled SQL code that performs a specific task
    • C) To create a new database schema
    • D) To optimize query performance

    Answer: To execute a precompiled SQL code that performs a specific task

    Explanation: Stored procedures encapsulate SQL code, improving performance, security, and reusability by executing precompiled code.