Quiz for Executing Stored Procedures

Q1: Which command is used to execute a stored procedure in MySQL?

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

Q2: How do you call a stored procedure in MySQL?

A. CALL proc_name(); B. RUN proc_name(); C. EXECUTE proc_name; D. PERFORM proc_name();

Q3: Which keyword is used to execute a stored procedure in SQL Server?

A. EXEC B. PERFORM C. RUN D. BEGIN

Q4: What is the correct syntax to execute a stored procedure with parameters in MySQL?

A. CALL proc_name(param1, param2); B. RUN proc_name WITH (param1, param2); C. EXEC proc_name VALUES (param1, param2); D. PERFORM proc_name USING param1, param2;

Q5: In which database system is "CALL" used to invoke a stored procedure?

A. Oracle B. MySQL C. PostgreSQL D. SQLite

Q6: What does EXEC do in SQL Server?

A. Executes SQL scripts B. Starts a transaction C. Executes a stored procedure D. Declares a variable

Q7: Which command is used to execute a stored procedure in PostgreSQL?

A. CALL B. SELECT proc_name(); C. EXEC D. RUN

Q8: What is the output of a stored procedure?

A. Always a table B. Always a message C. Depends on the procedure D. Always a boolean

Q9: How are output parameters returned from a stored procedure?

A. Using RETURN B. Using SELECT C. Using OUT parameters D. Using PRINT

Q10: Can a stored procedure be executed without parameters?

A. No B. Yes C. Only in Oracle D. Only in SQL Server

Q11: Which delimiter is used in MySQL when creating or calling procedures?

A. // B. ; C. $$ D. &&

Q12: Which client command is used to execute a stored procedure from a script?

A. RUN B. CALL C. EXEC D. SOURCE

Q13: Can stored procedures be executed inside triggers?

A. Yes B. No C. Only in SQL Server D. Only in Oracle

Q14: What will happen if the number of arguments in CALL does not match the definition?

A. Procedure executes with NULLs B. Error will be thrown C. Only matching parameters are passed D. It executes silently

Q15: How do you execute a procedure in Oracle?

A. CALL proc_name; B. BEGIN proc_name; END; C. RUN proc_name(); D. EXECUTE PROCEDURE proc_name

Q16: Which tool is commonly used to execute stored procedures?

A. SQL client B. File editor C. Web browser D. Excel

Q17: What is the role of the RETURN keyword in stored procedures?

A. It returns a value B. It exits the procedure C. Both A and B D. It starts a procedure

Q18: How do you execute a procedure that returns a result set?

A. Use SELECT * FROM procedure B. Use EXECUTE procedure C. Use CALL procedure() D. Use FETCH procedure

Q19: What does CALL do if procedure name is incorrect?

A. Ignores error B. Creates a new procedure C. Throws an error D. Tries alternate procedure

Q20: Can stored procedures return multiple result sets?

A. Yes B. No C. Only in MySQL D. Only in SQL Server

Q21: Is it possible to nest stored procedures?

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

Q22: Which of the following is true about stored procedure execution?

A. Faster than SQL queries B. Executed once at compile time C. Precompiled and reusable D. Cannot accept parameters