Explanation:The conditional statements supported by SQL include if-then-else statements by using this syntax.elif and elsif are not allowed. 8. A stored procedure in SQL is a___________.
A. Block of functions
B. Group of Transact-SQL statements compiled into a single execution plan.
C. Group of distinct SQL statements.
D. None of mentioned
Answer:A
Explanation:The conditional statements supported by SQL include if-then-else statements by using this syntax.elif and elsif are not allowed. 8. A stored procedure in SQL is a___________.
A. Block of functions B. Group of Transact-SQL statements compiled into a single execution plan. C. Group of distinct SQL statements. D. None of mentioned
Explanation:If it a atomic statement then the statements are in single transaction. 9. Temporary stored procedures are stored in _________ database.