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

Question

BlackTom AI · Accepted Answer

Cypher pattern matching uses directed relationships, so the correct path must navigate from the Person node labeled Alice to the Project node she works on, then follow the FUNDED_BY relationship from that project to the Department node. 1. Relevant knowledge points and concepts - Nodes have labels and properties, e.g., (a:Person {name:'Alice'}) identifies Alice. - Relationships in Cypher are directional: (x)-[:REL]->(y) goes from x to y; reversing the arrow changes meaning. - Variables (a, p, d) name matched nodes; RETURN d.name returns the department’s name. 2. Step-by-step reasoning - Identify Alice: (a:Person {name:'Alice'}). - Find the project Alice works on: Alice should have an outgoing WORKS_ON relationship to a project, so (a)-[:WORKS_ON]->(p). - From that project, find which department funds it: the project should have an outgoing FUNDED_BY relationship to a department, so (p)-[:FUNDED_BY]->(d). - Finally, return the department name: RETURN d.name. 3. Intermediate pattern construction - Full query assembled: MATCH (a:Person {name:'Alice'})-[:WORKS_ON]->(p)-[:FUNDED_BY]->(d) RETURN d.name 4. Why this answer is correct - The pattern follows the intended direction: Alice -> works_on -> project -> funded_by -> department. It directly captures the chain of relationships and returns the desired property. 5. Why the other options are incorrect - Option 2: MATCH (a:Person {name:'Alice'})<-[:WORKS_ON]-(p)-[:FUNDED_BY]->(d) reverses WORKS_ON, implying the project works on Alice (wrong direction). - Option 3: MATCH (a:Person {name:'Alice'})-[:FUNDED_BY]->(d) assumes Alice is directly funded by a department, skipping the project. - Option 4: MATCH (a)-[:WORKS_ON]->(p)<-[:FUNDED_BY]-(d) reverses FUNDED_BY, implying the department is funded by the project (wrong direction); also it returns d (node) rather than d.name. - Option 5: “None of the above” is incorrect because option 1 is valid. 6. Conclusion The correct query is MATCH (a:Person {name:'Alice'})-[:WORKS_ON]->(p)-[:FUNDED_BY]->(d) RETURN d.name, which matches the provided answer.

Q 19: Which query returns the department that funds the project Alice works on?单项选择题

类似问题

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

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

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

学校历年真题

智能刷题助手

智能匹配练习

希望你的学习变得更简单