Which of the following scenario makes use of BEGIN..END keyword redundant?

SQL Server - Quiz(MCQ)

when an IF statement controls the execution of multiple Transact-SQL statement

when an IF statement controls the execution of only one Transact-SQL statement

when an IF statement controls the execution of one or more Transact-SQL statement

None of the above

Correct Answer : when an IF statement controls the execution of only one Transact-SQL statement

Explanation : Use the BEGIN and END statements anywhere a control-of-flow statement must execute a block of two or more Transact-SQL statements.

Recently Updated in SQL Server Questions

Which of the following system database occupies more space and memory?

Msdb

Model

Master

Tempdb

Correct Answer : Master

Explanation : The master database records all of the system level information for a SQL Server system.

Which database is used as template for all databases?

Master

Tempdb

Northwind

Model

Correct Answer : Model

Explanation : When a CREATE DATABASE statement is issued, the first part of the database is created by copying in the contents of the model database.

Which of the following database is used by SQL Server Agent?

Pubs

Msdb

Model

Tempdb

Correct Answer : Msdb

Explanation : The msdb database is used by SQL Server Agent for scheduling alerts and jobs, and recording operators.

New Technologies MCQ's

Machine Learning

Artificial Intelligence