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?Single choice

Similar Questions

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.

Report the skewness statistic of the journey elapsed time amongst respondents who do not live in regional areas. Report your answer to 2 decimal places.

More Practical Tools for Students Powered by AI Study Helper

Homework AI Solver

Stylized AI Paper Writer

Plagiarism Checker Assistant

Citation AI Academic Writing Tool

In-Class Translation Assistant

AI Note Generator

AI Quiz Answers

Past Exam Questions from University Test Bank

Smart Practice Assistant

Adaptive Practice

Making Your Study Simpler