Elméleti kérdések:
sárga háttérrel 5 oszlop 5 vizsgatételhez a min. követelmény (24 pont)
Gyakorlati feladatok: kék háttérrel
(36 pont + H.F. beadott E/K modell + EA_órai_pontok)
Összesen: 60 pont Lekérdezés
(30 p/1-
|
|
|
ápr.11. |
1. |
1.a. |
2. |
2.a. |
3. |
3. |
4. |
4. |
4. |
bead |
1 |
BET |
|
|
|
|
|
|
|
|
|
|
|
|
2 |
CZR |
2 |
25 |
4 |
0 |
4 |
3 |
1 |
3 |
5 |
3 |
0 |
2 |
3 |
FOL |
2 |
25 |
4 |
0 |
5 |
5 |
2 |
2 |
4 |
3 |
0 |
|
4 |
GAB |
2 |
28 |
5 |
0 |
5 |
3 |
4 |
3 |
0 |
3 |
5 |
|
5 |
GAG |
|
|
|
|
|
|
|
|
|
|
|
|
6 |
GAZ |
2 |
25 |
4 |
5 |
5 |
3 |
3 |
3 |
0 |
2 |
0 |
|
7 |
HOA |
5 |
48 |
3 |
3 |
5 |
9 |
4 |
6 |
5 |
5 |
6 |
2 |
8 |
HOZ |
1/2 |
22 |
0 |
2 |
4 |
5 |
2 |
4 |
3 |
1 |
1 |
|
9 |
IHP |
|
|
|
|
|
|
|
|
|
|
|
|
10 |
KAA |
3 |
35 |
2 |
1 |
5 |
0 |
4 |
7 |
5 |
5 |
6 |
|
11 |
KUA |
|
|
|
|
|
|
|
|
|
|
|
2 |
12 |
LAC |
4/5 |
46 |
4 |
2 |
5 |
7 |
6 |
6 |
3 |
4 |
6 |
3 |
13 |
MOI |
|
|
|
|
|
|
|
|
|
|
|
|
14 |
NEA |
3/4 |
38 |
4 |
1 |
5 |
5 |
4 |
6 |
3 |
4 |
6 |
|
15 |
PEJ |
|
|
|
|
|
|
|
|
|
|
|
|
16 |
RAB |
2 |
25 |
3 |
1 |
5 |
9 |
2 |
0 |
2 |
1 |
2 |
|
17 |
SII |
3/4 |
38 |
5 |
7 |
2 |
7 |
4 |
4 |
2 |
2 |
3 |
2 |
18 |
SZJ |
|
|
|
|
|
|
|
|
|
|
|
|
19 |
TAA |
2 |
25 |
2 |
0 |
2 |
2 |
4 |
5 |
5 |
5 |
0 |
0 |
20 |
TAM |
3 |
32 |
5 |
3 |
4 |
0 |
2 |
4 |
5 |
4 |
3 |
2 |
21 |
VAB |
|
|
|
|
|
|
|
|
|
|
|
|
Feladatsor (ELTE IK hallgatók részére,
jelszóval) lásd 070411vj.doc
(MS Word)
Elméleti kérdések:
sárga háttérrel (alapfogalmak) min.
követelmény (24 pont)
Gyakorlati feladatok: kék háttérrel
(az algoritmusok alkalmazása 36 pont)
Összesen: 60 pont Relációs
sématervezés (48 p/1-4 f) PL/SQL (12 pont/5 f)
|
|
je. |
össz |
zh2 |
V.16. |
1.a |
1.b |
2.a |
2.b. |
3.a |
3.b |
4.a |
4.b |
5.a |
5.b |
1 |
BET |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2 |
CZR |
3 |
61 |
3 |
32 |
4 |
8 |
0 |
0 |
4 |
8 |
6 |
0 |
0 |
2 |
3 |
FOL |
3 |
61 |
3 |
34 |
0 |
2 |
2 |
8 |
4 |
8 |
6 |
2 |
0 |
2 |
4 |
GAB |
3 |
62 |
3 |
34 |
4 |
4 |
0 |
2 |
4 |
6 |
6 |
4 |
2 |
2 |
5 |
GAG |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
6 |
GAZ |
|
51 |
2 |
26 |
0 |
0 |
0 |
0 |
4 |
8 |
6 |
0 |
4 |
4 |
7 |
HOA |
5 |
95 |
4/5 |
47 |
4 |
2 |
2 |
8 |
4 |
8 |
6 |
6 |
4 |
3 |
8 |
HOZ |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
9 |
IHP |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
10 |
KAA |
3 |
61 |
2 |
26 |
4 |
0 |
0 |
0 |
4 |
8 |
6 |
2 |
0 |
2 |
11 |
KUA |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
12 |
LAC |
4 |
82 |
3 |
36 |
4 |
8 |
2 |
4 |
4 |
8 |
0 |
4 |
0 |
2 |
13 |
MOI |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
14 |
NEA |
3 |
62 |
2 |
24 |
4 |
2 |
0 |
4 |
4 |
2 |
6 |
2 |
0 |
0 |
15 |
PEJ |
|
|
2 |
26 |
4 |
2 |
2 |
2 |
4 |
2 |
6 |
2 |
0 |
2 |
16 |
RAB |
|
55 |
2 |
30 |
0 |
8 |
2 |
0 |
2 |
4 |
6 |
2 |
4 |
2 |
17 |
SII |
4 |
85 |
4 |
42 |
0 |
2 |
2 |
6 |
3 |
8 |
4 |
6 |
6 |
5 |
18 |
SZJ |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
19 |
TAA |
|
51 |
2 |
26 |
4 |
0 |
2 |
0 |
4 |
8 |
6 |
0 |
0 |
2 |
20 |
TAM |
3 |
62 |
2 |
28 |
4 |
0 |
2 |
0 |
4 |
8 |
6 |
0 |
2 |
2 |
21 |
VAB |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Feladatsor (ELTE IK hallgatók
részére, jelszóval) lásd 070516vj.doc (MS Word)