Question

Answer the following questions so I can double check my work

Controls the flow of execution based on a condition

begin...end

try...catch

goto

if...else

10 points   

QUESTION 2

Changes the database context to the specified database.

set

alter

exec

use

10 points   

QUESTION 3

Exits the innermost WHILE loop.

goto

quit

return

break

10 points   

QUESTION 4

Controls the flow of execution when an error occurs

declare

on error goto

try...catch

continue...error

10 points   

QUESTION 5

Declares a local variable.

set

declare

let

var

10 points   

QUESTION 6

Statements that must be run in their own batch.

create view

create trigger

create schema

create function

create table

create procedure

10 points   

QUESTION 7

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

end

quit

stop

go

10 points   

QUESTION 8

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

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

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

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

10 points   

QUESTION 12

The name of a variable must always begin with

a letter

var_

@

#

Answer 1

1.D = If and Else

we can control the FLow of Execution with the Help of the IF and ELSE conditions.

2. = Alter

The ALTER is the Command in the Database that will help to change or Modify the Content In the Database.

3.D = Break.

With the Help of the Break Statment, we can easily exit from the While Loop.

4. C = Try Catch

The Try Catch is the Method that can control the Flow of Execution when an Error occurs.

5. D = VAR

VAR is the Short Term of Variable and that helps for the Initializing of the Global Variable.

6.A = CREATE VIEW

Create View is the statement that must be run in their own batch.

7.A = END

END is the Signal command that will help to signal the end of the batch.

8.True

Yes.

If we 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.

9. A and C = Global Variable and Temporary Variable

We need Global Variables and Temporary Variable to store the variable in a script.

10.B = Var and SET

Var and SET are the Commands to Create and Declare the Variables.

11.A = A letter.

The Name of the Variable can Be Begin With the letter.