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

Question

BlackTom AI · Accepted Answer

In Cypher, the pattern (a)-[:REL]->(b) denotes that node a has an outgoing REL relationship to node b, so an outgoing MANAGES edge from Bob to p will correctly find people Bob manages. Relevant concepts: - Node labels (e.g., :Person) identify node types. - Property matching (e.g., {name:'Bob'}) selects the specific node. - Relationship direction matters: -[:MANAGES]-> means “left node MANAGES right node”; <-[:MANAGES]- is the opposite. - RETURN specifies which values to output. Step-by-step reasoning: 1. Locate Bob as a Person: (b:Person {name:'Bob'}). This ensures Bob is the starting node and matches the correct label and property. 2. Follow an outgoing MANAGES relationship from Bob to other people: -[:MANAGES]->(p:Person). The arrow points right, indicating Bob manages p. 3. Return the names of the matched people: RETURN p.name. Complete pattern: MATCH (b:Person {name:'Bob'})-[:MANAGES]->(p:Person) RETURN p.name Why this is correct: - The pattern explicitly matches a Person node named Bob, then an outgoing MANAGES relationship to another Person node p. That is precisely the definition of “people who are managed by Bob.” The RETURN clause yields their names. Why other options are incorrect: - Option 2: MATCH (p:Person)-[:MANAGES]->(b:Person {name:'Bob'}) — this finds people p who MANAGE Bob (i.e., Bob is the target), the reverse of what’s requested. - Option 3: MATCH (b:Person)<-[:MANAGES]-(p:Person) — arrow direction shows p -> b (p manages b) and also lacks the name filter for Bob, so it does not restrict to Bob specifically. - Option 4: MATCH (b:Manager {name:'Bob'})<-[:MANAGES]-(p:Person) — uses label :Manager (not :Person) and arrow direction is reversed; it finds people who manage Bob (if Bob were labeled Manager), not people Bob manages. - Option 5: “None of the above” is wrong because option 1 is correct. Conclusion: The correct query is MATCH (b:Person {name:'Bob'})-[:MANAGES]->(p:Person) RETURN p.name, which matches the provided answer.

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

Similar Questions

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 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;

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