Teza MySQL
Authored by Chis Lucian
Computers
12th Grade
Used 7+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
9 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fie tabela CANDIDATI cu structura SCOALA varchar(20);CLASA varchar(4);NUME varchar(20);PROBA_D float, PROBA_E float, Proba_F float , MEDIE float, ADMIS int(1);
Actualizati campul medie . Un candidat este admis daca are media minim 6.00 si are note peste 5.00 la toate probele.
update candidati set medie=(proba_e+proba_d+proba_f)/3 where proba_e>5 or proba_f>5 or proba_d>5;
update candidati set medie=avg(proba_e,proba_d,proba_f) where proba_e>5 or proba_f>5 or proba_d>5;
update candidati set medie=(proba_e+proba_d+proba_f)/3 where proba_e+proba_f+proba_d>=15;
update candidati set medie=(proba_e+proba_d+proba_f)/3 where proba_e>5 and proba_f>5 and proba_d>5;
update candidati set medie=avg(proba_e,proba_d,proba_f) where proba_e>5 and proba_f>5 and proba_d>5;
2.
MULTIPLE SELECT QUESTION
45 sec • 1 pt
Fie tabela CANDIDATI cu structura SCOALA varchar(20);CLASA varchar(4);NUME varchar(20);PROBA_D float, PROBA_E float, Proba_F float , MEDIE float, ADMIS int(1);
Afisati numarul candidatilor al caror nume incepe cu litera 'P'
select count(*) from candidati where left(nume,1)='P';
select count(*) from candidati where nume LIKE 'P%';
select count(*) from candidati where right(reverse(nume),1)='P';
select count(*) from candidati where candidati where name="P*";
select count(*) from candidati where nume="P";
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fie tabela CANDIDATI cu structura SCOALA varchar(20);CLASA varchar(4);NUME varchar(20);PROBA_D float, PROBA_E float, Proba_F float , MEDIE float, ADMIS int(1);
Un candidat este admis daca are media minim 6.00 si are note peste 5.00 la toate probele.
Stergeti elevii care nu sunt admisi
delete from candidati where medie<6 or proba_d<5 or proba_e<5 or proba_f<5;
delete from candidati where medie<6 and proba_d<5 and proba_e<5 and proba_f<5;
delete from candidati where medie<6 or proba_d<5 and proba_e<5 and proba_f<5;
delete from candidati where medie<6 or proba_d, proba_e, proba_f in{0,1,2,3,4};
4.
MULTIPLE SELECT QUESTION
45 sec • 1 pt
Fie tabela CANDIDATI cu structura SCOALA varchar(20);CLASA varchar(4);NUME varchar(20);PROBA_D float, PROBA_E float, Proba_F float , MEDIE float, ADMIS int(1);
Un candidat este admis daca are media minim 6.00 si are note peste 5.00 la toate probele.
Sa se afiseze elevii care au obtinut la proba_e nota 8, 9 sau 10;
select nume from candidati where proba_e in {8,9,10};
select nume from candidati where proba_e=8 or proba_e=9 or proba_e=10;
select nume from candidati where proba_e=8 and proba_e=9 and proba_e=10;
select nume from candidati where proba_e=8 or proba_e=9 and proba_e=10;
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fie tabela CANDIDATI cu structura SCOALA varchar(20);CLASA varchar(4);NUME varchar(20);PROBA_D float, PROBA_E float, Proba_F float , MEDIE float, ADMIS int(1);
Un candidat este admis daca are media minim 6.00 si are note peste 5.00 la toate probele.
Afisati numarul de elevi respinsi pe clase;
select count(*), clasa where medie<6 or proba_d<5 or proba_e<5 or proba_f<5 group by clasa;
select count(*), clasa where medie<6 or proba_d<5 or proba_e<5 or proba_f<5 order by clasa;
select count(*), clasa where medie<6 or proba_d<5 or proba_e<5 or proba_f<5 group by clasa;
select count(*), clasa from candidati where medie<6 or proba_d<5 or proba_e<5 or proba_f<5 group by clasa;
select count(*), clasa from candidati where or(proba_d<5, proba_e<5, proba_f<5,media<6) group by clasa;
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Fie tabela CANDIDATI cu structura SCOALA varchar(20);CLASA varchar(4);NUME varchar(20);PROBA_D float, PROBA_E float, Proba_F float , MEDIE float, ADMIS int(1);
Un candidat este admis daca are media minim 6.00 si are note peste 5.00 la toate probele.
Afisati elevul/elevii cu cea mai mare medie.
select nume,max(medie) from candidati;
select nume from candidati where medie=max(medie);
select nume from candidati where medie=max(avg(medie));
select nume from candidati where medie=(select max(medie) from candidati);
select nume from candidati where medie=(select avg(medie) from candidati);
7.
MULTIPLE SELECT QUESTION
45 sec • 1 pt
Fie tabela CANDIDATI cu structura SCOALA varchar(20);CLASA varchar(4);NUME varchar(20);PROBA_D float, PROBA_E float, Proba_F float , MEDIE float, ADMIS int(1);Un candidat este admis daca are media minim 6.00 si are note peste 5.00 la toate probele.
Sa se afiseze elevul cu cea mai mica medie. In tabela exista un singur elev cu media cea mai mica;
select nume from candidati where medie=min(medie);
select nume from candidati where medie=(select min(medie) from candidati);
select nume from candidati order by medie limit 1;
select nume from candidati group by medie having medie=min(medie);
select nume from candidati order by medie desc limit 1;
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Microsoft
or continue with
%20(1).png)
Apple
Others
Already have an account?
