Can you assign Variables in the DECLARE statement? a. Yes b. No Which is the correct way to Declare a Table Variable. a. DECLARE @Table Variable   b. DECLARE @Table Variable TABLE   c. DECLARE @Table...

Can you assign Variables in the DECLARE statement?

a. Yes b. No

Which is the correct way to Declare a Table Variable.

a. DECLARE @Table Variable

b. DECLARE @Table Variable TABLE

c. DECLARE @Table Variable TABLE (TB_ID INT)

d. DECLARE TABLE INT @Table Variable

e. DECLARE @Table Variable = TABLE

What statement is used to populate a Table Variable?

a.  SELECT

b.  SET

c.  RETURN

d.  INSERT

e. DECLARE

Which of the following characters can be used in a Variable name?

a. !

b. %@

c. #

d. &

e. None of the above

How many values can be stored in a Scalar Variable?

a. 1   b. 2   c. 3  d. 4  e. 5