70-465 Question #136: Real Exam Question with Answer & Explanation

Question

You use SQL Server 2014. You need to create a single object that inserts a provided value into Table1, and then returns a count of the records in Table1. Develop the solution by selecting and arranging the required code blocks in the correct order. You may not need all of the code blocks. Answer:

Options

• AEND
• BCREATE FUNCTION dbo.Func_Table1 @InsertWord Varchar(10), @var1 INT OUTPUT AS BEGIN
• CCREATE PROCEDURE dbo.Spr_Func_Table1 @InsertWord Varchar(10), @var1 INT AS BEGIN
• DSelect @var1 = count(*) FROM Table1
• EDeclare @var1 INT
• FCREATE PROCEDURE dbo.Spr_Table1 @InsertWord Varchar(10), @var1 INT OUTPUT AS BEGIN
• GINSERT INTO TABLE1 (FIELD1) values (@InsertWord);