SQL Questions and Answers – SQL Comments

This set of SQL Multiple Choice Questions & Answers (MCQs) focuses on “SQL Comments”.

1. Which of the following correctly defines a stored procedure in SQL?
a) A prepared SQL code which cannot be saved
b) A code that cannot be reused again
c) A code that can be saved and reused over and over again
d) A code that can be stored but cannot be reused
View Answer

2. If we have an SQL query that we write over and over again, which of the following is a better idea to make it less complex?
a) Use logical operators
b) Save it as a stored procedure
c) Write the query as many number of times as we want to execute
d) simplify it by using loops
View Answer

3. We cannot pass parameters to a stored procedure.
a) True
b) False
View Answer

4. What is the syntax to create a stored procedure?
a)

CREATE PROCEDURE procedure_name
AS
Sql_statements
GO;

b)

CREATE PROCEDURE
AS
Sql_statements
GO;

c)

CREATE PROCEDURE procedure_name
Sql_statements
GO;

d)

CREATE PROCEDURE procedure_name
AS
Sql_statements;

CREATE PROCEDURE procedure_name
AS
Sql_statements
GO;

5. Which of the following statement(s) is used to execute a stored procedure?
a) EXECUTE procedure_name;
b) EXE procedure_name;
c) EXEC procedure_name;
d) EXE PROCEDURE procedure_name;
View Answer

EXEC procedure_name;

6. A stored procedure is able to call another stored procedure.
a) True
b) False
View Answer

7. How many parameters can be passed to a stored procedure in SQL?
a) Only one
b) Two
c) Three
d) Any number
View Answer

8. Where the stored procedures are stored in a database?
a) Database data dictionary
b) Database meta data
c) Database server
d) SQL server
View Answer

9. Which of the following statements creates a stored procedure ‘MONEY’ with a parameter ‘note’?
a)

CREATE PROCEDURE money
AS
Sql_statements
GO;

b)

CREATE PROCEDURE money note varchar2(10)
AS
Sql_statements
GO;

c)

CREATE PROCEDURE money @note varchar2(10)
AS
Sql_statements
GO;

d)

CREATE money @note varchar2(10)
AS
Sql_statements
GO;

10. How many SQL statements can be written in a stored procedure?
a) One
b) Two
c) Three
d) Any number
View Answer

Sanfoundry Global Education & Learning Series – SQL.

To practice all areas of SQL, here is complete set of 1000+ Multiple Choice Questions and Answers.

If you find a mistake in question / option / answer, kindly take a screenshot and email to [email protected]