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

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;

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";

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};

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;

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;

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);

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 Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

10 questions

Quiz Pemrograman Dasar Python

Quiz

•

9th - 12th Grade

10 questions

L.8. STRINGS AND STRING MANIPULATION -1

Quiz

•

12th Grade

10 questions

Unit 4 Advanced AP CSP

Quiz

•

9th - 12th Grade

10 questions

C Language Basic Quiz

Quiz

•

7th Grade - Professio...

10 questions

J277 - 2.2 - Understanding Data Types in Programming

Quiz

•

10th Grade - University

10 questions

Kuis1

Quiz

•

12th Grade

10 questions

THỰC HÀNH SỐ 1

Quiz

•

12th Grade

10 questions

Les variables sous Python

Quiz

•

10th - 12th Grade

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

54 questions

Analyzing Line Graphs & Tables

Quiz

•

4th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

Discover more resources for Computers

18 questions

[AP CSP] JavaScript Programming Lesson 2025-2026

Lesson

•

9th - 12th Grade

57 questions

[AP CSP] Unit 5 Review: Internet & Cybersecurity

Quiz

•

9th - 12th Grade

Teza MySQL

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.

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'

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

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;

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.

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers

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.

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'

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

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;

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.