Previous

Next

Knowledge check

Completed

1.

Suppose someone runs this T-SQL batch script to insert three rows. After execution they get an error, how many rows will be created? INSERT INTO HumanResources.PossibleSkills (SkillName, Category, Credit) VALUES('Database Administration', 'IT Professional', 5);INSERT INTO HumanResources.PossibleSkills (SkillName, Category, Credit) VALUES('C#.NET', 'Developer', 4);INSERT INTO HumanResources.PossibleSkills (SkillName, Category, Credit) VALUES('Project Management', 'Management', 'Two');GO

0

1

2

2.

Someone wants to populate a table by creating 15 new rows. Before they create the rows, they need to check that the table exists. From the following T-SQL keywords, which one will they need to use?

IF

WHILE

INSERT

3.

Can a variable be declared in one batch and referenced multiple batches?

Yes

No

Sometimes

You must answer all questions before checking your work.

Continue