BluePink XHost |
Servere virtuale de la 20 eur / luna. Servere dedicate de la 100 eur / luna - servicii de administrare si monitorizare incluse. Colocare servere si echipamente de la 75 eur / luna. Pentru detalii accesati site-ul BluePink. |
BILET 1 C++ #include<iostream.h> cout<<"n=";cin>>n; for(i=1;i<=n;i++)
}
|
VISUAL FOX create elevi.dbf |
BILET 2 #include<iostream.h> |
2.
create campion.dbf a) accept to x list all for e1=x .or. e2=x b) list all for data=date() c) copy struct to campionat.dbf fields e1,e2,g1,g2 use campionat.dbf list d) count to y |
BILET 3 #include<iostream.h> |
3.
create examen.dbf a) modi struct //adaugam campul media// replace all media with (proba1+proba2)/2 list insert blank calculate max(proba_practica) to x go bottom replace proba_practica with x list b)accept to x input to y replace proba_practica with y for candidat=x list c) accept to u delete all for cls=u list d) copy to examen1.dbf fields candidat, media use examen1 list e)index on nume to examen1.idx use examen.dbf index examen1.idx list |
BILET 4 #include<iostream.h> for(i=1;i<n;i++) |
4.
create carti.dbf a) accept to x replace pret with pret+10 for editura=x b) calculate sum(nr_pag) for editura=x c) list titlu for editura=x d) sort to nou.dbf on titlu use nou.dbf list e) locate for autor="eminescu" insert blank list |
BILET 5 #include<iostream.h> void main() |
5.
create teatru.dbf a) accept to d1 x1=ctod(d1) accept to d2 x2=ctod(d2) accept to v list all for oras=v .and. x1<data .and. data<x2 b) accept to y accept to x count to n for autor=y .and. presa=x c) accept to d3 x3=ctod(d3) delete all for data<x3 list |
BILET 6 #include<iostream.h> cout<<"matricea introdusa este:"; for(k=1;k<=m;k++) |
6.
create elevi.dbf a) list nume,clasa for admis=.t. b) list nume for abs>= 50 c) delete for media<5 list d) list clasa,sala for n1>=5 .and. n2>=5 |
BILET 7 #include <iostream.h> void main()
|
7.
create nero.dbf a) list nume, varsta, crestin b) list all for sex="fem" .and. varsta<25 .and. crestin=.t. c) sort to femeie.dbf on nume for sex="fem" .and. varsta>25 .and. varsta<40 .and. crestin=.f. use femeie.dbf list |
BILET 8 #include<iostream.h> return 1; } |
8.
create farmacie.dbf a) list b) list farmacie for medicament="aspirina" c) list medicament for specificatii != "fara" .and. retea=.t. d) list medicament, cant, pret for farmacie=1 |
#include<iostream.h> return 1; } |
9.
create firma.dbf a)list all cantitate, pret for firma="Dunarea" b)list all for pret>1.000.000 c) list all for produs="zahar" list cantitate, pret |
BILET 10 #include<iostream.h> } |
10.
create personal.dbf a)list all for left(nume,1)="a" .and. left (prenume,1)="r" b)list all for left(nume,1)="b" .and. year (data_a)=04 .and. left(prenume,1)="g" c)list all for functia=3 .and. salariu<1500000 d)list nume for year(data_n)>=75 list nume for year(data_n)<55 .and. functia !=3 |
BILET 11 #include<iostream.h> |
11.
create elevi.dbf a)list all nume, media >7,55 b)delete all for clasa=12 c)replace all clasa with clasa+1 for clasa<12 d)replace all media with media+1 for clasa=11 |
BILET 12 #include<iostream.h> int baza(int n,int b)
|
12.
create balanta.dbf a)replace all stoc_final with 0 for stoc_final<0 list b)sort to balanta1.dbf on nume_material use balanta1.dbf list c) list all for stoc_final>0 |
BILET 13 #include<iostream.h> cout<<"numarul in baza 10 este" <<n10<<endl; } |
13 .
create stocuri .dbf 1) list all for cond= .t. 2) list all for cantit < cant_nor 3) list all for val > 1000000 4) list all for left (cod,1) = "1".and.month(data_misc)>=4 |
BILET 14 #include<iostream.h> int sum_div(int n)
|
14.
create elevi.dbf a) accept "x=clasa" to x imput "y=medie" to y list all for clasa = x .and. medie > y b) delete all for medie <s recall c) modi stru d) list record 3 e) sort to elevi1 on nume use elevi1 list |
BILET 15 #include<iostream.h> void main() cout<<"n=";cin>>n; m=(float)s/n; for(i=1;i<=n;i++) |
15.
create cresa.dbf 1)list nume for varsta>2 2) sort to cresa1. on prenume use cresa1 list 3) replace nume with "cristi" for left (nume,1) = "a" 4)delete all for varsta > 4 list |
BILET 16 #include<iostream.h> |
16.
create librarie.dbf a)list nume_lib for adresa="Str. Macului" b)sort to lib on nume_lib for vanzari>2000000 use lib list c)use librarie replace all stoc with stoc+50.000 list d)locate for titlu_carte="Padurea Spanzuratilor" display |
BILET 17 #include<iostream.h> while(nr) for(i=m;i>0;i--) |
17.
create hotel.dbf a)list nume_clienti for left(nume_clienti,1)="p" b)list nume_hotel for oras="constanta" c)delete all for nr_locuri<50 list d)list nume_hotel for year(data_infiintarii)<1950 |
BILET 18 #include<iostream.h> int a[100],m,b[100],n,j,i,ok,dif[100],re[100],in[100],lin=0,
lre=0, ldif=0; for(i=1;i<=n;i++) |
18.
create firma.dbf a)list all cantitate, pret for firma="Dunarea" b)list all for pret>1.000.000 c) list all for produs="zahar" list cantitate, pret |
BILET 19 #include<fstream.h> |
19.
create produse.dbf create nomenc.dbf create preturi.dbf 1) use produse in 1 sele 1 sort to produse1 on codp use produse1 list use nomenc in 2 sele 2 sort to nomenc1 on codp use nomenc1 list use preturi in 3 sele 3 sort to preturi1 on codp use preturi1 list 2) sele 3 calculate min (pret) to x locate for pret = x n = codp sele 1 locate for codp = n m = cant sele 2 locate for codp = n p= denp ? n,p,x,m,x*m 3) sele 1 count to y for cant =0 ? y 4) sele 3 calculate max (pret) to z locate for pret = z c = codp sele 2 list denp for codp = k |
BILET 20 #include<fstream.h> |
20.
create personal.dbf 1) calculate avg (salariu) to x ? 'salariu=',x 2) sum (salariu) 3) count to x ? 'nr. de salarii=',x 4) calculate max(salariu) to y list nume, functie for salariu=y |
BILET 21 #include<iostream.h> n=n1; getch();
|
21. create pers.dbf 1)list nume for avans<=40000 2)list nume for salariu<=1500000 3)use pers.dbf sort to doc.dbf on avans/d , salariu/d use doc.dbf list 4) sort to doc2.dbf on nume for impozit>=50000 use doc2.dbf list next 3 |
BILET 22 #include<fstream.h> |
22. create sportivi.dbf create antrenori.dbf 1)use antrenori.dbf count to x ?'nr.de tari=',x 2)accept to y use list nume for tara=y use sportive.dbf list nume for tara=y modi struct ('creez campul media') replace all media with (nota1+nota2+nota3)/3 calculate max(media) to x list nume for media=x |
BILET 23 #include<iostream.h> {fib[i]=fib[i-1]+fib[i-2]; |
23. create bolnavi.dbf create personal.dbf 1)list all nume_c for date() - data_i>14 2) use personal.dbf copy fields nume, etaj to asist.dbf for medic=.f. use asist.dbf list use personal.dbf copy fields nume to medici.dbf for medic=.t. use medici.dbf list 3) use bolnavi.dbf sort to boln.dbf on nume use boln.dbf list |
BILET 24 #include <iostream.h> int n; int fib (int k) int det_fib_max (int k)
|
24. create elevi.dbf create adrese.dbf 1.use elevi.dbf in 1 alias el 2.use adrese.dbf in 2 alias adr 3.select 2 list all nume 4.select 1 list all nota2 5.select 1 6. list nume,nota1,nota2 select 2 list all nume,adresa |
BILET 25 #include<iostream.h> if(n%2!=0) } |
25. create pers.dbf sort to p1.dbf on pers.nume/a, pers.data_ang/d use p1.dbf list sort to p2.dbf on pers.nr.copii/a fields pers.nume, pers.nr_copii use p2 list sort to p3.dbf on pers.avans/a, pers.nume/d use p3 go top list next 5 sort to p4.dbf on pers.avans for left(nume,3)='ion' |
BILET 26 #include <iostream.h> |
26. create pers.dbf use pers.dbf 1)sort to p1.dbf on impozit/a, nume/d, nr_copii/d use p1.dbf list 2)sort to p2.dbf on salariu/a for left(nume,3)='ion' use p2.dbf list 3)sort to p3.dbf on nume/d, functie/a, nr_copii/d use p3.dbf x='01.31.94' x1=ctot(x) y='01.31.95' y1=ctod(y) list all for data_ang>=x1 && data_ang<=y1 4)sort to p4.dbf on salariu/a, avans/d for salariu>="200000" && left(nume,1)='n' use p4.dbf list |
BILET 27 #include <iostream.h> int n, v[100]; void citire_date() void sortare() void afisare_adunari() |
27. create elevi.dbf 1)modi struct // se adauga campul media replace all media with (nota1+nota2)/2 list all 2)calculate avg(nota1) to n1 calculate avg(nota2) to n2 ?n1,n2 3)calculate avg(media ) to t ?t |
BILET 28 #include<iostream.h> |
28. create admit.dbf 1)go top insert blank x=(proba1+proba2)/2 calculate max(pr_pr) to y replace pr_pr with x replace proba1 with y display 2)replace all pr_pr with pr_pr+1 for pr_pr<=9 3)accept to u delete all for clasa=u list 4) sort to admis.dbf on media/d fields admit.cond, admit. medie use amis.dbf list 5)index to fis.idx on cond list admit index fis.idx |
BILET 29 #include<iostream.h> |
29. create carti.dbf 1.accept to x replace all pret with pret+pret*0,1 for autor=x list 2.accept to x sum(nrpag) to y for editura=x ?y 3.accept to w list all titlu for titlu=w 4.sort to carti2.dbf on titlu use carti.dbf list 5.use carti.dbf locate for autor="eminescu" insert blank list |
BILET 30 #include<iostream.h> r[++k]=n%2; } |
30.create spectacol.dbf 1)accept to x accept to d1 accept to d2 d1=ctod(d1) d2=ctod(d2) list all for orasul=x && perioada>d1 && perioada<d2 2)accept to x accept to y count for piesa=x && autor=y 3)accept to x accept to y delete all for piesa=x && perioada>y list |
BILET 31 #include<iostream.h> int p,n,fact=0,temp,i;
{ clrscr();
|
31. 1.create farmacie 2.accept to x list all farm for medicament=x 3.list all medicament for reteta=.t. 4. list medicament,cantitate,pret for farm=1 |
BILET 32 #include <iostream.h> int n; struct nod nod *p, *u; void citire_date() void permutari() void main() |
32. create firma.dbf 1.list all cantitate,pret for firma="marex" 2.list all produs for pret>1000000 3.list all cantitate,pret for produs="zahar" 4.replace all pret with pret+pret*0,15 list all pret,nume |
BILET 33 #include <iostream.h> int nr_ap (int nr) int nr_ap_total() void main() |
33. create elev.dbf list nume for media_admitere>6 delete all for clasa=12 replace all clasa with clasa+1 for clasa<12 replace all media_admitere with media_admitere +1 for clasa=1 && media_admitere<=9 list |
BILET 34 #include<iostream.h> for(i=1;i<=n;i++) |
34. create stocuri.dbf 1.replace all stoc_final with 0 for stoc_final<0 list 2.sort to stocuri2.dbf on nume_material use stocuri2.dbf list 3.use stocuri.dbf list all for stoc_final >0 4.delete all for data_intrarii>date( ) list |
BILET 35 #include<iostream.h> |
35. create copii.dbf 1)list nume_copil for varsta>2 2)sort to copii2.dbf on prenume/a use copii2.dbf list 3)replace all nume_copil with 'cristi' for left(nume_copil,1)='a' list 4)delete nume_copil for varsta>4 5)replace all varsta with varsta+1 list nume_copil for varsta>=7 |
BILET 36 #include<iostream.h> getch(); |
36. create librarie.dbf 1)list nume_librarie for adresa='marului' 2)sort to librarie1.dbf on nume_librarie for vanzari>2000000 use librarie1.dbf list 3)replace all stoc with stoc+50000 list 4)locate for titlu_carte='ion' display |
BILET 37 #include<iostream.h> |
37. create hoteluri.dbf 1.list all nume for left(nume,3)="pop" 2.list all nume hotel for oras="braila" 3.delete all for numar_locuri<50 4. list all nume_hotel for year(data_infiintarii)<1950 |
BILET 38 #include <iostream.h> void main() {int i,j,k,n; { cout<<"n="<<endl; k=0; {k++; j=j/5; }} |
38. create sportivi.dbf 1.count to x ?x sort to sportiv.dbf on tara/a use sportiv2.dbf list tara 2.accept to y list all sporturi,antrenor for tara=y 3.calculate max(proba1) to a list all sportiv,antrenor for proba1=a calculate max(proba2) to b list all sportiv,antrenor for proba2=b calculate max(proba3) to c list all spotitv,antrenor for proba3=c |
BILET 39 #include<fstream.h> void aparitie(long int k,int o) if(ap>1) {f<<"pentru numarul "<<k<<"
avem "<<ap<<" aparitii"; |
39. create bolnavi.dbf 1.list nume for data_i<date( )+14 2.accept "medic=" to x copy fields nume,dagnostic to bolnavi2.dbf for medic=x 3.accept to x count to y for medic=x delete all for medic=x list 4.sort to bolnavi3.dbf on nume use bolnavi3.dbf list |
BILET 40 #include <fstream.h> fstream f("numere.txt",ios::in); struct nod nod *p, *u; void adaug_nod (int n) int valid (int n) int citire_date() void main() |
40. create stok.dbf 1.list all denumire for data_ultimei_miscari=date( ) 2.list all denumire for cantitate<cant_normala 3.list all denumire for valoare>5000000 4.list all materiale for left(denumire,1)="f" |