1.

xd;Wlndhd;W njhlu;GilaJk; xOq;fikf;fg;gl;lJkhd juTj;jsnkhd;wpd;

njhFg;gpid ................... vd toq;fyhk;. ntw;wplj;jpy; tuNtz;ba gjk;
gpd;tUtdtw;wpy; vJ?
1) juTr; Nrfupg;G 2) rpwe;j juTj;jsk; 3) njhlu;Gepiyj; juTj;jsk;
4) ml;ltiz 5) juT
2. njhlu;Gepiyj; juTj;jsnkhd;wpd; gpujhd gFjpfs;
1) ml;ltiz> gjpT> jfty;
2) ml;ltiz> tupir> Gyk;
3) juT> Kiwtop> jfty;
4) gjpT> tupir> Gyk;
5) gjpT> Gyk;> epuy;
3. xU ml;ltizapy; epuyhfTk; xU gz;ghfTk; miktJ
1) Gyk; 2) epiu 3) juT 3) tupir 5) gjpT
4. xU ml;ltizapy; gjpT (Row / Record / Tuple) vd;gJ
1) juTj;js ml;ltizapd; epiu my;yJ gjptwpf;ifapidf; Fwpf;Fk;
2) gjptwpf;ifapd; gz;gpidf; Fwpf;Fk; (attribute)
3) Kjd;ikr; rhtpiaf; Fwpf;fpwJ
4) me;epar; rhtpiaf; Fwpf;fpwJ
5) ml;ltizapd; kWngau;
5. xU ml;ltizapd; epiy (Degree) vd;gJ
1) gjpTfspd; vz;zpf;if 2) Gyq;fspd; epiy 3) Gyq;fspd; vz;zpf;if
4) gjpTfspd; epiy 5) fzf;fply;
6.

khztd; fzpdp

njhlu;G epiy ml;ltiznahd;wpy; fhzg;gLk; cs;nghUs;fs; NkNy

fhl;lg;gl;Ls;sJ. xU khztDf;F xU fzpdp tPjk; fzpdp Ma;T $lnkhd;wpy;
toq;fg;gLfpwJ. Mdhy; xU fzpdpia NtW re;ju;g;gj;jpy; NtW khztu;fSk;
gad;gLj;Jtu; vdpd;> ,j; njhlu;GlikahdJ
1) xd;W-xd;W 2) xd;W – gy 3) gy – gy 4) $wKbahJ 5) VJTkd;W
7. njhlu;Gepiy ml;ltiznahd;wpd; ,ay;Gfshtd
a. ngau; (jdpj;Jtj;ij mwpa)
b. epiy (Degree) – Gyq;fspd; vz;zpfif
c. fzf;fply; (cardinality) ml;ltizapypUf;Fk; gjpTfspd; vz;zpf;ifiaf;
Fwpf;Fk;
Nkw;$wpa $w;Wf;fspy;
1) A khj;jpuk; cz;ik 2) B khj;jpuk; cz;ik 3) B khj;jpuk; cz;ik
4) A,B khj;jpuk; cz;ik 5) A,B,C Mfpa vy;yhk; cz;ikahdJ.

8. juTj; js nkd;nghUshff; fhzg;gLgit

1) My SQL 2) Oracle 3) Access 4) MS SQL Server 5) Nkw;$wpa ahTk;
9. juTj; js Kiwikapd; gpujhd $W my;yhjJ
1) juT 2) epiu 3) td;nghUs; 4) nkd;nghUs; 5) gadu;
10. xU juTj; js ml;ltizapd; gjpTfisj; jdpj;J milahsk; fhzg; gad;gLk;
Gyk; gpd;tUkhW miof;fg;gLk;.
1) jdpg;Gyk; 2) jdpr; rhtp 3) Kjd;ikr; rhtp
4) me;epar; rhtp 5) Nru;khdr; rhtpfs;
11. xU juTj;js ml;ltizapy; Kjd;ikr; rhtpahff; fhzg;gLk; xU Gyk; gpwpNjhu;
ml;ltizapy; Xu; Gykhf ,Ug;gjpd; mJ gpd;tUkhW miof;fg;gLk;
1) jdpg;Gyk; 2) jdpr; rhtp 3) Kjd;ikr; rhtp
4) me;epar; rhtp 5) Nru;khdr; rhtpfs;
12. cUnghUs; njhlu;G (Entity Relationship)ml;ltizapy; gad;gLj;jg;glhj FwpaPL
1) 2) 3)

4) 5)

jpfjp
13.
khztu; gpwe;j
jpfjp njh.,y
ngau;

khztu; gad;ghL fzpdpfs;

khztu;
Kftup ,y tif
gpd;tUk; $w;Wf;fisf; fUJf.
A – khztu;> fzpdpfs; Nghd;wd gz;GfshFk;
B - khztu;> fzpdpfs; Nghd;wd cUnghUs;fshFk;
C – khztu; ,y> khztu; ngau;> gpwe;j jpfjp> Kftup Nghd;wd khztu; vDk;
cUnghUspd; gz;GfshFk;.
Nkw;$wpa $w;Wf;fspy;
1) A khj;jpuk; cz;ik 2) B khj;jpuk; cz;ik 3) B khj;jpuk; cz;ik
4) B,C khj;jpuk; cz;ik 5) A,B,C Mfpa vy;yhk; cz;ikahdJ.

14.

Hours

Student DOB
SP_Name
Name

Student Participa Spots

te

StudentNo
Address Teacher

NkNy fhl;lg;gl;l ER tiuglj;jpw;Fg; nghUj;jkhd njhlu;G Kiwik ahjhf

,Uf;Fk;?
1) xd;W-xd;W 2) xd;W – gy 3) gy – gy 4) $wKbahJ 5) VJTkd;W

Nky; cs;s tpdhtpy; fhl;lg;gl;l ER tiuglj;jpw;Fg; nghUj;jkhd njhlu;G epiy

mikg;G Kiw gpd;tUtdtw;wpy; vJ?
1) Student (StudentNo, StudentName, DOB, Address)
Sports (SP_Name, Teacher)
2) Student (StudentNo, StudentName, DOB, Address)
Sports (SP_Name, Teacher, Hours)
3) Student (StudentNo, StudentName, DOB, Address)
Participate(Hours)
Sports (SP_Name, Teacher)
4) Student (StudentNo, StudentName, DOB, Address)
Participate(StudentNo, SP_Name, Hours)
Sports (SP_Name, Teacher)
5) Student (StudentNo, StudentName, DOB, Address)
Participate(StudentNo, SP_Name, Hours)
Sports (SP_Name, Teacher)

15. xd;Wf;F Nkw;gl;l Gyq;fisf;nfhz;L xU gjptpid jdpj;Jtkhf milahsk;

fhzNtz;Lkhapd; mg;Gyq;fspd; njhFjp
1) Kjd;ikr; rhtp (Primary Key) 2) me;epar; rhtp (Foreign Key)
3) ,ize;j rhtp (Composite Key) 4) Ntl;ghsu; rhtp (Candidate Key)
5) Nkw;$wpa vJTky;y
16. juTj;js nkd;nghUnshd;wpy; juTj;jsk; xd;wpid cUthf;Ftjw;F gad;gLj;jg;gLk;
tpdty;
1) CREATE DATABASE Student_Details
2) CREATE DATABASE Student Details
3) CREATE DATA BASE Student_Details
4) CREATE Student_Details
5) Use DATABASE Student_Details
fPNo jug;gl;l ICTMarks vDk; ml;ltiziag; gad;gLj;jp 16>17 Mfpa
tpdhf;fSf;F tpil jUf.

IndexNo StName Marks

001 Dorisan 65
002 Enos 85
003 Pranavan 63
004 Kunalan 43
005 Kajeevan 38
006 Selvajenogi 49
007 Salini 55

17. 50 my;yJ 50 ,w;F Nkw;gl;l Gs;spfisg; ngw;wtu;fspd; IndexNo Ig; ngWtjw;F

nghUj;jkhd SQL $W
1) SELECT* IndexNo FROM ICTMarks Where Marks >=50
2) SELECT* FROM ICTMarks Where Marks >=50
3) SELECT ICTMarks Where Marks <50
4) SELECT IndexNo FROM ICTMarks Where Marks >50
5) SELECT IndexNo FROM ICTMarks Where Marks >=50
18. 008, Vithusan, 78 vd;w gjptpid ml;ltizap;y; Nru;j;Jf;nfhs;tjw;F nghUj;jkhd
SQL?
1) INSERT INTO ICTMarks (IndexNo, StName, Marks) VALUES (008, ‘Vithusan’, 78)
2) INSERT INTO Marks (IndexNo, StName, Marks) VALUES (008, ‘Vithusan’, 78)
3) INSERT INTO ICTMarks (IndexNo, StName, Marks) VALUES (‘Vithusan’,008, 78)
4) INSERT INTO ICTMarks (IndexNo, StName, Marks) (008, ‘Vithusan’, 78)
5) INSERT ICTMarks (IndexNo, StName, Marks) VALUES (008, ‘Vithusan’, 78)
19. juTj; jsnkhd;wpy; Sports vd;w ml;ltizapid ePf;Ftjw;F nghUj;jkhd SQL
1) DELETE TABLE Sports;
2) DROP TABLE Sports;
3) DELETE Sports;
4) DROP Sports;
5) DROP TABLE Sports FROM Student_Details;
20. nkd;nghUs; mgptpUj;jpapy; gad;gLj;jg;gLk; Kd;khjpup ( Prototype) khjpupak;
rk;ge;jkhd $w;Wf;fSs; gpioahdJ
1) Fiwe;jstpyhd nrytpid vLj;jy;
2) gadu;fspd; mjPj <LghL
3) mjpfsthd fhyj;jpid vLf;fpd;wik
4) gadu; Njitg;ghLfisf; ifg;gw;Wjy; ,yFthdJ
5) Fiwe;jstpyhd gadu; Njitg;ghLfSld; Muk;gpf;f Kbjy;
21. juTj;js Kfhikj;Jtj; njhFjpapd; (Database Management System) gpujhd
njhopyhf mikahjJ
1) juT Nrfupj;jy; (Data Collection)
2) Njf;fp itf;fNtz;ba juTfspd; tif (Type) khjpupak;> vy;iy Kiwtopahf;fk;
3) tpNrl juTfisj; Nju;e;njLj;jy;> juTfis ,w;iwg;gLj;jy;> mwpf;iffisj;
jahu;nra;jy;
4) gad;gLj;Jgtu; juTj;jsj;ijf; ifahs;tjw;F tha;g;ig mspj;jy;
5) Njitaw;w gad;ghLfspypUe;J juTfisg; ghJfhj;jy;
22. njhlu;Gepiy juTj;js tbtikg;gpw;fhf gad;gLj;jg;gLk; ER tiuglj;jpd;
FwpaPLfs; jug;gl;Ls;sd. mtw;wpd; gz;Gfs; KiwNa

A B C
1) Simple attribute, Multi Valued attribute, Derived attribute
2) Multi Valued attribute, Derived attribute, Descriptive attribute
3) Multi Valued attribute, Derived attribute, Composite attribute
4) Composite attribute, Multi Valued attribute, Derived attribute
5) Derived attribute, Stored attribute, Derived attribute

gFjp 1 tpilfs;

1) 3 2) 2 3) 1 4) 1 5) 3 6) 2 7) 5 8) 5 9) 2 10) 3
11) 4 12) 5 13) 4 14) 3 15)3 16) 1 17) 1 18) 1 19) 2 20) 3
21 ) 1 22) 2
1.
a. juTj;js nkhd;nghUspidg; gad;gLj;Jtjpy; cs;s ed;ikfs; 4 jUf.
b. juTj;js ml;ltizapy; Kjd;ikr; rhtpiag; gad;gLj;Jtjd; ed;ik
ahJ?
c. juTj;js epu;thfp xUtupd; nraw;ghLfs; ehd;F jUf.
d. ikag;gLj;jg;gl;Ls;s juTj;jsnkhd;wpy; (Centralized Database) juTfisf;
ifahStjdhy; Vw;gLk; mD$yq;fs;> gpujp$yq;fs; %d;iw jUf?
e. gpd;tUk; ER tupglj;jpd; FwpaPLfisf; fUj;jpw; nfhz;L fPNo jug;gl;Ls;s
,ilntspfis epug;Gf?

T_Id
T_Name No

Teacher Address Street

Subjects

City
Age

I. Teacher vd;gJ xu; ............................................. MFk;.

II. T-Id vd;gJ Xu; ................................................... MFk;.
III. T_Name vd;gJ Xu; ............................................. MFk;.
IV. Subjects vd;gJ Xu; ..................................... MFk;.
V. Age vd;gJ Xu; ........................................... MFk;.
VI. Address vd;gJ Xu; ......................................... MFk;.
2.

a. NkNy fhl;lg;gl;Ls;s ER tupglj;jpy; fhzg;gLk; vy;yhj; njhlu;GilikfisAk;

je;J ckJ tpilia epahag;gLj;Jf.

b. ,t; ER tiuglj;jpy; fhzg;gLk; cs;nghUs;fs;> gz;Gfs;> njhlu;Gilikfs;

ahtw;iwAk; jUf.

c. ,t; ER tiuglj;jpid njhlu;Gepiyj; juTj;jskhf khw;Wf.

d. NkNy jug;gl;l ml;ltizfspd; Kjd;ikr;rhtpfis jUf.

3. Employee

Emp_Id Emp_Name Emp_DOB Emp_Sex Emp_Appointed_Date

Emp_1001 Piraveen 18/05/1983 Male 02/01/2010
Emp_1002 Nisha 26/11/1980 Female 05/04/2001
Emp_1003 Gabilan 05/03/1987 Male 03/01/2014
Emp_1004 Theepan 15/12/1990 Male 03/07/2015
Emp_1005 Raju 25/07/1985 Male 04/09/2009

I. Nkw;gb njhlu;Gilikapy; jug;gl;l juit cUthf;fTk; cs;sPL nra;aTk; SQL

$w;Wf;fis vOJf.
II. Salary vd;Dk; epuiy Nru;g;gjw;fhd SQL $w;iw vOJf.
III. Emp_DOB vd;Dk; epuiy mopg;gjw;F SQL $w;iw vOJf.
IV. Emp_Sex ,y; Female I kl;Lk; tpisthf ngWtjw;fhd SQL $w;iw vOJf?
V. Gjpa ml;ltiznahd;iw cUthf;Ftjw;fhd SQL $w;iw vOJf.
Table Name : Department
Fields : Dep_Id, Emp_Id, Dep_Name, Dep_Head_Name
VI. gpd;tUk; SQL $w;iw epiwNtw;Wifapy; ngwg;gLk; tpisT ahJ?
SELECT EMP_Id, Emp_Name, Dep_Name, Dep_Head_Name
FROM Employee, Department
Where Dep_Name LIKE ‘A*’;

4. itj;jparhiyf;F nry;Yk; Nehahsu;fs; kUj;Jtu;fSf;fhd ER tiuglk; fPNo

fhl;lg;gl;Ls;sJ.
I. ,q;F xt;nthU
U cs;nghUS
ghUSf;Fkhd gz;Gfisj; jUf?
II. xt;nthU cs;nghUS
ghUSf;Fkhd njhlu;Gilikia tiue;J tpsf;Ff.
III. ,J xU jdpahu; kUj;Jtkid vdpd; Payment vd;Dk; cs;nghUis vt;
ld; ,izg;gPu;. ,jw;fhd fhuzj;ij tpsf;Ff.
cs;nghUSld;

5.
I. Customer name, Phone kl;Lk; gl;baw;gLj;Jtjw;fhd SQL $w;iw vOJf
II. Book ISBN, author name vd;gtw;iw ,izj;J vLg;gjw;fhd SQL $w;iw vOJf.
III. 500 &ghtpw;F Fiwe;j Gj;jfq;fisg; gl;baw;gLj;Jtjw;fhd SQL $w;iw
vOJf?
IV. Customer name I VWtupirg;gLj;Jtjw;fhd SQL $w;iw vOJf.
V. Gj;jfj;jpd; tpiy 500 &ghtpw;Fk; 1000 &ghtpw;Fk; ,ilapyhd Gj;jfj;ij
gl;baw;gLj;Jtjw;fhd SQL $w;iw vOJf.
VI. tpiy $ba Gj;jfj;ijAk;> kpfTk; tpiy Fiwe;j Gj;jfj;ijAk; vLg;gjw;fhd
SQL $w;iw vOJf.
VII. author address Jaffna thf kl;Lk; cs;s authorfis gl;baw;gLj;j Njitahd SQL
$w;iw vOJf.
VIII. ‘K’ apy; njhlq;Fk; Gj;jfq;fis gl;baw;gLj;j Ntz;ba SQL $w;iw vOJf.

1.
a. kj
b. hgf
c. gg
d. gf
e. Entity
Primary Key
Attribute
Multi valued Attribute
Derived attribute
Multi valued Attribute

2.
a. 1 M
Customer Places Purchase Order

M M
Purchase Order Refer to Stock Item

1 M
Stock Item Refer to Line Item

1 M
Purchase Order Lists Line Item

b. Entities : Customer, Purchase Order, Stock Item, Line Item

Attributes : Customer_number, Customer_name, street, city, zipcode, phone_number,
p_o_number, Order_date, ship_date, to_street, to_city, to_state, to_zip_code,
stock_item_number, description, price, line_item_number, quantity, discount
Relationship : Places, Refer to, Lists, Refer to

c. Customer (Customer_number, Customer_name, street, city, zipcode, phone_number)

Purchase Order (p_o_number, Order_date, ship_date, to_street, to_city, to_state,
to_zip_code)
Stock Item (stock_item_number, description, price)
Line Item (line_item_number, quantity, discount)

d. Customer (Customer_number)
Purchase Order (p_o_number)
Stock Item (stock_item_number)
Line Item (line_item_number)

3.
I. INSERT INTO Employee (Emp_Id,Emp_name, Emp_DOB, Emp_Sex,
Emp_Appointed_Date) VALUES (‘Emp_1006’,’mala’, '26/08/1984', 'Female',
‘29/05/2015);
II. ALTER TABLE Employee
ADD Salary Number;
III. ALTER TABLE Employee
DROP Emp_DOB;
IV. SELECT *
FROM Employee
WHERE Emp_Sex Like ‘Female’;
V. CREATE TABLE Department
(
Dep_Id char,
Dep_Name varchar(255),
Dep_Head_Name varchar(255),
Emp_Id char
);
VI.
Emp_Id Emp_Name Dep_Name Dep_Head_Name
Emp_1004 Kala Administration Peter

4.
I. Patients: Patient_Id, Patient_name, Sex, Age, Address, Phone_No
Doctor : Doc_Id, Doc_Name, Doc_Age, Doc_Age, Qualification
Assitants : A_Id, A_Name, A_Sex, A_Age, Qualification,
Wards: W_Id, Head, Maintain
II. sf
III. Patients -----> Payment -------> Doctors
Patients paid payment Doctors received Payment
5.
I. SELECT name, Phone
FROM Customer;
II. SELECT author.name, Book.ISBN
FROM author INNER JOIN Book ON author.Author_Id = Book.Author_Id;
III. SELECT *
FROM Book
WHERE Price < 500;
IV. SELECT *
FROM Book
ORDER BY Title;
V. SELECT *
FROM Book
WHERE Price BETWEEN 500 AND 1000;
VI. SELECT MAX (Price)
FROM Book;
SELECT MIN (Price)
FROM Book;
VII. SELECT *
FROM author
WHERE address ='Jaffna';
VIII. SELECT *
FROM Book
WHERE Title Like 'k*';