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?单项选择题

类似问题

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;

更多留学生实用工具

智能学习助手

风格化写作助手

论文查重助手

文献引用助手

课堂转译助手

课堂笔记助手

Quiz搜索助手

学校历年真题

智能刷题助手

智能匹配练习

希望你的学习变得更简单