Which of the following is the correct basic syntax to create a procedure named GetUsers without parameters?

easy📝 Syntax Q12 of 15

SQL - Stored Procedures and Functions

Which of the following is the correct basic syntax to create a procedure named GetUsers without parameters?

ACREATE PROCEDURE GetUsers AS SELECT * FROM Users;

BCREATE PROCEDURE GetUsers BEGIN SELECT * FROM Users; END;

CCREATE PROCEDURE GetUsers() BEGIN SELECT * FROM Users; END;

DCREATE PROCEDURE GetUsers SELECT * FROM Users;

Step-by-Step Solution

Solution:

Step 1: Recall standard procedure syntax
The correct syntax includes parentheses for parameters (empty if none), and a BEGIN...END block to enclose statements.
Step 2: Check each option
CREATE PROCEDURE GetUsers() BEGIN SELECT * FROM Users; END; correctly uses CREATE PROCEDURE GetUsers() BEGIN SELECT * FROM Users; END;. Options A, C, and D miss parentheses or BEGIN...END or have syntax errors.
Final Answer:
CREATE PROCEDURE GetUsers() BEGIN SELECT * FROM Users; END; -> Option C
Quick Check:
Procedure syntax needs () and BEGIN...END = B [OK]

Quick Trick: Always use () and BEGIN...END in procedure syntax [OK]

Common Mistakes:

Master "Stored Procedures and Functions" in SQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More SQL Quizzes