Topics for Junior Programmer
(For Online Computerized Test)
Sr. No. Topics
1. ASP .Net
2. Visual Basic
3. JAVA
4. Programming in C/C++
5. MS Office
6. Internet, HTML/DHTML
7. Windows & Computer Fundamentals
8. Networking
9. System Analysis & Design
10. Hardware concept
11. Operating System
12. DBMS
Programming/Practical Test will be conducted only if the applicant qualifies the
online computerized test.
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:-
a. Agent_Master
Field Name DataType Remarks
Agent_No Integer Primary Key (AutoNumber)
Agent_Name Varchar
b. 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
2. Make at least 5 manual entries in master table Agent_Master.
3. 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.
4. Display Report as below:
Agent Policy Date Policy Amount Commission
Note: Incorporate proper Checks & Validations.