What would be the output when the following SQL scripts gets executed?

CREATE TABLE Roles
(
	RoleId INT PRIMARY KEY IDENTITY(1000,2),
	RoleName VARCHAR(50) UNIQUE NOT NULL
)
GO

INSERT INTO Roles VALUES ('Admin')
GO

SET IDENTITY_INSERT Roles ON
INSERT INTO Roles(RoleId,RoleName) VALUES (1100,'HR')
SET IDENTITY_INSERT Roles OFF

DELETE FROM Roles
SELECT @@IDENTITY
GO

 

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