Q25: Which query returns people who authored work from projects funded by Innovation?

Question

BlackTom AI · Accepted Answer

Graph pattern matching in Cypher treats relationship directions literally; writing the same directed path left-to-right or right-to-left yields the same matched set if the arrow directions are preserved. Here the schema implied is: person (p) -[:AUTHORED]-> work (w) -[:RESULT_OF]-> project (pr) -[:FUNDED_BY]-> department (d {name:'Innovation'}). 1) Relevant knowledge points and concepts - Cypher patterns: (a)-[:REL]->(b) matches a directed relationship from a to b. - A path can be written starting at any node; reversing the textual order while keeping arrows consistent finds the same matches. - Property filtering: (d {name:'Innovation'}) restricts d to the Innovation department. 2) Step-by-step reasoning - Option A pattern: MATCH (p)-[:AUTHORED]->(w)-[:RESULT_OF]->(pr)-[:FUNDED_BY]->(d {name:'Innovation'}) RETURN p.name - Traversal: p -> w -> pr -> d (where d.name = 'Innovation'). This returns person names who authored works whose result is a project funded by Innovation. - Option B pattern: MATCH (d {name:'Innovation'})<-[:FUNDED_BY]-(pr)<-[:RESULT_OF]-(w)<-[:AUTHORED]-(p) RETURN p.name - Traversal: d <- pr <- w <- p, which is the same directed relationships but written from d back to p. It matches the same persons. 3) Intermediate steps (pattern breakdown) - A: p --AUTHORED--> w --RESULT_OF--> pr --FUNDED_BY--> d(name='Innovation') - B: d(name='Innovation') <-FUNDED_BY- pr <-RESULT_OF- w <-AUTHORED- p Both yield the same set of p nodes. 4) Why the correct answer is correct - Both A and B specify the identical directed relationships and the same department filter; they will therefore return the same person names. 5) Why other options are incorrect - Option C: MATCH (p)-[:FUNDED_BY]->(d) RETURN p — This assumes persons are directly FUNDED_BY the department; the schema shows projects are FUNDED_BY departments, so this will not match the intended persons (unless the graph erroneously has such direct links). - Option E (“None of the answers”): incorrect because A and B are valid and equivalent. 6) Conclusion Both A and B are correct and equivalent; therefore the correct answer is "Both A and B," matching the provided answer.

Q25: Which query returns people who authored work from projects funded by Innovation?单项选择题

类似问题

Q26: Which query ensures each project appears only once, even if multiple people work on it?

Q 22: Which query returns works authored by someone who is also a Researcher?

Q 21: Which query returns total hours worked on each project?

Q 19: Which query returns the department that funds the project Alice works on?

Q 12: Which query returns only people who are BOTH Engineer AND Researcher?

Which of the following queries could return the same person–movie pair more than once, even if the dataset guarantees that there is at most one PRODUCED relationship and at most one REVIEWED relationship between any person and movie

Which queries find people who both acted in and directed the same movie in neo4j's sample Movie Graph? Select all that apply.

What is the effect on the financial statements when a company fails to adjust the unearned revenue account for revenues earned at year-end?

更多留学生实用工具

智能学习助手

风格化写作助手

论文查重助手

文献引用助手

课堂转译助手

课堂笔记助手

Quiz搜索助手

学校历年真题

智能刷题助手

智能匹配练习

希望你的学习变得更简单