Qtr No. 213, New Town Yehlanka Indore 454775
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
  To get all Infosys Certified Backend Layers Developer Exam questions Join Telegram Group https://rebrand.ly/lex-telegram-236dee
            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, 4 Nov 2025