Qtr No. 213, New Town Yehlanka Indore 454775
Assume that the below table Course got created successfully.
CREATE TABLE Course
(
CourseId INT PRIMARY KEY IDENTITY(100,1),
CourseName VARCHAR(100) UNIQUE NOT NULL
)
Which of the following option helps to get the below mentioned output?
| CourseId | CourseName |
|---|---|
| 100 | C# |
| 10 | EF |
| 101 | SQL |
INSERT INTO Course VALUES ('C#')
INSERT INTO Course (CourseId,CourseName) VALUES (10,'EF')
SET IDENTITY_INSERT Course OFF
INSERT INTO Course VALUES ('SQL')
INSERT INTO Course VALUES (100,'C#') SET IDENTITY_INSERT Course ON INSERT INTO Course (CourseId,CourseName) VALUES (10,'EF') SET IDENTITY_INSERT Course OFF INSERT INTO Course VALUES (101,'SQL')
INSERT INTO Course VALUES ('C#')
SET IDENTITY_INSERT Course ON
INSERT INTO Course VALUES (10,'EF')
SET IDENTITY_INSERT Course OFF
INSERT INTO Course VALUES ('SQL')
INSERT INTO Course VALUES ('C#')
SET IDENTITY_INSERT Course ON
INSERT INTO Course (CourseId,CourseName) VALUES (10,'EF')
SET IDENTITY_INSERT Course OFF
INSERT INTO Course VALUES ('SQL')
To get all Infosys Certified Backend Layers Developer Exam questions Join Telegram Group https://rebrand.ly/lex-group-70b557
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 Mon, 15 Sept 2025
