Q18: Which query returns person who are BOTH Engineer and Researcher and earn more than 125000?

Question

BlackTom AI · Accepted Answer

Using multiple labels in the node pattern — MATCH (p:Engineer:Researcher) — guarantees the matched node carries both the Engineer and Researcher labels. The WHERE clause then filters those matched nodes by salary, and RETURN p.name projects the desired result.

1) Relevant knowledge points and concepts
- In Cypher, writing a node pattern with multiple labels (e.g., (n:LabelA:LabelB)) matches nodes that have all those labels.
- The WHERE clause applies additional predicate filters (e.g., p.salary > 125000).
- RETURN specifies which fields to output (here p.name).
- Specifying an extra label in the MATCH pattern (e.g., :Person) restricts matches to nodes that also have that label.

2) Step-by-step reasoning
- Pattern matching: MATCH (p:Engineer:Researcher) finds every node p that has both labels Engineer and Researcher, regardless of any other labels it may or may not have.
- Filtering: WHERE p.salary > 125000 restricts those matched nodes to only those with a salary property greater than 125000.
- Projection: RETURN p.name yields the names of those remaining nodes.

3) Intermediate steps (conceptual)
- Universe: all nodes in the graph.
- After MATCH: subset = {nodes with labels Engineer AND Researcher}.
- After WHERE: subset2 = {n in subset | n.salary > 125000}.
- RETURN: list of p.name for each node in subset2.

4) Why the correct answer is correct
The query MATCH (p:Engineer:Researcher) WHERE p.salary > 125000 RETURN p.name exactly encodes the requirement “persons who are both Engineer and Researcher and earn more than 125000” without imposing any extra label constraints.

5) Why the other options are incorrect
- Option B (MATCH (p:Person) WHERE p:Engineer AND p:Researcher ...) is syntactically usable but restricts matches to nodes that also carry the Person label; it would miss nodes that are Engineer and Researcher but not labeled Person.
- Option C (MATCH (p:Person:Engineer:Researcher) ...) likewise forces a Person label and so is overly restrictive.
- Option D (“Both B and C”) is wrong because both B and C are not equivalent to A (they add the Person constraint).
- Option E (“None”) is wrong because A is valid.

Final confirmation: the correct query is MATCH (p:Engineer:Researcher)
WHERE p.salary > 125000
RETURN p.name, which matches the provided answer.

Q18: Which query returns person who are BOTH Engineer and Researcher and earn more than 125000?Single choice

Similar Questions

Q 27: Which query correctly finds people who are managed by Bob?

Q24: Which query finds people who have worked in R&D since before 2016?

Q 20: Which query correctly returns collaborators of David regardless of stored direction?

Q 17: Complete to count projects per department: MATCH (p:Project)-[:FUNDED_BY]->(d:Department)WITH d, COUNT(p) AS totalRETURN d.name, _[Fill in the blank] __;

Q16: Complete to return people who authored works with more than 20 citations: MATCH (p:Person)-[:[Fill in the blank] ]->(w:Work)WHERE w.[Fill in the blank] > 20RETURN p.name;

Q15: What does this return? MATCH (m:Manager)-[:MANAGES]->(e:Engineer) RETURN COUNT(e);

Q 14: Which query correctly finds Departments that are also FundingBody nodes?

Q 13: What does this return? MATCH (p:Person)-[:COLLABORATES_WITH]-(other) RETURN p.name, other.name;

More Practical Tools for Students Powered by AI Study Helper

Homework AI Solver

Stylized AI Paper Writer

Plagiarism Checker Assistant

Citation AI Academic Writing Tool

In-Class Translation Assistant

AI Note Generator

AI Quiz Answers

Past Exam Questions from University Test Bank

Smart Practice Assistant

Adaptive Practice

Making Your Study Simpler