TERTIARY AND VOCATIONAL EDUCATION COMMISSION
COMMON PRACTICAL EXAMINATION – 2020
All rights reserved
NVQ Level 06 - Semester I
Information and Communication Technology
Configure middleware, application
servers and third-party software K72T001M13 Two Hours
components I- Practical
Question [100 Marks]
Prerequisites:-
SQL Server Database any newest version.
Visual Studio any newest version.
Microsoft IIS Server.
Develop web service application and web site to insert and retrieve student details of ABC
institute. Please go through following instructions before develop the applications.
1) Create database name as “Student” and table name as “Student_Detail” with
following columns. [05 Marks]
Column Name Data Type
StudentId Int(Set Identity=true)
StudentName Varchar(20)
Age Int
2) Create web service application name as “studentwebservice”. [05 Marks]
3) Write two web methods for insert student details and retrieve student details. Name of
those two web methods as Add_Student and Get_Student. [20 Marks]
4) Configure connection strings setting on web.config file. [10 Marks]
1 of 2
COMMON PRACTICAL EXAMINATION – 2020
All rights reserved
NVQ Level 06 - Semester I
Information and Communication Technology
Configure middleware, application
servers and third-party software K72T001M13 Two Hours
components I- Practical
Question [100 Marks]
Prerequisites:-
SQL Server Database any newest version.
Visual Studio any newest version.
Microsoft IIS Server.
Develop web service application and web site to insert and retrieve student details of ABC
institute. Please go through following instructions before develop the applications.
1) Create database name as “Student” and table name as “Student_Detail” with
following columns. [05 Marks]
Column Name Data Type
StudentId Int(Set Identity=true)
StudentName Varchar(20)
Age Int
2) Create web service application name as “studentwebservice”. [05 Marks]
3) Write two web methods for insert student details and retrieve student details. Name of
those two web methods as Add_Student and Get_Student. [20 Marks]
4) Configure connection strings setting on web.config file. [10 Marks]
1 of 2
