Question

using sql answer the following i need to double check my answers

Question 1

1. Controls the flow of execution based on a condition

   		begin...end
   		try...catch
   		goto
   		if...else

10 points

Question 2

1. Changes the database context to the specified database.

   		set
   		alter
   		exec
   		use

10 points

Question 3

1. Exits the innermost WHILE loop.

   		goto
   		quit
   		return
   		break

10 points

Question 4

1. Controls the flow of execution when an error occurs

   		declare
   		on error goto
   		try...catch
   		continue...error

10 points

Question 5

1. Declares a local variable.

   		set
   		declare
   		let
   		var

10 points

Question 6

1. Statements that must be run in their own batch.(can have multiple answers)

   		create view
   		create trigger
   		create schema
   		create function
   		create table
   		create procedure

10 points

Question 7

1. To signal the end of a batch use the ____ command.

   		end
   		quit
   		stop
   		go

10 points

Question 8

1. If you create a database within a script, you have to execute the batch that contains the Create Database statement before you can execute other statements that refer to the database.

   True

   False

10 points

Question 9

1. If you need to store variables within a script, you can store them in:(choose all that apply)

   		global variables
   		scalar variables
   		temporary variables
   		vector variables
   		table variables

10 points

Question 10

1. Use the ____ cmd to create a variable and the ____ cmd to assign it a value.

   		set, declare
   		var, set
   		declare, let
   		declare, set

10 points

Question 11

1. A scalar variable can contain multiple values at the same time.

   True

   False

10 points

Question 12

1. The name of a variable must always begin with

   		a letter
   		var_
   		@
   		#

Answer 1

Please Note: I have answered the first 4 questions as per the Chegg Answering Guidelines. Please re-post for the rest of the questions.

Answers)
Question 1
Answer)
if...else - Controls the flow of execution based on a condition
if else is related to the conditions checking and control the flow of the executing of the if statements or else statements based on the condition.

Question 2
Answer)
use - is the statement which is used to change the database context to the specified database.

Question 3
Answer)
break -. break statement causes the exit from the innermost while loop.

Question 4
Answer)
try...catch - are the statements which control the flow of execution when an error occurs.