Questions
COMP4338 COMP5338 (NE) Out of Class Quiz -- Week 7
Multiple choice
Which queries find people who both acted in and directed the same movie in neo4j's sample Movie Graph? Select all that apply.
Options
A.MATCH (p:Person)-[DIRECTED]->(m:Movie)
WHERE (p)-[:ACTED_IN]->(m)
RETURN p.name, m.title;
B.MATCH (p:Person), (m:Movie)
WHERE (p)-[:ACTED_IN]->(m) AND (p)-[:DIRECTED]->(m)
RETURN p.name, m.title;
C.MATCH (p:Person)-[:ACTED_IN]->(m:Movie)<-[:DIRECTED]-(p)
RETURN p.name, m.title;
D.MATCH (p:Person)-[:ACTED_IN]->(m:Movie)
WHERE (p)-[:DIRECTED]->(m)
RETURN p.name, m.title;
View Explanation
Verified Answer
Please login to view
Step-by-Step Analysis
Let’s break down what the question is asking: identify queries that return people who both acted in and directed the same movie in the Movie Graph. Each option will be assessed on whether it enforces that p is the same person for both acting and directing a given movie m.
Option 1: MATCH (p:Person)-[DIRECTED]->(m:Movie) WHERE (p)-[:ACTED_IN]->(m) RETURN p.name, m.title;
This starts by finding a person p who directed a movie m, and......Login to view full explanationLog in for full answers
We've collected over 50,000 authentic exam questions and detailed explanations from around the globe. Log in now and get instant access to the answers!
Similar Questions
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
In a consumer society, many adults channel creativity into buying things
Economic stress and unpredictable times have resulted in a booming industry for self-help products
People born without creativity never can develop it
More Practical Tools for Students Powered by AI Study Helper
Making Your Study Simpler
Join us and instantly unlock extensive past papers & exclusive solutions to get a head start on your studies!