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

Question

BlackTom AI · Accepted Answer

Pattern matching in Cypher binds nodes and relationships so you can test properties on the relationship; to find people who have worked in R&D before 2016 you must capture the WORKS_IN relationship as a variable and compare its since property with 2016. 1) Relevant knowledge points and concepts - Cypher pattern syntax: (p)-[r:WORKS_IN]->(d {name:'R&D'}) binds node p, relationship r, and node d with a property filter on d. - Relationship properties (r.since) can be compared numerically using <, <=, etc. - "Since before 2016" is a strict comparison: r.since < 2016. - RETURN p.name returns just the person name rather than whole node. 2) Step-by-step reasoning - Match people p connected by a WORKS_IN relationship r to a department node d whose name equals 'R&D'. - Use WHERE r.since < 2016 to restrict to relationships that began in a year strictly less than 2016. - Return the names of the matched people. 3) Intermediate/check calculations (example evaluations) - If r.since = 2010, evaluate 2010 < 2016 → true (person included). - If r.since = 2015, evaluate 2015 < 2016 → true (included). - If r.since = 2016, evaluate 2016 < 2016 → false (excluded). 4) Why the correct answer is correct - The first option explicitly binds r so we can access r.since and uses the correct strict inequality (< 2016). It also limits department to R&D via the node property and returns only the person names as requested. 5) Why other options are incorrect - Option 2: MATCH (d {name:'R&D'})<-[:WORKS_IN]-(p) returns people in R&D but does not filter by r.since (no "since before 2016" condition). - Option 3: MATCH (p:Person {since:2015}) assumes since is a node property and equals 2015 exactly; the since is on the relationship and the requirement is "before 2016", not equality to 2015. - Option 4: MATCH (p)-[:WORKS_IN]->(d) WHERE d.name='R&D' returns people in R&D but again lacks the relationship since filter. - Option 5: Incorrect since a correct option is present. Conclusion: The provided query MATCH (p)-[r:WORKS_IN]->(d {name:'R&D'}) WHERE r.since < 2016 RETURN p.name is correct and matches the given answer.

Q24: Which query finds people who have worked in R&D since before 2016?单项选择题

类似问题

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

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 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搜索助手

学校历年真题

智能刷题助手

智能匹配练习

希望你的学习变得更简单