Programming/Practical Test will be conducted only if the
applicant qualifies the online computerized test.
SAMPLE PAPER : Programming Test. Time:90 Min
Category: System Analyst
ABC company records data relating to insurance agents and
customers. Create a database and GUI to save data relating to
the Agents and Customers. The complete details relating to the
policies is to be captured like policy no., date, customer name,
policy amount, commission earned by the Agent. The commission
percentage for agent is fixed different type of schemes and to be
calculated automatically, as per the Scheme selected by the
Customer and the Policy amount.
Show reports regarding detail of Policies done by agents between
two dates and detail of commission earned by agents.
SAMPLE PAPER : Programming Test. Time:90 Min
Category: Programmer
ABC company records data relating to insurance agents and customers. Following are the type of
schemes available and commission percentage, schemewise, for agent:
Name of the Scheme Commission to Agent
1. A 2%
2. B 2.7%
3. C 3.3%
1. Create an application to save data relating to the agents and customers using the following
database tables:-
a. Agent_Master
Field Name DataType Remarks
Agent_No Integer Primary Key (AutoNumber)
Agent_Name Varchar
b. Scheme_Master
Field Name DataType Remarks
Scheme_no. Integer Primary Key (AutoNumber)
Scheme_Name Varchar
Commission Decimal As per detail mentioned above
c. Policy_Details
Field Name DataType Remarks
Policy_No Integer Primary Key (AutoNumber)
Date1 Date
Scheme_no. Integer Foreign Key
Agent_No Integer Foreign Key
CustomerName Varchar
Policy Amount Integer
Commission Decimal To be calculated automatically from
Scheme Master
2. Make at least 5 manual entries in master table Agent_Master and 3 entries in Scheme_Master.
3. Create a GUI to save data in Policy_Details table as per the conditions mentioned above. Use
dropdownlist to display Scheme and Agent.
4. Reports:
a. The detail of Policies done by agents:
Agent Scheme No. of policies.
a. The detail of commission earned by agents:
Agent Commission
Note: Incorporate proper Checks & Validations.
SAMPLE PAPER : Programming Test. Time:90 Min
Category: Junior Programmer
1. Create an application to save data of the insurance agents and customers
of ABC Company using the following database tables:-
2.
a. Agent_Master
Field Name DataType Remarks
Agent_No Integer Primary Key
(AutoNumber)
Agent_Name Varchar
d. Policy_Details
Field Name DataType Remarks
Policy_No Integer Primary Key (AutoNumber)
Agent_No Integer Foreign Key
PolicyDate Date
CustomerName Varchar
PolicyAmount Integer
Commission Decimal To be calculated
automatically
5. Make at least 5 manual entries in master table Agent_Master.
6. Create a GUI to save data in Policy_Details table as per the conditions
mentioned below:-
Policy Amount Commission to Agent
<10000 2%
>10000 2.5%
Use dropdownlist to display Agents.
7. Display Report as below:
Agent Policy Date Policy Commission
Amount
Note: Incorporate proper Checks & Validations.
Sample /Brief Note for Practical Paper of Networking Engineer
Practical Paper of Networking Engineer is meant to assess the capability
of the candidates in terms of hands on knowledge on the following:-
(i) Computers Hardware Structure
(ii) Networking Designing
(iii) Networking Components
(iv) Hardware (Computers, Printers, UPS, Servers, IT Products etc)
maintenance
(i) The candidate knowledge will be tested on structural aspects of
Hardware.
a) Functioning of various parts of computers
b) Assembling of Computers
c) Identification, Installation & Inspection of Hardware Components
(ii) Networking Designing: - Designing of networks like LAN, WAN etc. both
technological aspects and installation of networking components
required for the network.
(iii) The identification, installation, inspection and usage of various
networking components like type of switches, routers, UTP/STP/fiber
cable, patch panel.
(iv) Hardware maintenance issues like MTBF, product life identification &
rectification faults etc.
Sample /Brief Note for practical Paper of Networking Assistant
Practical Paper of Networking Assistant is meant to assess the capability
of the candidates in terms of hands on knowledge on the following:-
(i) Computers Hardware Structure
(ii) Networking Components
(iii) Hardware (Computers, Printers, UPS, Servers, IT Products etc
maintenance)
(i) The candidate knowledge will be tested on structural aspects of
Hardware.
a) Functioning of various parts of computers
b) Assembling of computers
c) Identification Installation & Inspection of hardware components
(ii) The identification, installation, inspection and usage of various
networking components like type of switches, routers, UTP/STP/fiber
cable, patch panel.
(iii) Hardware maintenance issues like identification & rectification faults for
Computers, Printers, UPS systems etc.
