Course list Sign in

Information

Author(s) Quentin Cappart
Deadline Geen deadline
Submission limit No limitation

Sign in

Sign in

Compréhension des mots-clefs (gestion des valeurs manquantes)

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

Question 1: 
select name
from instructor
where salary = null;
Question 2: 
select name
from instructor
where salary is null;
Question 3: 
select name
from instructor
where not (salary > 80000);
Question 4: 
select ID
from student
where tot_cred > 60
      or tot_cred is null;
Question 5: 
select name
from instructor
where dept_name <> 'Biology';
Question 6: 
select name
from instructor
where salary > 80000
      and dept_name = 'Biology';

On suppose qu’un instructeur spécifique a salary = NULL et dept_name = 'Biology'.

Question 7: 
select name
from instructor
where salary > 80000
      or dept_name = 'Biology';

On suppose qu’un instructeur spécifique a salary = NULL et dept_name = 'Biology'.

Question 8: 
select name
from instructor
where not (salary > 80000);

On suppose qu’un instructeur spécifique a salary = NULL.

Question 9: 
select ID
from student
where (tot_cred > 60 and dept_name = 'Biology')
      or tot_cred is null;

On suppose qu’un étudiant spécifique a tot_cred = NULL et dept_name = 'Biology'.

Question 10: 
select name
from instructor
where salary < 50000
      and dept_name = 'Physics';

On suppose qu’un instructeur spécifique a salary = NULL et dept_name = 'Chemistry'.