Multiple choice technology databases

Which database objects can a stored procedure create?

  1. View

  2. Index

  3. Default

  4. Extended stored procedure
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Stored procedures can execute DDL commands and create various database objects. While stored procedures can technically create views, defaults, and extended procedures, creating indexes within stored procedures is particularly common for maintenance tasks, performance optimization, and automated index management operations.

Keep practicing — related questions