SQLtest.online

Question

La table actor possède un index idx_actor_last_name sur la colonne last_name. Laquelle des requêtes suivantes peut utiliser cet index comme index couvrant ?

Answer 1

select actor_id, last_name from actor order by last_name desc;

Answer 2

select last_name from actor order by actor_id;

Answer 3

select last_name, count(*) from actor group by last_name;

Answer 4

select distinct last_name from actor;

SQLtest.online

Pratique

Leçons

Test

Se connecter

S'inscrire