Stored Procedures in SQL Server Quiz

What is the primary purpose of the `CountBooksByAuthor` stored procedure?

• To update the quantity of books by an author

• To print the name of all authors

• To count and display how many books were written by a specific author

• To insert a new author into the database

Why is `CAST` used in the `PRINT` statement of `CountBooksByAuthor`?

• To convert text into date

• To format the author's name

• To convert an integer to a string

• To increase performance

What SQL command is used to run a stored procedure?

• CALL

• RUN

• EXEC

• LAUNCH

Which variable stores the number of books in `CountBooksByAuthor`?

• @Author

• @BookCount

• @BookID

• @Quantity

What is the output of the following command? EXEC CountBooksByAuthor @AuthorName = 'J.K. Rowling';

• A table of books

• A print statement with total books by J.K. Rowling

• A new row in the Books table

• A rollback message

In `BorrowBookTransactionTest`, which SQL feature ensures that both the update and insert must succeed together?

• Index

• Trigger

• Transaction

• Cursor

What happens if an error occurs during the transaction in `BorrowBookTransactionTest`?

• Only the update will be rolled back

• The insert will still happen

• Both actions will be rolled back

• The system will restart

What is the purpose of `GETDATE()` in the stored procedures?

• To return a random number

• To fetch the current system date and time

• To get the due date of the book

• To validate the member

In `BorrowBook`, what happens if the `QuantityAvailable` is already zero?

• A warning is printed

• The book is still borrowed

• The transaction is committed

• An error is raised using THROW

What is the role of `BEGIN TRY...END TRY` and `BEGIN CATCH...END CATCH`?

• To filter results

• To log updates

• To manage errors and handle transactions safely

• To print variable values