Lista de cursos Entrar

Informações

Autores Quentin Cappart
Prazo de entrega Sem prazo
Limite de submissão No limitation

Entrar

Entrar

Compréhension des mots-clefs (général)

Parmi les propositions suivantes, trouvez celle donnant une description correcte des mots-clefs (ou requêtes) suivants.

Questão 1: 
select name as student_name
from student;
Questão 2: 
select name
from student
order by tot_cred;
Questão 3: 
select name
from instructor
order by salary desc;
Questão 4: 
select title
from course
order by title asc;
Questão 5: 
select name
from student
order by tot_cred desc
limit 5;
Questão 6: 
select name
from student
order by ID
limit 10 offset 5;
Questão 7: 
select upper(name)
from instructor;
Questão 8: 
select name
from student
where length(name) > 5;
Questão 9: 
select name || ' (' || dept_name || ')'
from student;
Questão 10: 
select lower(name) || '@univ.edu'
from instructor;