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

Question

BlackTom AI · Accepted Answer

Label checks in Cypher can be done inline in the pattern (using multiple labels) or with a WHERE predicate that tests labels. Both forms return nodes that carry all specified labels.

1) Relevant knowledge points and concepts
- A node can have multiple labels; in Cypher you can match a node with multiple labels either by writing them together in the pattern (e.g., (n:Label1:Label2)) or by matching a node and using WHERE n:Label1 AND n:Label2.
- MATCH (a),(b) denotes two separate pattern elements; variables should be used consistently to refer to the same or different nodes as intended.
- Using the same variable name incorrectly across separate pattern elements is ambiguous and not the conventional way to require multiple labels.

2) Step-by-step reasoning
- Option A: MATCH (d:Department:FundingBody) RETURN d;
  - This pattern explicitly matches a single node bound to d that has both labels Department and FundingBody. This is valid and concise.
- Option C: MATCH (d) WHERE d:Department AND d:FundingBody RETURN d;
  - This matches any node d and then filters to those for which both label tests are true. This is functionally equivalent to A and is also valid.
- Option B: MATCH (d:Department),(d:FundingBody) RETURN d;
  - This writes two separate pattern elements separated by a comma but reuses the same variable name d. The intended way to match two different nodes would be e.g., MATCH (d:Department), (f:FundingBody). Reusing d here is not the conventional/clear way to require that a single node has both labels and can be syntactically or semantically problematic. Therefore B is incorrect.
- Option D: Both A and C — this states both valid approaches are correct.
- Option E: None of the above — incorrect because A and C are valid.

3) Intermediate steps / equivalence
- A and C both restrict to nodes where Department and FundingBody labels are present. They are equivalent: (d:Department:FundingBody) ⇔ (d) WHERE d:Department AND d:FundingBody.

4) Why the correct answer is correct
- Both A and C correctly and unambiguously find nodes that are labeled Department and FundingBody. They use two accepted Cypher patterns for multi-label matching.

5) Why other options are incorrect
- B misuses the comma-separated pattern with the same variable name (ambiguous/incorrect usage). E is wrong because valid options exist.

Conclusion: The correct choice is "Both A and C," matching the provided answer.

Q 14: Which query correctly finds Departments that are also FundingBody nodes?单项选择题

类似问题

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?

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

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 13: What does this return? MATCH (p:Person)-[:COLLABORATES_WITH]-(other) RETURN p.name, other.name;

更多留学生实用工具

智能学习助手

风格化写作助手

论文查重助手

文献引用助手

课堂转译助手

课堂笔记助手

Quiz搜索助手

学校历年真题

智能刷题助手

智能匹配练习

希望你的学习变得更简单