Quiz for Stored Procedure Basics

Q1: What is a stored procedure in SQL?

A. A table that holds logs B. A compiled SQL statement that runs in background C. A saved set of SQL statements D. An index structure

Q2: What is a stored procedure?

A. A SQL script stored in the database B. A client-side function C. A hardware component D. A data type

Q3: Which SQL command is used to create a stored procedure?

A. CREATE FUNCTION B. CREATE PROCEDURE C. DEFINE PROCEDURE D. INIT PROCEDURE

Q4: Which keyword is used to execute a stored procedure?

A. EXECUTE B. CALL C. PERFORM D. RUN

Q5: What is a benefit of using stored procedures?

A. Improved performance B. Better security C. Code reuse D. All of the above

Q6: Can a stored procedure return values?

A. No B. Only in some databases C. Yes, using OUT parameters D. Only if it is a function

Q7: Which keyword defines a parameter that receives a value in a stored procedure?

A. IN B. OUT C. RETURN D. INPUT

Q8: What does DELIMITER do in MySQL while creating procedures?

A. Ends a transaction B. Changes statement delimiter temporarily C. Marks the start of a loop D. Defines output

Q9: Which of the following can be part of a stored procedure?

A. IF-ELSE logic B. Loops C. SQL queries D. All of the above

Q10: Which of the following is NOT true about stored procedures?

A. They can be reused B. They always return a value C. They reduce code duplication D. They can be modified easily

Q11: What is used to end a stored procedure definition in MySQL?

A. COMMIT B. END; C. END PROCEDURE; D. END STATEMENT;

Q12: What happens when a stored procedure is altered?

A. It is dropped automatically B. It requires recompilation C. It becomes invalid D. It updates immediately

Q13: Which of the following databases supports stored procedures?

A. MySQL B. Oracle C. PostgreSQL D. All of the above

Q14: Can a stored procedure be called inside another procedure?

A. No B. Only in Oracle C. Yes D. Only in MySQL

Q15: Which is faster for repeated execution: stored procedure or dynamic SQL?

A. Stored procedure B. Dynamic SQL C. They are same D. Depends on database

Q16: Which of these is NOT a parameter mode in stored procedures?

A. IN B. OUT C. INOUT D. INLINE

Q17: What is the default parameter mode in a stored procedure?

A. OUT B. IN C. INOUT D. VAR

Q18: Which clause is required to remove a stored procedure?

A. REMOVE PROCEDURE B. DROP PROCEDURE C. DELETE PROCEDURE D. UNINSTALL PROCEDURE

Q19: Which language is typically used inside stored procedures?

A. Python B. SQL C. Java D. XML

Q20: What is a recursive stored procedure?

A. Procedure that deletes itself B. Procedure that modifies tables C. Procedure that calls itself D. Procedure with triggers

Q21: Can stored procedures improve application security?

A. Yes B. No C. Only on Oracle D. Only with triggers