🎴 Flashcard Mode
Database Fundamentals: Oracle, PL/SQL, and SQL
Card1 / 17
Mastered0
Review0
QuestionClick to flip
Which two describe a stored procedure?
AnswerClick to flip back
A
A stored procedure is a named PL/SQL block that can accept parameters.
B
A stored procedure is a type of PL/SQL subprogram that performs an action.
💡 Explanation:
Option A is incorrect: stored procedures are written in PL/SQL (not SQL). Option B is correct: stored procedures are named PL/SQL blocks that accept parameters. Option C is correct: stored procedures are PL/SQL subprograms that perform actions. Option D is incorrect: procedures have specification and body, not three parts. Option E is incorrect: the executable section does not return values to the calling environment.