Consider the below SQL statements

CREATE TABLE Dancer
(
	DancerId INT PRIMARY KEY IDENTITY(1,2),
	Name VARCHAR(100)
)

INSERT INTO Dancer VALUES ('Priya')
INSERT INTO Dancer VALUES ('Riya')

SET IDENTITY_INSERT Dancer ON
DELETE FROM Dancer WHERE DancerId = 2
INSERT INTO Dancer VALUES ('Linza')
SET IDENTITY_INSERT Dancer OFF

INSERT INTO Dancer VALUES ('Shreya')

What will be the value of identity for the last inserted row?

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