Consider the following procedure

CREATE PROCEDURE Test
(
	@Id INT OUTPUT, 
	@Name VARCHAR(10)
) 
AS 
BEGIN 
	SET @Id=10 
	SET @Name='James' 
END 

What will be the output after executing the following statements?

DECLARE @Name VARCHAR(10)='Tom' 
DECLARE @Id INT 
EXEC Test @Id OUTPUT, @Name 
SELECT @Id, @Name

10 James
10 NULL
10 Tom
NULL Tom
Verified Answer
Correct Option - c

To get all Infosys Certified Backend Layers Developer Exam questions Join Telegram Group https://rebrand.ly/lex-group-70b557

Telegram

We're passionate about offering best placement materials and courses!! A one stop place for Placement Materials. We daily post Offcampus updates and Placement Materials.

Qtr No. 213, New Town Yehlanka Indore 454775

admin@prepflix.in

Updated on Tue, 16 Sept 2025