База ответов ИНТУИТ

Введение в Oracle SQL

<<- Назад к вопросам

Даны таблицы:
PEOPLE
NAMEPERSON_ID
Bill1
Ted2
Al3
JOBS
JOB_IDDESCRIPTION
100Assistant
200Developer
300Team Leader
EMPLOYEES
PERSON_IDEMP_IDJOB_ID
110100
220200
330300
Начало запроса SQL:
SELECT p.name, e.emp_id, j.description
Необходимо выполнить эквисоединение между таблицами PEOPLE, EMPLOYEES и JOBS. Корректными вариантами продолжения запроса являются:

(Отметьте один правильный вариант ответа.)

Варианты ответа
FROM employees e WHERE e.person_id = p.person_id AND   e.job_id = j.job_id
FROM employees e JOIN ON people p AS e.person_id = p.person_id JOIN ON jobs AS e.job_id = j.job_id
FROM employees e, people p, jobs j WHERE e.person_id = p.person_id AND   e.job_id = j.job_id
(Верный ответ)
FROM employees e, people p, jobs j WHERE e.person_id(+) = p.person_id AND   e.job_id = j.job_id(+)
FROM employees, people, jobs WHERE e.person_id = p.person_id  AND   e.job_id = j.job_id
Похожие вопросы
Даны таблицы:
EMPLOYEES
FIRST_NAMELAST_NAMESALARY
CarlSpellman60000
RonRinkle50000
ArtTodd40000
AmyWalters45500
KenReyes60400
MartinJohnson50600
MARKETS
LOCATIONAVG_SALARY
N40000
S30000
NE40000
NW30000
SE40000
Запрос SQL:
SELECT last_name, first_name, salary FROM employeesWHERE salary = ANY (SELECT avg_salary 		    FROM markets                    WHERE location IN ('N','S'));
Количество строк, возвращенных запросом, = ...
Даны таблицы:
ANIMALS
FAMILYNAME
mammaldog
mammallion
fishguppy
birdeagle
fishbass
birdpelican
insectbeetle
BLOOD_TYPES
FAMILYBLOOD_TYPE
mammalwarm_blooded
fishcold_blooded
birdcold_blooded
Запрос SQL:
SELECT a.family, a.nameFROM animals a, blood_types t WHERE a.family(+) = t.family AND a.family NOT IN ('fish', 'bird');
Выборки, эквивалентные результату запроса, возвращают команды:
Даны таблицы:
ANIMALS
FAMILYNAME
mammaldog
mammallion
fishguppy
birdeagle
fishbass
birdpelican
insectbeetle
BLOOD_TYPES
FAMILYBLOOD_TYPE
mammalwarm_blooded
fishcold_blooded
birdcold_blooded
Запрос SQL:
SELECT a.family, a.nameFROM animals a, blood_types t WHERE a.family = t.family AND a.family NOT IN ('fish', 'bird');
Выборки, эквивалентные результату запроса, возвращают команды:
Даны таблицы:
TOOLS
NAMEPRICETYPE
drill155A
sawzall192N
mitre saw292M
router86I
RAD145M
jigsaw128I
screwdriver77P
TOOL_TYPES
TYPEUSAGE
AAlways
IOften
MSometimes
NRarely
PNever
Запрос SQL:
SELECT t.type, SUM(t.price) FROM tools t GROUP BY t.type HAVING SUM(t.price) >= (SELECT AVG(price) 			FROM tools 			WHERE type IN (SELECT type 				       FROM tool_types 				       WHERE usage = 'Often')); 
Количество строк, возвращенных запросом, = ...
Даны таблицы:
TOOLS
NAMEPRICETYPE
drill155A
sawzall192N
mitre saw292M
router86I
RAD145M
jigsaw128I
screwdriver77P
TOOL_TYPES
TYPEUSAGE
AAlways
IOften
MSometimes
NRarely
PNever
Запрос SQL:
SELECT t.type, SUM(t.price) FROM tools t GROUP BY t.type HAVING SUM(t.price) <= (SELECT AVG(price) 			FROM tools 			WHERE type IN (SELECT type 				       FROM tool_types 				       WHERE usage = 'Often')); 
Количество строк, возвращенных запросом, = ...
Даны таблицы:
TOOLS
NAMEPRICETYPE
drill155A
sawzall192N
mitre saw292M
router86I
RAD145M
jigsaw128I
screwdriver77P
TOOL_TYPES
TYPEUSAGE
AAlways
IOften
MSometimes
NRarely
PNever
Запрос SQL:
SELECT t.type, SUM(t.price) FROM tools t GROUP BY t.type HAVING SUM(t.price) <= (SELECT AVG(price) 			FROM tools 			WHERE type IN (SELECT type 				       FROM tool_types 				       WHERE usage = 'Sometimes')); 
Количество строк, возвращенных запросом, = ...
Даны таблицы:
ANIMALS
FAMILYNAME
mammaldog
mammallion
fishguppy
birdeagle
fishguppy
birdpelican
reptilesnake
BLOOD_TYPES
FAMILYBLOOD_TYPE
mammalwarm_blooded
fishcold_blooded
birdcold_blooded
Запрос SQL:
SELECT DISTINCT a.nameFROM animals a, blood_types tWHERE a.family = t.family;
Количество строк, возвращенных запросом, = ...
Даны таблицы:
ANIMALS
FAMILYNAME
mammaldog
mammallion
fishguppy
birdeagle
fishbass
birdpelican
insectbeetle
BLOOD_TYPES
FAMILYBLOOD_TYPE
mammalwarm_blooded
fishcold_blooded
birdcold_blooded
Запрос SQL:
SELECT a.family, a.nameFROM animals a INNER JOIN blood_types t ON (a.family = t.family)WHERE a.family NOT IN ('fish', 'bird');
Количество строк, возвращенных запросом, = ...
Даны таблицы:
ANIMALS
FAMILYNAME
mammaldog
mammallion
fishguppy
birdeagle
fishguppy
birdpelican
fishNULL
BLOOD_TYPES
FAMILYBLOOD_TYPE
mammalwarm_blooded
fishcold_blooded
birdcold_blooded
Запрос SQL:
SELECT COUNT(DISTINCT name) FROM animals WHERE family = ANY (SELECT family 		    FROM blood_types 		    WHERE blood_type NOT LIKE ('warm%'));
Количество строк, возвращенных запросом, = ...
Даны таблицы:
ANIMALS
FAMILYNAME
mammaldog
mammallion
fishguppy
birdeagle
fishguppy
birdpelican
fishNULL
BLOOD_TYPES
FAMILYBLOOD_TYPE
mammalwarm_blooded
fishcold_blooded
birdcold_blooded
Запрос SQL:
SELECT COUNT(DISTINCT name) FROM animals WHERE family = ANY (SELECT family 		    FROM blood_types 		    WHERE blood_type LIKE ('warm%'));
Значение, возвращенное запросом, = ...